Changeset: 4afab9cfff8b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4afab9cfff8b Modified Files: sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message:
More sequences issues diffs (106 lines): diff --git a/sql/test/miscellaneous/Tests/simple_selects.test b/sql/test/miscellaneous/Tests/simple_selects.test --- a/sql/test/miscellaneous/Tests/simple_selects.test +++ b/sql/test/miscellaneous/Tests/simple_selects.test @@ -902,33 +902,33 @@ statement ok start transaction statement ok -create sequence ups INCREMENT BY 1 MINVALUE 0 MAXVALUE 10 CYCLE +create sequence ups START WITH 0 INCREMENT BY 1 MINVALUE 0 MAXVALUE 10 CYCLE -query I rowsort +query I nosort select next value for ups from generate_series(1,20) ---- 0 1 -1 -10 -2 2 3 -3 -4 4 5 -5 6 -6 -7 7 8 -8 9 +10 +0 +1 +2 +3 +4 +5 +6 +7 statement ok -create sequence ups2 INCREMENT BY 1 MINVALUE -10 MAXVALUE 0 CYCLE +create sequence ups2 START WITH -10 INCREMENT BY 1 MINVALUE -10 MAXVALUE 0 CYCLE query I nosort select next value for ups2 from generate_series(1,20) @@ -954,4 +954,56 @@ 0 -3 statement ok +create sequence ups3 START WITH -10 INCREMENT BY -1 MINVALUE -20 MAXVALUE -10 CYCLE + +query I nosort +select next value for ups3 from generate_series(1,20) +---- +-10 +-11 +-12 +-13 +-14 +-15 +-16 +-17 +-18 +-19 +-20 +-10 +-11 +-12 +-13 +-14 +-15 +-16 +-17 + +statement ok +create sequence ups4 START WITH 10 INCREMENT BY -1 MINVALUE 0 MAXVALUE 10 CYCLE + +query I nosort +select next value for ups4 from generate_series(1,20) +---- +10 +9 +8 +7 +6 +5 +4 +3 +2 +1 +0 +10 +9 +8 +7 +6 +5 +4 +3 + +statement ok rollback _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
