Changeset: 36ccdd1d426e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36ccdd1d426e Modified Files: sql/test/subquery/Tests/correlated.sql sql/test/subquery/Tests/correlated.stable.out Branch: sq2default Log Message:
Ported test to non 128-bit integer platforms diffs (168 lines): diff --git a/sql/test/subquery/Tests/correlated.sql b/sql/test/subquery/Tests/correlated.sql --- a/sql/test/subquery/Tests/correlated.sql +++ b/sql/test/subquery/Tests/correlated.sql @@ -566,7 +566,7 @@ SELECT i, CAST((SELECT SUM(i)+(SELECT 42 --3 51 --NULL NULL -SELECT i, (SELECT ((SELECT ((SELECT ((SELECT SUM(i)+SUM(i4.i)+SUM(i3.i)+SUM(i2.i)+SUM(i1.i) FROM integers i5)) FROM integers i4)) FROM integers i3)) FROM integers i2) AS j FROM integers i1 GROUP BY i ORDER BY i; +SELECT i, CAST((SELECT ((SELECT ((SELECT ((SELECT SUM(i)+SUM(i4.i)+SUM(i3.i)+SUM(i2.i)+SUM(i1.i) FROM integers i5)) FROM integers i4)) FROM integers i3)) FROM integers i2) AS BIGINT) AS j FROM integers i1 GROUP BY i ORDER BY i; --1 25 --2 26 --3 27 @@ -578,13 +578,13 @@ SELECT i, CAST((SELECT (SELECT (SELECT ( --3 18 --NULL NULL -SELECT i, (SELECT SUM(s1.i) FROM integers s1 INNER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS j FROM integers i1 ORDER BY i; +SELECT i, CAST((SELECT SUM(s1.i) FROM integers s1 INNER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS BIGINT) AS j FROM integers i1 ORDER BY i; --1 6 --2 6 --3 6 --NULL NULL -SELECT i, SUM(i), (SELECT (SELECT SUM(i)+SUM(i1.i)+SUM(i2.i) FROM integers) FROM integers i2) FROM integers i1 GROUP BY i ORDER BY i; +SELECT i, CAST(SUM(i) AS BIGINT), CAST((SELECT (SELECT SUM(i)+SUM(i1.i)+SUM(i2.i) FROM integers) FROM integers i2) AS BIGINT) FROM integers i1 GROUP BY i ORDER BY i; --1 1 13 --2 2 14 --3 3 15 @@ -602,7 +602,7 @@ SELECT i, CAST((SELECT SUM(ss2.i) FROM ( --3 3 --NULL NULL -SELECT i, (SELECT SUM(s1.i) FROM integers s1 LEFT OUTER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS j FROM integers i1 ORDER BY i; +SELECT i, CAST((SELECT SUM(s1.i) FROM integers s1 LEFT OUTER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS BIGINT) AS j FROM integers i1 ORDER BY i; --1 6 --2 6 --3 6 @@ -650,7 +650,7 @@ SELECT i, CAST((SELECT SUM(s2.i) FROM in --3 3 --NULL NULL -SELECT i, (SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS j FROM integers i1 ORDER BY i; +SELECT i, CAST((SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS BIGINT) AS j FROM integers i1 ORDER BY i; --1 1 --2 2 --3 3 @@ -686,7 +686,7 @@ SELECT i, CAST((SELECT SUM(ss2.i) FROM ( --3 6 --NULL 6 -SELECT i, (SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS j FROM integers i1 ORDER BY i; +SELECT i, CAST((SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS BIGINT) AS j FROM integers i1 ORDER BY i; --1 1 --2 2 --3 3 @@ -739,8 +739,8 @@ SELECT i, CAST((SELECT SUM(ss1.i)+SUM(ss --3 6 --NULL NULL -SELECT i, (SELECT SUM(ss1.i)+SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE i=i1.i AND i>ANY(SELECT i FROM integers WHERE i<>s1.i)) ss1 LEFT OUTER JOIN - (SELECT i FROM integers s1 WHERE i<>i1.i OR i=ANY(SELECT i FROM integers WHERE i=s1.i)) ss2 ON ss1.i=ss2.i) AS j FROM integers i1 ORDER BY i; +SELECT i, CAST((SELECT SUM(ss1.i)+SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE i=i1.i AND i>ANY(SELECT i FROM integers WHERE i<>s1.i)) ss1 LEFT OUTER JOIN + (SELECT i FROM integers s1 WHERE i<>i1.i OR i=ANY(SELECT i FROM integers WHERE i=s1.i)) ss2 ON ss1.i=ss2.i) AS BIGINT) AS j FROM integers i1 ORDER BY i; --1 NULL --2 4 --3 6 diff --git a/sql/test/subquery/Tests/correlated.stable.out b/sql/test/subquery/Tests/correlated.stable.out --- a/sql/test/subquery/Tests/correlated.stable.out +++ b/sql/test/subquery/Tests/correlated.stable.out @@ -820,10 +820,10 @@ stdout of test 'correlated` in directory [ 1, 49 ] [ 2, 50 ] [ 3, 51 ] -#SELECT i, (SELECT ((SELECT ((SELECT ((SELECT SUM(i)+SUM(i4.i)+SUM(i3.i)+SUM(i2.i)+SUM(i1.i) FROM integers i5)) FROM integers i4)) FROM integers i3)) FROM integers i2) AS j FROM integers i1 GROUP BY i ORDER BY i; -% .i1, .%6 # table_name +#SELECT i, CAST((SELECT ((SELECT ((SELECT ((SELECT SUM(i)+SUM(i4.i)+SUM(i3.i)+SUM(i2.i)+SUM(i1.i) FROM integers i5)) FROM integers i4)) FROM integers i3)) FROM integers i2) AS BIGINT) AS j FROM integers i1 GROUP BY i ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 2 # length [ NULL, NULL ] [ 1, 25 ] @@ -838,19 +838,19 @@ stdout of test 'correlated` in directory [ 1, 6 ] [ 2, 12 ] [ 3, 18 ] -#SELECT i, (SELECT SUM(s1.i) FROM integers s1 INNER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS j FROM integers i1 ORDER BY i; -% .i1, .%5 # table_name +#SELECT i, CAST((SELECT SUM(s1.i) FROM integers s1 INNER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS BIGINT) AS j FROM integers i1 ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 1 # length [ NULL, NULL ] [ 1, 6 ] [ 2, 6 ] [ 3, 6 ] -#SELECT i, SUM(i), (SELECT (SELECT SUM(i)+SUM(i1.i)+SUM(i2.i) FROM integers) FROM integers i2) FROM integers i1 GROUP BY i ORDER BY i; -% .i1, .%1, .%5 # table_name -% i, %1, %6 # name -% int, hugeint, hugeint # type +#SELECT i, CAST(SUM(i) AS BIGINT), CAST((SELECT (SELECT SUM(i)+SUM(i1.i)+SUM(i2.i) FROM integers) FROM integers i2) AS BIGINT) FROM integers i1 GROUP BY i ORDER BY i; +% .i1, .%2, .%10 # table_name +% i, %2, %10 # name +% int, bigint, bigint # type % 1, 1, 2 # length [ NULL, NULL, NULL ] [ 1, 1, 13 ] @@ -874,10 +874,10 @@ stdout of test 'correlated` in directory [ 1, 1 ] [ 2, 2 ] [ 3, 3 ] -#SELECT i, (SELECT SUM(s1.i) FROM integers s1 LEFT OUTER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS j FROM integers i1 ORDER BY i; -% .i1, .%5 # table_name +#SELECT i, CAST((SELECT SUM(s1.i) FROM integers s1 LEFT OUTER JOIN integers s2 ON (SELECT i1.i+s1.i)=(SELECT i1.i+s2.i)) AS BIGINT) AS j FROM integers i1 ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 1 # length [ NULL, 6 ] [ 1, 6 ] @@ -946,10 +946,10 @@ stdout of test 'correlated` in directory [ 1, 5 ] [ 2, 4 ] [ 3, 3 ] -#SELECT i, (SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS j FROM integers i1 ORDER BY i; -% .i1, .%2 # table_name +#SELECT i, CAST((SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS BIGINT) AS j FROM integers i1 ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 1 # length [ NULL, NULL ] [ 1, 1 ] @@ -1000,10 +1000,10 @@ stdout of test 'correlated` in directory [ 1, 6 ] [ 2, 6 ] [ 3, 6 ] -#SELECT i, (SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS j FROM integers i1 ORDER BY i; -% .i1, .%2 # table_name +#SELECT i, CAST((SELECT SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE CASE WHEN (i=i1.i AND i=ANY(SELECT i FROM integers WHERE i=s1.i)) THEN true ELSE false END) ss2) AS BIGINT) AS j FROM integers i1 ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 1 # length [ NULL, NULL ] [ 1, 1 ] @@ -1077,11 +1077,11 @@ stdout of test 'correlated` in directory [ 1, NULL ] [ 2, 4 ] [ 3, 6 ] -#SELECT i, (SELECT SUM(ss1.i)+SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE i=i1.i AND i>ANY(SELECT i FROM integers WHERE i<>s1.i)) ss1 LEFT OUTER JOIN -# (SELECT i FROM integers s1 WHERE i<>i1.i OR i=ANY(SELECT i FROM integers WHERE i=s1.i)) ss2 ON ss1.i=ss2.i) AS j FROM integers i1 ORDER BY i; -% .i1, .%7 # table_name +#SELECT i, CAST((SELECT SUM(ss1.i)+SUM(ss2.i) FROM (SELECT i FROM integers s1 WHERE i=i1.i AND i>ANY(SELECT i FROM integers WHERE i<>s1.i)) ss1 LEFT OUTER JOIN +# (SELECT i FROM integers s1 WHERE i<>i1.i OR i=ANY(SELECT i FROM integers WHERE i=s1.i)) ss2 ON ss1.i=ss2.i) AS BIGINT) AS j FROM integers i1 ORDER BY i; +% .i1, . # table_name % i, j # name -% int, hugeint # type +% int, bigint # type % 1, 1 # length [ NULL, NULL ] [ 1, NULL ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
