Changeset: 1d68d6e8052a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1d68d6e8052a
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.stable.out
sql/test/SQLancer/Tests/sqlancer04.stable.err
sql/test/SQLancer/Tests/sqlancer04.stable.out
Branch: default
Log Message:
Approved output
diffs (66 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -637,7 +637,7 @@ stdout of test 'sqlancer03` in directory
#0.369
[ 8 ]
#SELECT ALL CASE t0.c0 WHEN VAR_POP(ALL t0.c0) THEN (t0.c0) BETWEEN SYMMETRIC
(t0.c0) AND (t0.c0) END FROM t0 GROUP BY t0.c0;
-% sys.%2 # table_name
+% .%2 # table_name
% %2 # name
% boolean # type
% 5 # length
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err
b/sql/test/SQLancer/Tests/sqlancer04.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err
@@ -5,14 +5,22 @@ stderr of test 'sqlancer04` in directory
# 09:44:50 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-36890" "--port=30177"
# 09:44:50 >
-MAPI = (monetdb) /var/tmp/mtest-297969/.s.monetdb.30789
+MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947
+QUERY = SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default,
covar_samp between integer and string not possible
+ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947
QUERY = select case covar_samp(all - (coalesce (cast(-5 as int), coalesce
(((cast(0.4 as int))-(coalesce (5, 5))), +
(case -3 when 0.5 then 5 else 3 end)))), - (- (((coalesce (cast(0.2 as
int),
coalesce (5, 3, -747176383), ((6)%(3)), ((-2)<<(3))))||(-5))))) when
case t0.c0 when
case coalesce (coalesce (0.2, 0.3, 0.7), 0.5,
cast(t0.c2 as decimal)) when cast(interval '-4' month as interval
second) then cast(case 0.3 when t0.c1 then 0.6
when interval '-3' month then 0.3 end as interval second) end then
coalesce (abs(0.6),
-ERROR = !SELECT: cannot use non GROUP BY column 't0.c0' in query results
without an aggregate function
+ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947
+QUERY = SELECT CASE '5'^3 WHEN COUNT(TRUE) THEN 1 END FROM t0 GROUP BY 2 IN
((CAST(INTERVAL '-2' SECOND AS INT))%2); --error on default: types
sec_interval(13,0) and int(32,0) are not equal
+ERROR = !types sec_interval(13,0) and int(32,0) are not equal
CODE = 42000
# 09:44:50 >
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out
b/sql/test/SQLancer/Tests/sqlancer04.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out
@@ -29,22 +29,11 @@ stdout of test 'sqlancer04` in directory
% double # type
% 24 # length
#ROLLBACK;
-#SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default, covar_samp
between integer and string not possible
-% .%1 # table_name
-% %1 # name
-% double # type
-% 24 # length
-[ NULL ]
#START TRANSACTION;
#CREATE TABLE "sys"."t0"("c0" DATE, "c1" DATE, "c2" INTERVAL SECOND NOT
NULL,"c3" TIME NOT NULL);
#ROLLBACK;
#START TRANSACTION;
#CREATE TABLE "sys"."t0" ("c0" INTERVAL SECOND NOT NULL);
-#SELECT CASE '5'^3 WHEN COUNT(TRUE) THEN 1 END FROM t0 GROUP BY 2 IN
((CAST(INTERVAL '-2' SECOND AS INT))%2);
-% .%7 # table_name
-% %7 # name
-% tinyint # type
-% 1 # length
#ROLLBACK;
# 09:44:50 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
