Changeset: 683de6848db7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=683de6848db7 Modified Files: sql/test/BugTracker-2008/Tests/year_overflow_bug.SF-2075133.test Branch: mtest Log Message:
change test from 9999->10000 into year overflow from 1999 -> 2000. added comment that we do support this (out of spec) feature of more than 4 digits years, but that we only test 1999->2000 because other dbs and pymonetdb cannot handle this. diffs (24 lines): diff --git a/sql/test/BugTracker-2008/Tests/year_overflow_bug.SF-2075133.test b/sql/test/BugTracker-2008/Tests/year_overflow_bug.SF-2075133.test --- a/sql/test/BugTracker-2008/Tests/year_overflow_bug.SF-2075133.test +++ b/sql/test/BugTracker-2008/Tests/year_overflow_bug.SF-2075133.test @@ -1,14 +1,18 @@ statement ok CREATE TABLE A (a DATE) +# Within a <datetime literal>, the <years value> shall contain four digits. +# do see this a a feature (ie 9999 -> 10000) +# but as pymonetdb and other db's don't support this we changed the test (not the code) + statement ok -INSERT INTO A VALUES ( DATE '9999-01-01' + INTERVAL '1-00' YEAR TO MONTH) +INSERT INTO A VALUES ( DATE '1999-01-01' + INTERVAL '1-00' YEAR TO MONTH) query T nosort -- This currently is a limitation of pymonetdb select * from A ---- -10000-01-01 +2000-01-01 statement ok drop table a _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
