Changeset: ddca952aceb2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ddca952aceb2
Modified Files:
sql/test/pg_regress/Tests/date.sql
sql/test/pg_regress/Tests/date.stable.err
sql/test/pg_regress/Tests/date.stable.out
sql/test/pg_regress/Tests/time.sql
sql/test/pg_regress/Tests/time.stable.err
sql/test/pg_regress/Tests/time.stable.out
sql/test/pg_regress/Tests/timestamp.sql
sql/test/pg_regress/Tests/timestamp.stable.err
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.err
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/timetz.sql
sql/test/pg_regress/Tests/timetz.stable.err
sql/test/pg_regress/Tests/timetz.stable.out
sql/test/pg_regress/postgresql2sql99.sh
Branch: default
Log Message:
Adpated date.sql time.sql timtz.sql timestamp.sql and timestamptz.sql
to comply with MonetDB SQL compatible syntax
Added many substitution rules to postgresql2sql99.sh
diffs (truncated from 7015 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/date.sql
b/sql/test/pg_regress/Tests/date.sql
--- a/sql/test/pg_regress/Tests/date.sql
+++ b/sql/test/pg_regress/Tests/date.sql
@@ -31,9 +31,9 @@ SELECT f1 AS "Three" FROM DATE_TBL
--
-- Check all the documented input formats
--
-SET datestyle TO iso; -- display results in ISO
+/* SET datestyle TO iso; */ -- display results in ISO
-SET datestyle TO ymd;
+/* SET datestyle TO ymd; */
SELECT date 'January 8, 1999';
SELECT date '1999-01-08';
@@ -84,7 +84,7 @@ SELECT date '01 08 1999';
SELECT date '99 08 01';
SELECT date '1999 08 01';
-SET datestyle TO dmy;
+/* SET datestyle TO dmy; */
SELECT date 'January 8, 1999';
SELECT date '1999-01-08';
@@ -135,7 +135,7 @@ SELECT date '01 08 1999';
SELECT date '99 08 01';
SELECT date '1999 08 01';
-SET datestyle TO mdy;
+/* SET datestyle TO mdy; */
SELECT date 'January 8, 1999';
SELECT date '1999-01-08';
@@ -186,7 +186,7 @@ SELECT date '01 08 1999';
SELECT date '99 08 01';
SELECT date '1999 08 01';
-RESET datestyle;
+/* RESET datestyle; */
--
-- Simple math
diff --git a/sql/test/pg_regress/Tests/date.stable.err
b/sql/test/pg_regress/Tests/date.stable.err
--- a/sql/test/pg_regress/Tests/date.stable.err
+++ b/sql/test/pg_regress/Tests/date.stable.err
@@ -29,153 +29,376 @@ stderr of test 'date` in directory 'sql/
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-#--
-#-- DATE
-#--
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = INSERT INTO DATE_TBL VALUES ('1997-02-29');
-ERROR = date/time field value out of range: "1997-02-29"
-#--
-#-- Check all the documented input formats
-#--
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '1/8/1999';
-ERROR = date/time field value out of range: "1/8/1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '1/18/1999';
-ERROR = date/time field value out of range: "1/18/1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '18/1/1999';
-ERROR = date/time field value out of range: "18/1/1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date 'January 8, 99 BC';
-ERROR = date/time field value out of range: "January 8, 99 BC"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '19990108';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '990108';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1999.008';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'J2451187';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08-Jan-99';
-ERROR = date/time field value out of range: "08-Jan-99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08-Jan-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date 'Jan-08-99';
-ERROR = date/time field value out of range: "Jan-08-99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan-08-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '99-08-Jan';
-ERROR = invalid input syntax for type date: "99-08-Jan"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '1999-08-Jan';
-ERROR = invalid input syntax for type date: "1999-08-Jan"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08 Jan 99';
-ERROR = date/time field value out of range: "08 Jan 99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08 Jan 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date 'Jan 08 99';
-ERROR = date/time field value out of range: "Jan 08 99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan 08 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '99 08 Jan';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1999 08 Jan';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08-01-99';
-ERROR = date/time field value out of range: "08-01-99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08-01-1999';
-ERROR = date/time field value out of range: "08-01-1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '01-08-99';
-ERROR = date/time field value out of range: "01-08-99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '01-08-1999';
-ERROR = date/time field value out of range: "01-08-1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08 01 99';
-ERROR = date/time field value out of range: "08 01 99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '08 01 1999';
-ERROR = date/time field value out of range: "08 01 1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '01 08 99';
-ERROR = date/time field value out of range: "01 08 99"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '01 08 1999';
-ERROR = date/time field value out of range: "01 08 1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1/8/1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '1/18/1999';
-ERROR = date/time field value out of range: "1/18/1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99-Jan-08';
-ERROR = date/time field value out of range: "99-Jan-08"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '18/1/1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '19990108';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '990108';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1999.008';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'J2451187';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08-Jan-99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08-Jan-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan-08-99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan-08-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '99-08-Jan';
-ERROR = invalid input syntax for type date: "99-08-Jan"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '1999-08-Jan';
-ERROR = invalid input syntax for type date: "1999-08-Jan"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99 Jan 08';
-ERROR = date/time field value out of range: "99 Jan 08"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08 Jan 99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08 Jan 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan 08 99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date 'Jan 08 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '99 08 Jan';
-ERROR = invalid input syntax for type date: "99 08 Jan"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99-01-08';
-ERROR = date/time field value out of range: "99-01-08"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99-08-01';
-ERROR = date/time field value out of range: "99-08-01"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99 01 08';
-ERROR = date/time field value out of range: "99 01 08"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99 08 01';
-ERROR = date/time field value out of range: "99 08 01"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1999 08 Jan';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08-01-99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08-01-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '01-08-99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '01-08-1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08 01 99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '08 01 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '01 08 99';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '01 08 1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1/8/1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
+QUERY = SELECT date '1/18/1999';
+
+MAPI = (monetdb) /var/tmp/mtest-14259/.s.monetdb.38398
QUERY = SELECT date '18/1/1999';
-ERROR = date/time field value out of range: "18/1/1999"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
-QUERY = SELECT date '99-Jan-08';
-ERROR = date/time field value out of range: "99-Jan-08"
-MAPI = (monetdb) /var/tmp/mtest-12345/.s.monetdb.54321
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
