Changeset: 1a97d978eafb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/1a97d978eafb Modified Files: sql/test/pg_regress/Tests/date.test Branch: Jul2021 Log Message:
Approve after pymonetdb upgrade and remove duplicates. diffs (truncated from 405 to 300 lines): diff --git a/sql/test/pg_regress/Tests/date.test b/sql/test/pg_regress/Tests/date.test --- a/sql/test/pg_regress/Tests/date.test +++ b/sql/test/pg_regress/Tests/date.test @@ -1253,8 +1253,10 @@ SELECT date '1/18/1999' statement error SELECT date '18/1/1999' -statement error +query T rowsort SELECT date '01/02/03' +---- +0001-02-03 statement error SELECT date '19990108' @@ -1268,163 +1270,15 @@ SELECT date '1999.008' statement error SELECT date 'J2451187' -statement error +query T rowsort SELECT date 'January 8, 99 BC' - -statement error -SELECT date '99-Jan-08' - -query T rowsort -SELECT date '1999-Jan-08' ---- -1999-01-08 - -statement error -SELECT date '08-Jan-99' - -statement error -SELECT date '08-Jan-1999' - -statement error -SELECT date 'Jan-08-99' - -statement error -SELECT date 'Jan-08-1999' - -statement error -SELECT date '99-08-Jan' - -statement error -SELECT date '1999-08-Jan' - -statement error -SELECT date '99 Jan 08' - -query T rowsort -SELECT date '1999 Jan 08' ----- -1999-01-08 - -statement error -SELECT date '08 Jan 99' - -statement error -SELECT date '08 Jan 1999' - -statement error -SELECT date 'Jan 08 99' - -query T rowsort -SELECT date 'Jan 08 1999' ----- -1999-01-08 - -statement error -SELECT date '99 08 Jan' - -statement error -SELECT date '1999 08 Jan' - -statement error -SELECT date '99-01-08' +0099-01-08 query T rowsort -SELECT date '1999-01-08' ----- -1999-01-08 - -statement error -SELECT date '08-01-99' - -statement error -SELECT date '08-01-1999' - -statement error -SELECT date '01-08-99' - -statement error -SELECT date '01-08-1999' - -statement error -SELECT date '99-08-01' - -query T rowsort -SELECT date '1999-08-01' ----- -1999-08-01 - -statement error -SELECT date '99 01 08' - -query T rowsort -SELECT date '1999 01 08' +SELECT date '99-Jan-08' ---- -1999-01-08 - -statement error -SELECT date '08 01 99' - -statement error -SELECT date '08 01 1999' - -statement error -SELECT date '01 08 99' - -statement error -SELECT date '01 08 1999' - -statement error -SELECT date '99 08 01' - -query T rowsort -SELECT date '1999 08 01' ----- -1999-08-01 - -query T rowsort -SELECT date 'January 8, 1999' ----- -1999-01-08 - -query T rowsort -SELECT date '1999-01-08' ----- -1999-01-08 - -query T rowsort -SELECT date '1999-01-18' ----- -1999-01-18 - -statement error -SELECT date '1/8/1999' - -statement error -SELECT date '1/18/1999' - -statement error -SELECT date '18/1/1999' - -statement error -SELECT date '01/02/03' - -statement error -SELECT date '19990108' - -statement error -SELECT date '990108' - -statement error -SELECT date '1999.008' - -statement error -SELECT date 'J2451187' - -statement error -SELECT date 'January 8, 99 BC' - -statement error -SELECT date '99-Jan-08' +0099-01-08 query T rowsort SELECT date '1999-Jan-08' @@ -1449,8 +1303,10 @@ SELECT date '99-08-Jan' statement error SELECT date '1999-08-Jan' -statement error +query T rowsort SELECT date '99 Jan 08' +---- +0099-01-08 query T rowsort SELECT date '1999 Jan 08' @@ -1463,8 +1319,10 @@ SELECT date '08 Jan 99' statement error SELECT date '08 Jan 1999' -statement error +query T rowsort SELECT date 'Jan 08 99' +---- +0099-01-08 query T rowsort SELECT date 'Jan 08 1999' @@ -1477,8 +1335,10 @@ SELECT date '99 08 Jan' statement error SELECT date '1999 08 Jan' -statement error +query T rowsort SELECT date '99-01-08' +---- +0099-01-08 query T rowsort SELECT date '1999-01-08' @@ -1497,16 +1357,20 @@ SELECT date '01-08-99' statement error SELECT date '01-08-1999' -statement error +query T rowsort SELECT date '99-08-01' +---- +0099-08-01 query T rowsort SELECT date '1999-08-01' ---- 1999-08-01 -statement error +query T rowsort SELECT date '99 01 08' +---- +0099-01-08 query T rowsort SELECT date '1999 01 08' @@ -1525,160 +1389,10 @@ SELECT date '01 08 99' statement error SELECT date '01 08 1999' -statement error +query T rowsort SELECT date '99 08 01' - -query T rowsort -SELECT date '1999 08 01' ----- -1999-08-01 - -query T rowsort -SELECT date 'January 8, 1999' ----- -1999-01-08 - -query T rowsort -SELECT date '1999-01-08' ----- -1999-01-08 - -query T rowsort -SELECT date '1999-01-18' ----- -1999-01-18 - -statement error -SELECT date '1/8/1999' - -statement error -SELECT date '1/18/1999' - -statement error -SELECT date '18/1/1999' - -statement error -SELECT date '01/02/03' - -statement error -SELECT date '19990108' - -statement error -SELECT date '990108' - -statement error -SELECT date '1999.008' - -statement error -SELECT date 'J2451187' - -statement error -SELECT date 'January 8, 99 BC' - -statement error -SELECT date '99-Jan-08' - _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
