Changeset: f30578562d7c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f30578562d7c Modified Files: sql/test/miscellaneous/Tests/simple_selects.test Branch: default Log Message:
The 0 as a sequence maxvalue case has yet to be fixed diffs (34 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 @@ -928,4 +928,30 @@ 8 9 statement ok +create sequence ups2 INCREMENT BY 1 MINVALUE -10 MAXVALUE 0 CYCLE + +query I nosort +select next value for ups2 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
