MonetDB: Oct2020 - Reenable test, but with explicitly setting th...

[Sjoerd Mullender]

Changeset: eca29d0d38a6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/eca29d0d38a6
Modified Files:
        sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
        sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
Branch: Oct2020
Log Message:

Reenable test, but with explicitly setting the client's time zone.
I don't agree with the assessment that the result is incorrect.  The
timestamp is converted to the client's local time zone, and that is
entirely appropriate.


diffs (42 lines):

diff --git a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql 
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
@@ -1,3 +1,5 @@
+set time zone interval '+01:00' hour to minute;
+
 select cast(123 as varchar(10));
 select convert(123, decimal(10,3));
 
@@ -13,8 +15,8 @@ select cast('17:44:59.123456' as time);
 select cast('2020-07-29 17:44:59' as timestamp);
 select cast('2020-07-29T17:44:59' as timestamp);
 select cast('2020-07-29 17:44:59.123456' as timestamp);
---select cast('17:44:59.321+01:30' as timetz); -- produces wrong TZ +1:00 
instead of +1:30 also it changes to +02:00 when summertime starts so no stable 
output
---select cast('2020-07-29 17:44:59.321+01:30' as timestamptz); -- produces 
wrong TZ +1:00 instead of +1:30 also it changes to +02:00 when summertime 
starts so no stable output
+select cast('17:44:59.321+01:30' as timetz);
+select cast('2020-07-29 17:44:59.321+01:30' as timestamptz);
 select cast('1234' as interval month);
 select cast('86400.123' as interval second);
 
diff --git 
a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out 
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
@@ -83,6 +83,18 @@ stdout of test 'webExamplesCastFunctions
 % timestamp # type
 % 26 # length
 [ 2020-07-29 17:44:59.123456   ]
+#select cast('17:44:59.321+01:30' as timetz);
+% .%1 # table_name
+% %1 # name
+% timetz # type
+% 21 # length
+[ 17:14:59.321000+01:00        ]
+#select cast('2020-07-29 17:44:59.321+01:30' as timestamptz);
+% .%1 # table_name
+% %1 # name
+% timestamptz # type
+% 32 # length
+[ 2020-07-29 17:14:59.321000+01:00     ]
 #select cast('1234' as interval month);
 % .%1 # table_name
 % %1 # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list