>>create schema seqsch;

--- SQL operation complete.
>>set schema seqsch;

--- SQL operation complete.
>>obey TEST024(setup);
>>
>>initialize trafodion, create metadata views;

--- SQL operation complete.
>>
>>create sequence test024seq0;

--- SQL operation complete.
>>
>>-- return error
>>create sequence test024seq0;

*** ERROR[1390] Object TRAFODION.SEQSCH.TEST024SEQ0 already exists in Trafodion.

--- SQL operation failed with errors.
>>
>>create sequence test024seq1;

--- SQL operation complete.
>>create sequence test024seq2 start with 10 minvalue 1 maxvalue 15 increment by 3 cache 2;

--- SQL operation complete.
>>create sequence test024seq3 maxvalue 3 cycle;

--- SQL operation complete.
>>create sequence test024seq4 maxvalue 3 no cache;

--- SQL operation complete.
>>create sequence test024seq5 minvalue 2 maxvalue 5 cache 4;

--- SQL operation complete.
>>create sequence test024seq6 maxvalue 8 cache 3 increment by 2;

--- SQL operation complete.
>>create sequence test024seq7;

--- SQL operation complete.
>>
>>showddl sequence test024seq0;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ0
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq1;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ1
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq2;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ2
  START WITH 10 /* NEXT AVAILABLE VALUE 10 */
  INCREMENT BY 3
  MAXVALUE 15
  MINVALUE 1
  CACHE 2
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq3;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ3
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 3
  MINVALUE 1
  CACHE 3
  CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq4;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ4
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 3
  MINVALUE 1
  NO CACHE
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq5;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ5
  START WITH 2 /* NEXT AVAILABLE VALUE 2 */
  INCREMENT BY 1
  MAXVALUE 5
  MINVALUE 2
  CACHE 4
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>showddl sequence test024seq6;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ6
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 2
  MAXVALUE 8
  MINVALUE 1
  CACHE 3
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>alter sequence test024seq2 minvalue 5;

*** ERROR[1592] MINVALUE cannot be specified for ALTER SEQUENCE.

--- SQL operation failed with errors.
>>showddl sequence test024seq2;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ2
  START WITH 10 /* NEXT AVAILABLE VALUE 10 */
  INCREMENT BY 3
  MAXVALUE 15
  MINVALUE 1
  CACHE 2
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>drop sequence test024seq0;

--- SQL operation complete.
>>showddl sequence test024seq0;

*** ERROR[1389] Object TEST024SEQ0 does not exist in Trafodion.

*** ERROR[1389] Object TRAFODION.SEQSCH.TEST024SEQ0 does not exist in Trafodion.

--- SQL operation failed with errors.
>>
>>set schema temp;

--- SQL operation complete.
>>get sequences in schema seqsch;

Sequences in schema TRAFODION.SEQSCH
====================================

TEST024SEQ1
TEST024SEQ2
TEST024SEQ3
TEST024SEQ4
TEST024SEQ5
TEST024SEQ6
TEST024SEQ7

=======================
 7 row(s) returned

--- SQL operation complete.
>>set schema seqsch;

--- SQL operation complete.
>>
>>create table test024t1 (a int not null primary key, b int not null);

--- SQL operation complete.
>>create table test024t2 (z int not null primary key, a int not null, b int not null);

