Changeset: d710a882f0dd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d710a882f0dd
Modified Files:
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.sql
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.stable.out
Branch: Oct2020
Log Message:
Disabled two tests which produce non-stable output when summertime (or
wintertime) changes timezone.
diffs (36 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
@@ -13,8 +13,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);
-select cast('2020-07-29 17:44:59.321+01:30' as timestamptz); -- produces
wrong TZ +1:00 instead of +1:30
+--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('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,18 +83,6 @@ 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); -- produces
wrong TZ +1:00 instead of +1:30
-% .%1 # table_name
-% %1 # name
-% timestamptz # type
-% 32 # length
-[ 2020-07-29 17:14:59.321000+01:30 ]
#select cast('1234' as interval month);
% .%1 # table_name
% %1 # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
