Changeset: c323cef6b5ec for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c323cef6b5ec
Modified Files:
sql/backends/monet5/rel_bin.c
sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
Branch: octbugs
Log Message:
Making SQLancer happy. Make sure input for aggregate is a column
diffs (25 lines):
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -3761,7 +3761,7 @@ insert_check_fkey(backend *be, list *ins
s = stmt_binop(be, stmt_aggr(be, idx_inserts, NULL, NULL, cnt,
1, 0, 1), stmt_atom_lng(be, 1), ne);
} else {
/* releqjoin.count <> inserts[col1].count */
- s = stmt_binop(be, stmt_aggr(be, idx_inserts, NULL, NULL, cnt,
1, 0, 1), stmt_aggr(be, s, NULL, NULL, cnt, 1, 0, 1), ne);
+ s = stmt_binop(be, stmt_aggr(be, idx_inserts, NULL, NULL, cnt,
1, 0, 1), stmt_aggr(be, column(be, s), NULL, NULL, cnt, 1, 0, 1), ne);
}
/* s should be empty */
diff --git a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
--- a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
+++ b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
@@ -45,3 +45,9 @@ 0.5299192301063729
0.7609386265982908
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0"("tc0" CHARACTER LARGE OBJECT NOT NULL,CONSTRAINT
"t0_tc0_pkey" PRIMARY KEY ("tc0"),
+CONSTRAINT "t0_tc0_fkey" FOREIGN KEY ("tc0") REFERENCES "sys"."t0" ("tc0"));
+INSERT INTO t0(tc0) VALUES('b' BETWEEN 'a' AND 'c');
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
