30 Sep
2022
30 Sep
'22
11:01 a.m.
create sequnce, the MAXVALUE is 2^63-1, it’s 9.22337204e18, “99999999999999999999” is oout of range. 1. Reduce this value to less than 9.22337204e18 2. or use “create large sequence”, the large sequence will support the MAXVALUE up to 2^127-1 -- Kamus <kamusis@gmail.com> 在 2022年9月30日 +0900 10:18，高岩 <gaoy551@163.com>，写道：
CREATE SEQUENCE SEQUENCE_A MINVALUE 1 MAXVALUE 99999999999999999999 INCREMENT BY 1 START WITH 1;
错误代码：[0]SQL错误码: = 22003
ERROR: value "99999999999999999999" is out of range for type bigint
希望帮忙解决 _______________________________________________ Community mailing list -- community@opengauss.org To unsubscribe send an email to community-leave@opengauss.org