Changeset: fcdd45954b56 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fcdd45954b56
Modified Files:
sql/test/SQLancer/Tests/sqlancer18.test
sql/test/odbc-escape-sequences/Tests/literals.test
sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test
sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
Branch: Jun2023
Log Message:
Approve after pymonetdb upgrade.
diffs (truncated from 788 to 300 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer18.test
b/sql/test/SQLancer/Tests/sqlancer18.test
--- a/sql/test/SQLancer/Tests/sqlancer18.test
+++ b/sql/test/SQLancer/Tests/sqlancer18.test
@@ -1,3 +1,5 @@
+hash-threshold 1000
+
statement ok
START TRANSACTION
@@ -256,7 +258,141 @@ 135
query R rowsort
SELECT sub0.c2 FROM t2 JOIN (SELECT DISTINCT t2.c2, 3 FROM t2) AS sub0(c2,c3)
on t2.c2 = sub0.c2
----
-135 values hashing to 39898748a4604c294a5bcb3435b482a0
+-0.000
+-1.000
+-1.000
+-1087290368.000
+-1268147100.000
+-1462578700.000
+-170186860000000000.000
+-2044814500.000
+-444399328.000
+-5.000
+-5.370
+-6.000
+-707779136.000
+-8.000
+-809476200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545200.000
+-870545216.000
+-870545216.000
+-870545216.000
+-946846140.000
+0.000
+0.000
+0.000
+0.000
+0.000
+0.002
+0.029
+0.071
+0.104
+0.121
+0.124
+0.126
+0.172
+0.181
+0.185
+0.188
+0.212
+0.235
+0.244
+0.254
+0.256
+0.283
+0.292
+0.293
+0.293
+0.295
+0.307
+0.311
+0.325
+0.348
+0.356
+0.357
+0.357
+0.360
+0.374
+0.379
+0.384
+0.391
+0.419
+0.438
+0.458
+0.492
+0.493
+0.494
+0.514
+0.517
+0.536
+0.538
+0.550
+0.560
+0.579
+0.581
+0.607
+0.613
+0.624
+0.643
+0.644
+0.656
+0.709
+0.753
+0.755
+0.766
+0.779
+0.792
+0.793
+0.840
+0.842
+0.868
+0.899
+0.911
+0.952
+0.972
+0.974
+1.000
+1.000
+1.000
+110847336.000
+1507661312.000
+1828550000.000
+195935090.000
+195935090.000
+1969755300.000
+2.000
+2070646272.000
+2070646272.000
+3.000
+3.000
+3.142
+4.000
+4.000
+4.000
+5.000
+5.000
+6.000
+6.000
+600810368.000
+7.000
+7.000
+89812210.000
statement ok
ROLLBACK
diff --git a/sql/test/odbc-escape-sequences/Tests/literals.test
b/sql/test/odbc-escape-sequences/Tests/literals.test
--- a/sql/test/odbc-escape-sequences/Tests/literals.test
+++ b/sql/test/odbc-escape-sequences/Tests/literals.test
@@ -81,8 +81,8 @@ 0:03:00
query TT rowsort
select {interval '4.567' second}, interval '4.567' second
----
-0:00:04
-0:00:04
+0:00:04.567000
+0:00:04.567000
query TT rowsort
select {interval '2 6' day to hour}, interval '2 6' day to hour
diff --git a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test
--- a/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test
+++ b/sql/test/sys-schema/Tests/webExamplesCastFunctionsOperators.test
@@ -102,7 +102,7 @@ 18:40:05
query T rowsort
select cast('2 18:40:05.123' as interval day to second(3))
----
-2 days, 18:40:05
+2 days, 18:40:05.123000
query T rowsort
select cast('2-5' as interval year to month)
@@ -268,7 +268,7 @@ 18:40:05
query T rowsort
select interval '2 18:40:05.123' day to second(3)
----
-2 days, 18:40:05
+2 days, 18:40:05.123000
query T rowsort
select interval '2-5' year to month
diff --git
a/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
--- a/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
+++ b/sql/test/sys-schema/Tests/webExamplesDateTimeFunctionsOperators.test
@@ -2,12 +2,12 @@ statement ok
SET TIME ZONE interval '+02:00' hour to minute
# Date/Time literal formats
-query T
+query T nosort
select date '2020-09-28'
----
2020-09-28
-query T
+query T nosort
select {d '2020-09-28'}
----
2020-09-28
@@ -18,483 +18,482 @@ 2020-09-28
#----
#-4712-01-01
-query T
+query T nosort
select time '18:40:05'
----
18:40:05
-query T
+query T nosort
select {t '18:40:05'}
----
18:40:05
-query T
+query T nosort
select time(6) '18:40:05.123456'
----
18:40:05.123456
-query T
+query T nosort
select time(3) with time zone '18:40:05.123+02:00'
----
18:40:05.123000+02:00
-query T
+query T nosort
select timestamp '2020-09-28 18:40:05'
----
2020-09-28 18:40:05
-query T
+query T nosort
select {ts '2020-09-28 18:40:05'}
----
2020-09-28 18:40:05
-query T
+query T nosort
select timestamp(6) '2020-09-28 18:40:05.123456'
----
2020-09-28 18:40:05.123456
-query T
+query T nosort
select timestamp(3) with time zone '2020-09-28 18:40:05.123+02:00'
----
2020-09-28 18:40:05.123000+02:00
-query T
+query T nosort
select interval '86399' second
----
23:59:59
-query T
+query T nosort
select {interval '86399' second}
----
23:59:59
-query T
+query T nosort
select interval '30' day
----
30
-query T
+query T nosort
select {interval '30' day}
----
30
-query T
+query T nosort
select interval '6' month
----
6
-query T
+query T nosort
select {interval '6' month}
----
6
-query T
+query T nosort
select interval '18:40:05' hour to second
----
18:40:05
-query T
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
