[jira] [Created] (TRAFODION-905) LP Bug: 1411864 - Alter Sequence allows MAXVALUE one over max value

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-905:
------------------------------------

             Summary: LP Bug: 1411864 - Alter Sequence allows MAXVALUE one over max value
                 Key: TRAFODION-905
                 URL: https://issues.apache.org/jira/browse/TRAFODION-905
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Chong Hsu
            Assignee: Anoop Sharma
            Priority: Minor
             Fix For: 1.1 (pre-incubation)


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]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)