Changeset: ddd1a3c8cf51 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ddd1a3c8cf51
Modified Files:
sql/test/orderidx/Tests/oidx_all_types.sql
sql/test/orderidx/Tests/oidx_all_types.stable.out
Branch: Dec2016
Log Message:
Added setting TIME ZONE explicitly to make output stable (independent of DST).
Approve new output (ordered Blob data results), after Changesets 4b93dae5fb21
and 675095ddbd82.
diffs (65 lines):
diff --git a/sql/test/orderidx/Tests/oidx_all_types.sql
b/sql/test/orderidx/Tests/oidx_all_types.sql
--- a/sql/test/orderidx/Tests/oidx_all_types.sql
+++ b/sql/test/orderidx/Tests/oidx_all_types.sql
@@ -1,3 +1,5 @@
+SET TIME ZONE INTERVAL '+01:00' HOUR TO MINUTE;
+
-- first create a table for all basic data types and fill it with some data
rows (including duplicate rows)
create table all_types (
"boolean" boolean,
diff --git a/sql/test/orderidx/Tests/oidx_all_types.stable.out
b/sql/test/orderidx/Tests/oidx_all_types.stable.out
--- a/sql/test/orderidx/Tests/oidx_all_types.stable.out
+++ b/sql/test/orderidx/Tests/oidx_all_types.stable.out
@@ -66,6 +66,7 @@ Ready.
# 15:05:54 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-13546" "--port=31953"
# 15:05:54 >
+#SET TIME ZONE INTERVAL '+01:00' HOUR TO MINUTE;
#create table all_types (
# "boolean" boolean,
# "tinyint" tinyint,
@@ -597,8 +598,8 @@ Ready.
% blob # type
% 0 # length
[ 123456 ]
+[ 123456 ]
[ 01234567 ]
-[ 123456 ]
[ 01234567 ]
#select "blob100" from all_types order by "blob100" ASC;
% sys.all_types # table_name
@@ -606,8 +607,8 @@ Ready.
% blob # type
% 0 # length
[ 123456 ]
+[ 123456 ]
[ 01234567 ]
-[ 123456 ]
[ 01234567 ]
#select "clob" from all_types order by "clob" ASC;
% sys.all_types # table_name
@@ -1086,6 +1087,24 @@ Ready.
[ 08:30:00.00000+01:00 ]
[ 07:30:00.00000+01:00 ]
[ 07:30:00.00000+01:00 ]
+#select "blob" from all_types order by "blob" DESC;
+% sys.all_types # table_name
+% blob # name
+% blob # type
+% 0 # length
+[ 01234567 ]
+[ 01234567 ]
+[ 123456 ]
+[ 123456 ]
+#select "blob100" from all_types order by "blob100" DESC;
+% sys.all_types # table_name
+% blob100 # name
+% blob # type
+% 0 # length
+[ 01234567 ]
+[ 01234567 ]
+[ 123456 ]
+[ 123456 ]
#select "clob" from all_types order by "clob" DESC;
% sys.all_types # table_name
% clob # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