--- SQL operation complete.
>>
>>obey TEST024(select_queries);
>>-- next 3 stmts will return 1, 2, 2
>>select seqnum(test024seq1) from (values(1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>select seqnum(test024seq1, next) from (values(1)) x(a);

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>select seqnum(test024seq1, current) from (values(1)) x(a);

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>
>>-- next 3 stmts will return 10, 13, error
>>select seqnum(test024seq2) from (values(1)) x(a);

(EXPR)              
--------------------

                  10

--- 1 row(s) selected.
>>select seqnum(test024seq2) from (values(1)) x(a);

(EXPR)              
--------------------

                  13

--- 1 row(s) selected.
>>select seqnum(test024seq2) from (values(1)) x(a);

*** ERROR[1579] This sequence has reached its max and cannot provide a new value.

--- 0 row(s) selected.
>>
>>-- Next 4 stmts will return 1,2,3,1
>>select seqnum(test024seq3) from (values(1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>select seqnum(test024seq3) from (values(1)) x(a);

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>select seqnum(test024seq3) from (values(1)) x(a);

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>select seqnum(test024seq3) from (values(1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>showddl sequence test024seq3;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ3
  START WITH 1 /* NEXT AVAILABLE VALUE 4 */
  INCREMENT BY 1
  MAXVALUE 3
  MINVALUE 1
  CACHE 3
  CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>-- Next 3 stmts will return 1,2,3
>>select seqnum(test024seq4) from (values(1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>select seqnum(test024seq4) from (values(1)) x(a);

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>select seqnum(test024seq4) from (values(1)) x(a);

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>showddl sequence test024seq4;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ4
  START WITH 1 /* NEXT AVAILABLE VALUE 4 */
  INCREMENT BY 1
  MAXVALUE 3
  MINVALUE 1
  NO CACHE
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>-- Next 5 stmts will return 2,3,4,5,error
>>select seqnum(test024seq5) from (values(1)) x(a);

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>select seqnum(test024seq5) from (values(1)) x(a);

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>select seqnum(test024seq5) from (values(1)) x(a);

(EXPR)              
--------------------

                   4

--- 1 row(s) selected.
>>select seqnum(test024seq5) from (values(1)) x(a);

(EXPR)              
--------------------

                   5

--- 1 row(s) selected.
>>select seqnum(test024seq5) from (values(1)) x(a);

*** ERROR[1579] This sequence has reached its max and cannot provide a new value.

--- 0 row(s) selected.
>>
>>-- Next 4 stmts will return 1,3,5,7,error
>>select seqnum(test024seq6) from (values(1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>select seqnum(test024seq6) from (values(1)) x(a);

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>select seqnum(test024seq6) from (values(1)) x(a);

(EXPR)              
--------------------

                   5

--- 1 row(s) selected.
>>select seqnum(test024seq6) from (values(1)) x(a);

(EXPR)              
--------------------

                   7

--- 1 row(s) selected.
>>select seqnum(test024seq6) from (values(1)) x(a);

*** ERROR[1579] This sequence has reached its max and cannot provide a new value.

--- 0 row(s) selected.
>>
>>select left(trim(schema_name) || '.' || trim(seq_name), 40), num_calls from 
+>  "_MD_".sequences_view where schema_name = 'SEQSCH';

(EXPR)                                                                                                                                                            NUM_CALLS
----------------------------------------------------------------------------------------------------------------------------------------------------------------  --------------------

SEQSCH.TEST024SEQ1                                                                                                                                                                   1
SEQSCH.TEST024SEQ2                                                                                                                                                                   2
SEQSCH.TEST024SEQ3                                                                                                                                                                   3
SEQSCH.TEST024SEQ4                                                                                                                                                                   3
SEQSCH.TEST024SEQ5                                                                                                                                                                   2
SEQSCH.TEST024SEQ6                                                                                                                                                                   3
SEQSCH.TEST024SEQ7                                                                                                                                                                   0

--- 7 row(s) selected.
>>
>>-- where preds
>>insert into test024t1 values (1,1), (2,2);

--- 2 row(s) inserted.
>>
>>-- return 0 rows
>>select * from test024t1 where a < seqnum(test024seq7);

--- 0 row(s) selected.
>>
>>-- return 1
>>select * from test024t1 where a < seqnum(test024seq7);

A            B          
-----------  -----------

          1            1

--- 1 row(s) selected.
>>
>>-- return 1,2
>>select * from test024t1 where a < seqnum(test024seq7);

A            B          
-----------  -----------

          1            1
          2            2

--- 2 row(s) selected.
>>
>>
>>obey TEST024(insert_queries);
>>delete from test024t1;

--- 2 row(s) deleted.
>>insert into test024t1 values (seqnum(test024seq7), 10);

--- 1 row(s) inserted.
>>insert into test024t1 values (seqnum(test024seq7), 10);

--- 1 row(s) inserted.
>>insert into test024t1 values (seqnum(test024seq7), 10);

--- 1 row(s) inserted.
>>
>>-- error, dup insert
>>insert into test024t1 values (seqnum(test024seq7, current), 10);

*** ERROR[8102] The operation is prevented by a unique constraint.

--- 0 row(s) inserted.
>>
>>-- return 4,5,6
>>select * from test024t1;

A            B          
-----------  -----------

          4           10
          5           10
          6           10

--- 3 row(s) selected.
>>
>>-- inserts 7,8,9
>>insert into test024t2 select seqnum(test024seq7), a, b from test024t1;

--- 3 row(s) inserted.
>>
>>-- return 7,8,9
>>select * from test024t2;

Z            A            B          
-----------  -----------  -----------

          7            4           10
          8            5           10
          9            6           10

--- 3 row(s) selected.
>>
>>-- seq num generation is independent of enclosing explicit or implicit transaction
>>drop sequence test024seq8;

*** ERROR[1389] Object TRAFODION.SEQSCH.TEST024SEQ8 does not exist in Trafodion.

--- SQL operation failed with errors.
>>create sequence test024seq8;

--- SQL operation complete.
>>begin work;

--- SQL operation complete.
>>showddl sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>select seqnum(test024seq8) from (values (1)) x(a);

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>showddl sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 26 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>rollback work;

--- SQL operation complete.
>>showddl sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 26 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>drop sequence test024seq8;

--- SQL operation complete.
>>create sequence test024seq8;

--- SQL operation complete.
>>showddl sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>delete from test024t1;

--- 3 row(s) deleted.
>>insert into test024t1 values (1,1);

--- 1 row(s) inserted.
>>insert into test024t1 values (seqnum(test024seq8), 10);

*** ERROR[8102] The operation is prevented by a unique constraint.

--- 0 row(s) inserted.
>>showddl sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 26 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 25
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>
>>-- alter sequence
>>drop sequence test024seq8;

--- SQL operation complete.
>>create sequence test024seq8 cache 5;

--- SQL operation complete.
>>prepare s from select seqnum(test024seq8) from (values (1)) x(a);

--- SQL command prepared.
>>showddl  sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 1 */
  INCREMENT BY 1
  MAXVALUE 9223372036854775806
  MINVALUE 1
  CACHE 5
  NO CYCLE
  LARGEINT
;

--- SQL operation complete.
>>execute s;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>alter sequence test024seq8 maxvalue 2 cycle;

--- SQL operation complete.
>>showddl  sequence test024seq8;

CREATE SEQUENCE TRAFODION.SEQSCH.TEST024SEQ8
  START WITH 1 /* NEXT AVAILABLE VALUE 6 */
  INCREMENT BY 1
  MAXVALUE 2
  MINVALUE 1
  CACHE 5
  CYCLE
  LARGEINT
;

--- SQL operation complete.
>>execute s;

(EXPR)              
--------------------

                   4

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   5

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>create sequence test024seq9 no cache;

--- SQL operation complete.
>>prepare s from select seqnum(test024seq9) from (values (1)) x(a);

--- SQL command prepared.
>>execute s;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>execute s;

(EXPR)              
--------------------

                   2

--- 1 row(s) selected.
>>alter sequence test024seq9 reset;

--- SQL operation complete.
>>execute s;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>
>>-- select from metadata sequences view
>>invoke trafodion."_MD_".sequences_view;

-- Definition of Trafodion view TRAFODION."_MD_".SEQUENCES_VIEW
-- Definition current  Tue May  2 20:12:05 2017

  (
    CATALOG_NAME                     VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , SCHEMA_NAME                      VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , SEQ_NAME                         VARCHAR(256 BYTES) CHARACTER SET UTF8
      COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , START_VALUE                      LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , INCREMENT                        LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , MAX_VALUE                        LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , MIN_VALUE                        LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , CYCLE_OPTION                     CHAR(2) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , CACHE_OPTION                     CHAR(1) CHARACTER SET ISO88591 COLLATE
      DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
  , CACHE_SIZE                       LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , NEXT_VALUE                       LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  , NUM_CALLS                        LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  )

--- SQL operation complete.
>>select catalog_name, schema_name, seq_name, start_value, increment, max_value, min_value, cycle_option, cache_option, cache_size, next_value from trafodion."_MD_".sequences_view where schema_name = 'SEQSCH';

CATALOG_NAME                                                                                                                                                                                                                                                      SCHEMA_NAME                                                                                                                                                                                                                                                       SEQ_NAME                                                                                                                                                                                                                                                          START_VALUE           INCREMENT             MAX_VALUE             MIN_VALUE             CYCLE_OPTION  CACHE_OPTION  CACHE_SIZE            NEXT_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  --------------------  --------------------  --------------------  --------------------  ------------  ------------  --------------------  --------------------

TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ1                                                                                                                                                                                                                                                                          1                     1   9223372036854775806                     1  N             Y                               25                    26
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ2                                                                                                                                                                                                                                                                         10                     3                    15                     1  N             Y                                2                    16
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ3                                                                                                                                                                                                                                                                          1                     1                     3                     1  Y             Y                                3                     4
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ4                                                                                                                                                                                                                                                                          1                     1                     3                     1  N             N                                0                     4
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ5                                                                                                                                                                                                                                                                          2                     1                     5                     2  N             Y                                4                     6
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ6                                                                                                                                                                                                                                                                          1                     2                     8                     1  N             Y                                3                     9
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ7                                                                                                                                                                                                                                                                          1                     1   9223372036854775806                     1  N             Y                               25                    26
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ8                                                                                                                                                                                                                                                                          1                     1                     2                     1  Y             Y                                5                     6
TRAFODION                                                                                                                                                                                                                                                         SEQSCH                                                                                                                                                                                                                                                            TEST024SEQ9                                                                                                                                                                                                                                                                          1                     1   9223372036854775806                     1  N             N                                0                     2

--- 9 row(s) selected.
>>
>>obey TEST024(error_cases);
>>create sequence error_seq maxvalue -1;

*** ERROR[1572] MAXVALUE value cannot be a negative number for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue -1;

*** ERROR[1572] MINVALUE value cannot be a negative number for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq maxvalue 0;

*** ERROR[1571] MAXVALUE value cannot be zero for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 0;

*** ERROR[1571] MINVALUE value cannot be zero for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 10 maxvalue 5;

*** ERROR[1570] MAXVALUE must be greater than MINVALUE for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq increment by  0;

*** ERROR[1571] INCREMENT BY value cannot be zero for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq increment by  -1;

*** ERROR[1572] INCREMENT BY value cannot be a negative number for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 11 maxvalue 23 increment by 14;

*** ERROR[1575] INCREMENT BY value cannot be greater than the difference between MINVALUE and MAXVALUE for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 5 maxvalue 10 start with 3;

*** ERROR[1573] START WITH value must be greater than or equal to MINVALUE and less than or equal to MAXVALUE for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 5 maxvalue 10 start with 20;

*** ERROR[1573] START WITH value must be greater than or equal to MINVALUE and less than or equal to MAXVALUE for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq cache 1;

*** ERROR[1577] CACHE value must be greater than 1 and less than or equal to (maxValue-startValue+1)/incrementValue for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>create sequence error_seq minvalue 1 maxvalue 3 cache 10;

*** ERROR[1577] CACHE value must be greater than 1 and less than or equal to (maxValue-startValue+1)/incrementValue for CREATE SEQUENCE.

--- SQL operation failed with errors.
>>alter sequence error_seq start with 50;

*** ERROR[1389] Object ERROR_SEQ does not exist in Trafodion.

*** ERROR[1389] Object TRAFODION.SEQSCH.ERROR_SEQ does not exist in Trafodion.

--- SQL operation failed with errors.
>>create sequence error_seq;

--- SQL operation complete.
>>create sequence error_seq reset;

*** ERROR[15001] A syntax error occurred at or before: 
create sequence error_seq reset;
                              ^ (31 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>alter sequence error_seq start with 50;

*** ERROR[1592] START WITH cannot be specified for ALTER SEQUENCE.

--- SQL operation failed with errors.
>>
>>
>>obey TEST024(clean_up);
>>drop sequence test024seq0;

*** ERROR[1389] Object TRAFODION.SEQSCH.TEST024SEQ0 does not exist in Trafodion.

--- SQL operation failed with errors.
>>drop sequence test024seq1;

--- SQL operation complete.
>>drop sequence test024seq2;

--- SQL operation complete.
>>drop sequence test024seq3;

--- SQL operation complete.
>>drop sequence test024seq4;

--- SQL operation complete.
>>drop sequence test024seq5;

--- SQL operation complete.
>>drop sequence test024seq6;

--- SQL operation complete.
>>drop sequence test024seq7;

--- SQL operation complete.
>>drop sequence test024seq8;

--- SQL operation complete.
>>drop sequence test024seq9;

--- SQL operation complete.
>>drop sequence error_seq;

--- SQL operation complete.
>>
>>drop table test024t1;

--- SQL operation complete.
>>drop table test024t2;

--- SQL operation complete.
>>
>>drop schema seqsch cascade;

--- SQL operation complete.
>>
>>log;