Changeset: 2f3c15cc2b97 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2f3c15cc2b97
Modified Files:
sql/test/2024/Tests/check.test
sql/test/BugTracker-2024/Tests/7580-date-diff.test
sql/test/BugTracker-2024/Tests/7582-ddl-exists.test
sql/test/BugTracker-2024/Tests/7587-rejectmismatch.test
sql/test/BugTracker-2024/Tests/7591-logical-expr.test
sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test
Branch: Aug2024
Log Message:
Normalize tests.
diffs (172 lines):
diff --git a/sql/test/2024/Tests/check.test b/sql/test/2024/Tests/check.test
--- a/sql/test/2024/Tests/check.test
+++ b/sql/test/2024/Tests/check.test
@@ -83,3 +83,4 @@ update bar set i = 10
statement ok
update bar set i = 1
+
diff --git a/sql/test/BugTracker-2024/Tests/7580-date-diff.test
b/sql/test/BugTracker-2024/Tests/7580-date-diff.test
--- a/sql/test/BugTracker-2024/Tests/7580-date-diff.test
+++ b/sql/test/BugTracker-2024/Tests/7580-date-diff.test
@@ -1,5 +1,4 @@
-
-query IIIIII
+query TTIIIT nosort
select t.d1, t.d2
, cast(extract(day from (t.d1 - t.d2)) as integer) as verschil
, cast(extract(day from (t.d1 - t.d2)) as integer) < 100 as f -- false
@@ -8,3 +7,4 @@ select t.d1, t.d2
from (select cast('2024-01-18' as date) as d1, cast('2013-06-06' as date) as
d2) t
where abs(cast(extract(day from (t.d1 - t.d2)) as integer)) < 100 -- this is
false, not true, so this shouldn't produce any result.
----
+
diff --git a/sql/test/BugTracker-2024/Tests/7582-ddl-exists.test
b/sql/test/BugTracker-2024/Tests/7582-ddl-exists.test
--- a/sql/test/BugTracker-2024/Tests/7582-ddl-exists.test
+++ b/sql/test/BugTracker-2024/Tests/7582-ddl-exists.test
@@ -1,3 +1,4 @@
statement ok
CREATE OR REPLACE FUNCTION test () RETURNS boolean
-BEGIN RETURN CASE WHEN EXISTS (SELECT id FROM sys._tables) THEN TRUE ELSE
FALSE END; END;
+BEGIN RETURN CASE WHEN EXISTS (SELECT id FROM sys._tables) THEN TRUE ELSE
FALSE END; END
+
diff --git a/sql/test/BugTracker-2024/Tests/7587-rejectmismatch.test
b/sql/test/BugTracker-2024/Tests/7587-rejectmismatch.test
--- a/sql/test/BugTracker-2024/Tests/7587-rejectmismatch.test
+++ b/sql/test/BugTracker-2024/Tests/7587-rejectmismatch.test
@@ -1,11 +1,11 @@
statement ok
-START TRANSACTION;
+START TRANSACTION
statement ok
-CALL sys.clearrejects();
+CALL sys.clearrejects()
statement ok
-CREATE TABLE foo(i INT, t TEXT, j INT);
+CREATE TABLE foo(i INT, t TEXT, j INT)
-- The file rejectmismatch.csv contains lines of the form
--
16,"bananabananabananabananabananabananabananabananabananabananabananabananabananabananabananabanana16",16
@@ -23,7 +23,7 @@ BEST EFFORT
-- 111 rejected lines, to be precise
-query I
+query I nosort
SELECT COUNT(*) FROM sys.rejects
----
111
@@ -44,7 +44,6 @@ ORDER BY n
LIMIT 1
----
-
-
statement ok
ROLLBACK
+
diff --git a/sql/test/BugTracker-2024/Tests/7591-logical-expr.test
b/sql/test/BugTracker-2024/Tests/7591-logical-expr.test
--- a/sql/test/BugTracker-2024/Tests/7591-logical-expr.test
+++ b/sql/test/BugTracker-2024/Tests/7591-logical-expr.test
@@ -33,3 +33,4 @@ SELECT * FROM t7591 WHERE (t7591.c0 = ''
statement ok
drop table t7591
+
diff --git
a/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test
b/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test
--- a/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test
+++ b/sql/test/BugTracker-2024/Tests/7593-double-as-text-notation-issue.test
@@ -1,62 +1,62 @@
-- certain doubles (ending with a 0 and (> 9999 or < -9990)) are converted to
scientific notation by the server, which is undesired.
-- this started with Aug2024, older servers didn't do this, so a regression
issue.
-query T
+query T nosort
select cast(cast(202909 as double) as varchar) as "expect 202909"
----
202909
-query T
+query T nosort
select cast(cast(202910 as double) as varchar) as "expect 202910"
----
202910
-query T
+query T nosort
select cast(cast(202911 as double) as varchar) as "expect 202911"
----
202911
-query T
+query T nosort
select cast(cast(20290 as double) as varchar) as "expect 20290"
----
20290
-query T
+query T nosort
select cast(cast(2020 as double) as varchar) as "expect 2020"
----
2020
-query T
+query T nosort
select cast(cast(20900 as double) as varchar) as "expect 20900"
----
20900
-query T
+query T nosort
select cast(cast(202900 as double) as varchar) as "expect 202900"
----
202900
-query T
+query T nosort
select cast(cast(202990 as double) as varchar) as "expect 202990"
----
202990
-query T
+query T nosort
select cast(cast(2029900 as double) as varchar) as "expect 2029900"
----
2029900
-query T
+query T nosort
select cast(cast(2029980 as double) as varchar) as "expect 2029980"
----
2029980
-query T
+query T nosort
select cast(cast(2029981 as double) as varchar) as "expect 2029981"
----
2029981
-query T
+query T nosort
select cast(cast(value as double) as varchar) from generate_series(9985,
10133) where value % 10 in (9,0,1)
----
9989
@@ -106,7 +106,7 @@ 10130
10131
-- idem for reals
-query T
+query T nosort
select cast(cast(value as real) as varchar) from generate_series(9985, 10133)
where value % 10 in (9,0,1)
----
9989
@@ -156,7 +156,7 @@ 10130
10131
-- idem for negative doubles
-query T
+query T nosort
select cast(cast(value as double) as varchar) from generate_series(-10131,
-9985) where value % 10 in (-9,0,-1)
----
-10131
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
