Changeset: c87462d836b6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c87462d836b6
Modified Files:
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
Branch: default
Log Message:
Added SET TIME ZONE INTERVAL command to force same output on different
architectures independent of client
diffs (truncated from 770 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/timestamptz.sql
b/sql/test/pg_regress/Tests/timestamptz.sql
--- a/sql/test/pg_regress/Tests/timestamptz.sql
+++ b/sql/test/pg_regress/Tests/timestamptz.sql
@@ -127,7 +127,22 @@ INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan
INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 -0097');
INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 5097 BC');
-SELECT '' AS "64", d1 FROM TIMESTAMPTZ_TBL;
+INSERT INTO TIMESTAMPTZ_TBL VALUES (null);
+
+SET TIME ZONE INTERVAL '+01:00' HOUR TO MINUTE;
+SELECT '' AS "17", d1 FROM TIMESTAMPTZ_TBL;
+
+SET TIME ZONE INTERVAL '+04:30' HOUR TO MINUTE;
+SELECT d1 AS "Timestamp TZ" FROM TIMESTAMPTZ_TBL ORDER BY 1;
+
+SET TIME ZONE INTERVAL '+14:00' HOUR TO MINUTE;
+SELECT d1 AS "Timestamp TZ" FROM TIMESTAMPTZ_TBL ORDER BY 1;
+
+SET TIME ZONE INTERVAL '-07:00' HOUR TO MINUTE;
+SELECT d1 AS "Timestamp TZ" FROM TIMESTAMPTZ_TBL ORDER BY 1;
+
+SET TIME ZONE INTERVAL '+01:00' HOUR TO MINUTE;
+
-- Demonstrate functions and operators
SELECT '' AS "48", d1 FROM TIMESTAMPTZ_TBL
@@ -238,8 +253,6 @@ SELECT '' AS to_timestamp_16, to_timesta
/* SET DateStyle TO DEFAULT; */
-INSERT INTO TIMESTAMPTZ_TBL VALUES (null);
-
-- test MonetDB date functions
-- select distinct name, func, mod, language, type, schema_id from
sys.functions where id in (select func_id from sys.args where number in (0, 1)
and name in ('res_0', 'arg_1') and type = 'timestamptz') order by name, func,
schema_id
-- select current_timestamp(); -- retuns timestamptz
diff --git a/sql/test/pg_regress/Tests/timestamptz.stable.err
b/sql/test/pg_regress/Tests/timestamptz.stable.err
--- a/sql/test/pg_regress/Tests/timestamptz.stable.err
+++ b/sql/test/pg_regress/Tests/timestamptz.stable.err
@@ -29,314 +29,314 @@ stderr of test 'timestamptz` in director
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('tomorrow EST');
ERROR = !timestamp (tomorrow EST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('tomorrow zulu');
ERROR = !timestamp (tomorrow zulu) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('-infinity');
ERROR = !timestamp (-infinity) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('infinity');
ERROR = !timestamp (infinity) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('epoch');
ERROR = !timestamp (epoch) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('invalid');
ERROR = !timestamp (invalid) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST');
ERROR = !timestamp (Mon Feb 10 17:32:01 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Invalid Abstime');
ERROR = !timestamp (Invalid Abstime) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Undefined Abstime');
ERROR = !timestamp (Undefined Abstime) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.000001 1997
PST');
ERROR = !timestamp (Mon Feb 10 17:32:01.000001 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.999999 1997
PST');
ERROR = !timestamp (Mon Feb 10 17:32:01.999999 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.4 1997 PST');
ERROR = !timestamp (Mon Feb 10 17:32:01.4 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.5 1997 PST');
ERROR = !timestamp (Mon Feb 10 17:32:01.5 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mon Feb 10 17:32:01.6 1997 PST');
ERROR = !timestamp (Mon Feb 10 17:32:01.6 1997 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('19970210 173201 -0800'); --
incorrect format
ERROR = !timestamp (19970210 173201 -0800) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 10 17:32:01 1997 -0800');
ERROR = !timestamp (Feb 10 17:32:01 1997 -0800) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 10 17:32:01 1997');
ERROR = !timestamp (Feb 10 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 10 5:32PM 1997');
ERROR = !timestamp (Feb 10 5:32PM 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb-10-1997 17:32:01 PST');
ERROR = !timestamp (Feb-10-1997 17:32:01 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('02-10-1997 17:32:01 PST');
ERROR = !timestamp (02-10-1997 17:32:01 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('19970210 173201 PST');
ERROR = !timestamp (19970210 173201 PST) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('97FEB10 5:32:01PM UTC');
ERROR = !timestamp (97FEB10 5:32:01PM UTC) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('1997.041 17:32:01 UTC');
ERROR = !timestamp (1997.041 17:32:01 UTC) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 10 17:32:01 1997');
ERROR = !timestamp (Feb 10 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 11 17:32:01 1997');
ERROR = !timestamp (Feb 11 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 12 17:32:01 1997');
ERROR = !timestamp (Feb 12 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 13 17:32:01 1997');
ERROR = !timestamp (Feb 13 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 14 17:32:01 1997');
ERROR = !timestamp (Feb 14 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 15 17:32:01 1997');
ERROR = !timestamp (Feb 15 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1997');
ERROR = !timestamp (Feb 16 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 0097 BC');
ERROR = !timestamp (Feb 16 17:32:01 0097 BC) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 0097');
ERROR = !timestamp (Feb 16 17:32:01 0097) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 0597');
ERROR = !timestamp (Feb 16 17:32:01 0597) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1097');
ERROR = !timestamp (Feb 16 17:32:01 1097) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1697');
ERROR = !timestamp (Feb 16 17:32:01 1697) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1797');
ERROR = !timestamp (Feb 16 17:32:01 1797) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1897');
ERROR = !timestamp (Feb 16 17:32:01 1897) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 1997');
ERROR = !timestamp (Feb 16 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 2097');
ERROR = !timestamp (Feb 16 17:32:01 2097) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 28 17:32:01 1996');
ERROR = !timestamp (Feb 28 17:32:01 1996) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 29 17:32:01 1996');
ERROR = !timestamp (Feb 29 17:32:01 1996) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mar 01 17:32:01 1996');
ERROR = !timestamp (Mar 01 17:32:01 1996) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 30 17:32:01 1996');
ERROR = !timestamp (Dec 30 17:32:01 1996) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 31 17:32:01 1996');
ERROR = !timestamp (Dec 31 17:32:01 1996) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan 01 17:32:01 1997');
ERROR = !timestamp (Jan 01 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 28 17:32:01 1997');
ERROR = !timestamp (Feb 28 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 29 17:32:01 1997');
ERROR = !timestamp (Feb 29 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Mar 01 17:32:01 1997');
ERROR = !timestamp (Mar 01 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 30 17:32:01 1997');
ERROR = !timestamp (Dec 30 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 31 17:32:01 1997');
ERROR = !timestamp (Dec 31 17:32:01 1997) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 31 17:32:01 1999');
ERROR = !timestamp (Dec 31 17:32:01 1999) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan 01 17:32:01 2000');
ERROR = !timestamp (Jan 01 17:32:01 2000) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Dec 31 17:32:01 2000');
ERROR = !timestamp (Dec 31 17:32:01 2000) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Jan 01 17:32:01 2001');
ERROR = !timestamp (Jan 01 17:32:01 2001) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 -0097');
ERROR = !timestamp (Feb 16 17:32:01 -0097) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = INSERT INTO TIMESTAMPTZ_TBL VALUES ('Feb 16 17:32:01 5097 BC');
ERROR = !timestamp (Feb 16 17:32:01 5097 BC) has incorrect format
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS date_trunc_week, date_trunc( 'week', cast('2004-02-29
15:44:17.71393' as timestamptz) ) AS week_trunc;
ERROR = !SELECT: no such binary operator 'date_trunc(char,timestamptz)'
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS "54", d1 as timestamptz,
date_part( 'year', d1) AS "year", date_part( 'month', d1) AS
"month",
date_part( 'day', d1) AS "day", date_part( 'hour', d1) AS "hour",
date_part( 'minute', d1) AS "minute", date_part( 'second', d1) AS
"second"
FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';
ERROR = !SELECT: no such binary operator 'date_part(char,timestamptz)'
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS "54", d1 as timestamptz,
date_part( 'quarter', d1) AS quarter, date_part( 'msec', d1) AS
msec,
date_part( 'usec', d1) AS usec
FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';
ERROR = !SELECT: no such binary operator 'date_part(char,timestamptz)'
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS to_char_1, to_char(d1, 'DAY Day day DY Dy dy MONTH Month
month RM MON Mon mon')
FROM TIMESTAMPTZ_TBL;
ERROR = !SELECT: no such binary operator 'to_char(timestamptz,char)'
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS to_char_2, to_char(d1, 'FMDAY FMDay FMday FMMONTH FMMonth
FMmonth FMRM')
FROM TIMESTAMPTZ_TBL;
ERROR = !SELECT: no such binary operator 'to_char(timestamptz,char)'
-MAPI = (monetdb) /var/tmp/mtest-18336/.s.monetdb.30933
+MAPI = (monetdb) /var/tmp/mtest-16888/.s.monetdb.35236
QUERY = SELECT '' AS to_char_3, to_char(d1, 'Y,YYY YYYY YYY YY Y CC Q MM WW
DDD DD D J')
FROM TIMESTAMPTZ_TBL;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
