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
希望帮忙解决
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