Changeset: 21c10eaecd69 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=21c10eaecd69
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (49 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out
b/sql/test/SQLancer/Tests/sqlancer05.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer05.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out
@@ -319,11 +319,45 @@ stdout of test 'sqlancer05` in directory
#"f8i8c"
#"?"
[ 14 ]
+#SELECT t1.c0 FROM t1 WHERE t1.c0 NOT ILIKE t1.c0;
+% sys.t1 # table_name
+% c0 # name
+% char # type
+% 420 # length
+#SELECT t1.c0 NOT ILIKE t1.c0 FROM t1;
+% sys.%1 # table_name
+% %1 # name
+% boolean # type
+% 5 # length
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
+[ false ]
#ROLLBACK;
#START TRANSACTION;
#CREATE TABLE "sys"."t0" ("c0" INTERVAL MONTH,"c1" INTERVAL SECOND);
#create view v0(c0) as (select all t0.c1 from t0);
#ROLLBACK;
+#CREATE TABLE "sys"."t1" ("c1" BOOLEAN);
+#INSERT INTO t1(c1) VALUES(TRUE), (FALSE), (FALSE);
+[ 3 ]
+#INSERT INTO t1(c1) VALUES((- (2127809083)) NOT IN (CASE TIME '22:10:54' WHEN
TIME '19:30:46' THEN -1396572561 WHEN TIME '15:58:42' THEN -1164282298 END, +
(-767637633), COALESCE(1638931666, 596854699))), (TRUE);
+[ 2 ]
+#INSERT INTO t1(c1) VALUES(FALSE), (TRUE), (FALSE), (FALSE), (FALSE), (FALSE),
(TRUE), (TRUE), (FALSE), (TRUE);
+[ 10 ]
+#DELETE FROM t1 WHERE t1.c1;
+[ 6 ]
+#DROP TABLE "sys"."t1";
# 12:00:38 >
# 12:00:38 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
