Changeset: cc9e4233ada8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cc9e4233ada8
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:
SQLancer query with wrong result, ie t1.c0 must be found. I think this is
related to the last query I committed
diffs (16 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -127,6 +127,12 @@ select 1 from t0 natural join (select 4
ROLLBACK;
START TRANSACTION;
+CREATE TABLE t0(c0 DATE);
+CREATE TABLE t1(c0 DATE NOT NULL);
+select t1.c0 from t0 natural join t1; --t1.c0 must be found
+ROLLBACK;
+
+START TRANSACTION;
CREATE TABLE t0(c0 DOUBLE PRIMARY KEY NULL);
CREATE TABLE "sys"."t1" ("c0" DOUBLE,CONSTRAINT "t1_c0_unique" UNIQUE ("c0"));
COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
