Changeset: a30180a975f7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a30180a975f7
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
sql/test/SQLancer/Tests/sqlancer11.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (37 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -158,5 +158,6 @@ START TRANSACTION;
CREATE TABLE "t2" ("c0" TINYINT);
INSERT INTO "t2" VALUES (1), (0);
+select min(case 2 when 3 then uuid 'dbC4da54-8C0B-4b83-E74E-30242dA0a5fF' end)
from (values(1)) x(x) group by x;
select min(case (select 2 where false) when 3 then uuid
'dbC4da54-8C0B-4b83-E74E-30242dA0a5fF' end) from t2 group by 0.88;
ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer11.stable.out
b/sql/test/SQLancer/Tests/sqlancer11.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer11.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer11.stable.out
@@ -524,6 +524,23 @@ stdout of test 'sqlancer11` in directory
#when not matched then insert (c2) values
(cast(((0.6603879962021974581176664287340827286243438720703125)<>(0.99667693019570047230359932655119337141513824462890625))
as bigint));
[ 0 ]
#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t2" ("c0" TINYINT);
+#INSERT INTO "t2" VALUES (1), (0);
+[ 2 ]
+#select min(case 2 when 3 then uuid 'dbC4da54-8C0B-4b83-E74E-30242dA0a5fF'
end) from (values(1)) x(x) group by x;
+% .%3 # table_name
+% %3 # name
+% uuid # type
+% 36 # length
+[ NULL ]
+#select min(case (select 2 where false) when 3 then uuid
'dbC4da54-8C0B-4b83-E74E-30242dA0a5fF' end) from t2 group by 0.88;
+% .%3 # table_name
+% %3 # name
+% uuid # type
+% 36 # length
+[ NULL ]
+#ROLLBACK;
# 13:59:46 >
# 13:59:46 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
