Alter Sequence allows MAXVALUE one over max value
Bug #1411864 reported by
Chong Hsu
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Committed
|
Low
|
Anoop Sharma |
Bug Description
Tested in 20150114 build.
Alter Sequence command allows MAXVALUE set to 922337203685477
SQL>CREATE SEQUENCE sq1;
--- SQL operation complete.
SQL>showddl SEQUENCE sq1;
CREATE SEQUENCE TRAFODION.HSU.SQ1
START WITH 1 /* NEXT AVAILABLE VALUE 1 */
INCREMENT BY 1
MAXVALUE 9223372036854775806
MINVALUE 1
CACHE 25
NO CYCLE
LARGEINT
;
SQL>alter sequence seq1 maxvalue 922337203685477
--- SQL operation complete.
SQL>create seq2 maxvalue 922337203685477
*** ERROR[1576] MAXVALUE value is greater than maximum allowed for this sequence. [2015-01-14 21:24:50]
Changed in trafodion: | |
assignee: | nobody → Anoop Sharma (anoop-sharma) |
milestone: | r1.0 → r1.1 |
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
status: | In Progress → Fix Committed |
To post a comment you must log in.