Alter Sequence allows MAXVALUE one over max value

Bug #1411864 reported by Chong Hsu
6
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 9223372036854775807, that is one over allowed max value. See the example below:

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 9223372036854775807;

--- SQL operation complete.

SQL>create seq2 maxvalue 9223372036854775807;

*** ERROR[1576] MAXVALUE value is greater than maximum allowed for this sequence. [2015-01-14 21:24:50]

Tags: sql-exe
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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.