Changeset: 1f6c078f80ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1f6c078f80ba
Modified Files:
sql/test/Dependencies/Tests/dependency_owner_schema_3.test
sql/test/SQLancer/Tests/sqlancer10.test
Branch: default
Log Message:
approved output
diffs (142 lines):
diff --git a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
--- a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
+++ b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test
@@ -126,7 +126,7 @@ DEP_FUNC
query TTT rowsort
SELECT c.name, v.name, 'DEP_VIEW' from sys.columns as c, sys.tables as v,
sys.dependencies as dep where c.id = dep.id AND v.id = dep.depend_id AND
dep.depend_type = 5 AND v.type in (1, 11, 21, 31) order by c.name, v.name
----
-2028 values hashing to b6e1dda84af6e29efe27713e347cf87d
+1974 values hashing to abcbd4ad07690fa48e84a43f050b9e94
query TTT rowsort
SELECT c.name, k.name, 'DEP_KEY' from sys.columns as c, sys.objects as kc,
sys.keys as k where kc."name" = c.name AND kc.id = k.id AND k.table_id =
c.table_id AND k.rkey = -1 order by c.name, k.name
@@ -190,7 +190,7 @@ SELECT c.name, i.name, 'DEP_INDEX' from
query TTT rowsort
SELECT c.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.columns as c,
sys.dependencies as dep where c.id = dep.id AND f.id = dep.depend_id AND
dep.depend_type = 7 ORDER BY c.name, f.name
----
-351 values hashing to 0357ee3f8bc7b05468e46a56d104a4e9
+264 values hashing to 8de72aae52a67c02cd49a46842f5a171
query TTT rowsort
SELECT c.name, tri.name, 'DEP_TRIGGER' from sys.columns as c, sys.objects as
tri, sys.dependencies as dep where dep.id = c.id AND dep.depend_id =tri.id AND
dep.depend_type = 8 order by c.name, tri.name
diff --git a/sql/test/SQLancer/Tests/sqlancer10.test
b/sql/test/SQLancer/Tests/sqlancer10.test
--- a/sql/test/SQLancer/Tests/sqlancer10.test
+++ b/sql/test/SQLancer/Tests/sqlancer10.test
@@ -71,8 +71,6 @@ sql.mvc
1
sql.tid
1
-sql.bind
-1
algebra.project
5
algebra.thetaselect
@@ -252,12 +250,10 @@ query T rowsort
SELECT t2.c1 FROM t0, t2 WHERE CAST(t0.c2 AS char(32)) > t2.c1
----
-
query R rowsort
SELECT t2.c4 FROM t0, t2 WHERE ((CAST(t0.c2 AS char(32)))>(CASE WHEN TRUE THEN
t2.c1 END))
----
-
query I rowsort
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(((CAST(t0.c2 AS
char(32)))>(CASE WHEN TRUE THEN t2.c1 END)) AS INT) as count FROM t0, t2) as res
----
@@ -282,7 +278,6 @@ query T rowsort
select case t0.c1 = any(select 2 from t1) when false then 'a' when true then
'b' end from t0
----
-
statement ok
ROLLBACK
@@ -387,7 +382,7 @@ PLAN SELECT (SELECT c0 FROM t0) FROM t0
----
project (
| single left outer join (
-| | table("sys"."t0") [ "t0"."c0" NOT NULL ] COUNT ,
+| | table("sys"."t0") [ "t0"."%TID%" NOT NULL ] COUNT ,
| | project (
| | | table("sys"."t0") [ "t0"."c0" NOT NULL ] COUNT
| | ) [ "t0"."c0" NOT NULL as "%1"."%1" ]
@@ -471,19 +466,19 @@ TRUE
statement ok
ROLLBACK
-query I rowsort
+query R rowsort
SELECT covar_pop(0.9, 0.5) FROM (select 762812975) t2(c0) WHERE t2.c0 IS NOT
NULL
----
-0
+0.000
-query I rowsort
+query R rowsort
SELECT covar_pop(0.9, 0.5) FROM (select 762812975) t2(c0) WHERE t2.c0 IS NOT
NULL HAVING ((SELECT TRUE)) = FALSE
UNION ALL
SELECT covar_pop(0.9, 0.5) FROM (select 762812975) t2(c0) WHERE t2.c0 IS NOT
NULL HAVING NOT (((SELECT TRUE)) = FALSE)
UNION ALL
SELECT covar_pop(0.9, 0.5) FROM (select 762812975) t2(c0) WHERE t2.c0 IS NOT
NULL HAVING (((SELECT TRUE)) = FALSE) IS NULL
----
-0
+0.000
statement ok
START TRANSACTION
@@ -521,7 +516,6 @@ WHERE FALSE) UNION DISTINCT (SELECT 0.98
GROUP BY CAST(least(-973138727, '1') AS BIGINT)
----
-
statement ok
ROLLBACK
@@ -552,12 +546,10 @@ query I rowsort
SELECT 1 FROM t2, t1 GROUP BY (SELECT 1 FROM t2 AS l1t2 WHERE FALSE) HAVING
((count(*))>=((SELECT DISTINCT 3 FROM t1 AS l2t1 WHERE FALSE)))
----
-
query I rowsort
SELECT 1 FROM t2, t1 GROUP BY (SELECT 1 FROM t2 AS l1t2 WHERE FALSE) HAVING
NOT (((count(*))>=((SELECT DISTINCT 3 FROM t1 AS l2t1 WHERE FALSE))))
----
-
query I rowsort
SELECT 1 FROM t2, t1 GROUP BY (SELECT 1 FROM t2 AS l1t2 WHERE FALSE) HAVING
(((count(*))>=((SELECT DISTINCT 3 FROM t1 AS l2t1 WHERE FALSE)))) IS NULL
----
@@ -579,7 +571,6 @@ query I rowsort
select 1 from t2 where 8 = any(select
0.8673676855585512601720665770699270069599151611328125 from t2) and (values
(true))
----
-
statement ok
ROLLBACK
@@ -758,15 +749,13 @@ query I rowsort
SELECT 1 FROM t1 RIGHT OUTER JOIN (SELECT 2) AS sub0 ON least((SELECT true
WHERE FALSE), true) WHERE NOT EXISTS ((SELECT 'b' WHERE FALSE) UNION ALL
(SELECT 'a'))
----
-
-query T rowsort
+query I rowsort
SELECT ALL t1.c1 FROM t0, t1 RIGHT OUTER JOIN ((SELECT DISTINCT ((least(6,
529595761))-(least(4, 1032827696))), least(-859534381,
0.01807380825433357873777140412130393087863922119140625)
FROM t0, t1 WHERE t0.c1 GROUP BY t1.c3) EXCEPT ALL (SELECT ALL - (COALESCE(2,
0.78330755, 0.6467953977457632230851913845981471240520477294921875, 1)), -
(0.24474563528854787) FROM t0, t1 WHERE t1.c3)) AS sub0 ON
least(((SELECT ALL l2t0.c1 FROM t0 AS l2t0, t2 AS l2t2, t1 AS l2t1 WHERE
FALSE) UNION ALL (SELECT DISTINCT l2t0.c1 FROM t0 AS l2t0 WHERE l2t0.c1)),
(t1.c3) BETWEEN ASYMMETRIC (t1.c1) AND (t1.c1)) WHERE
NOT EXISTS ((SELECT DISTINCT NULLIF('0.9825037007815074', 'sqR]&'), 20 WHERE
FALSE) UNION ALL (SELECT DISTINCT NULLIF(l1t0.c3, l1t0.c3), - (4) FROM t0 AS
l1t0 WHERE l1t0.c1))
----
-
query I rowsort
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(NOT EXISTS ((SELECT
DISTINCT NULLIF('0.9825037007815074', 'sqR]&'), 20 WHERE FALSE) UNION ALL
(SELECT DISTINCT NULLIF(l1t0.c3, l1t0.c3), - (4) FROM
t0 AS l1t0 WHERE l1t0.c1)) AS INT) as count FROM t0, t1 RIGHT OUTER JOIN
((SELECT DISTINCT ((least(6, 529595761))-(least(4, 1032827696))),
least(-859534381, 0.01807380825433357873777140412130393087863922119140625)
@@ -835,7 +824,7 @@ SELECT 1 FROM t0, t1 WHERE least(CASE WH
----
132 values hashing to 421ece02fd1d5b93ec74b250381a9e64
-query T rowsort
+query R rowsort
SELECT t1.c3 FROM t2, t0, t1 WHERE least(CASE WHEN t1.c4 THEN t1.c4 WHEN t1.c5
THEN t1.c5 WHEN t1.c5 THEN t1.c4 ELSE t1.c4 END, ((t1.c0)NOT LIKE(t1.c0)))
----
120 values hashing to 879a831ae9fcb0a40db88988eb6e428b
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
