Changeset: 60209cd4fc93 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=60209cd4fc93
Added Files:
sql/test/SQLancer/Tests/sqlancer08.sql
Modified Files:
sql/test/SQLancer/Tests/All
Branch: octbugs
Log Message:
New SQLancer crash. Issue at rel_push_func_down optimizer
diffs (22 lines):
diff --git a/sql/test/SQLancer/Tests/All b/sql/test/SQLancer/Tests/All
--- a/sql/test/SQLancer/Tests/All
+++ b/sql/test/SQLancer/Tests/All
@@ -5,3 +5,4 @@ sqlancer04
sqlancer05
sqlancer06
sqlancer07
+sqlancer08
diff --git a/sql/test/SQLancer/Tests/sqlancer08.sql
b/sql/test/SQLancer/Tests/sqlancer08.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer08.sql
@@ -0,0 +1,9 @@
+START TRANSACTION;
+CREATE TABLE "t0" ("tc0" VARCHAR(32) NOT NULL,CONSTRAINT "t0_tc0_pkey" PRIMARY
KEY ("tc0"),CONSTRAINT "t0_tc0_unique" UNIQUE ("tc0"));
+INSERT INTO "t0" VALUES ('1048409847'), ('ph'), ('CV'), ('T\t'), ('!iG&');
+CREATE TABLE "t1" ("tc0" VARCHAR(32) NOT NULL,CONSTRAINT "t1_tc0_unique"
UNIQUE ("tc0"),CONSTRAINT "t1_tc0_fkey" FOREIGN KEY ("tc0") REFERENCES "t1"
("tc0"));
+select 1 from t0 join t1 on sql_min(true, t1.tc0 between rtrim(t0.tc0) and
'a');
+ -- empty
+select cast("isauuid"(t1.tc0) as int) from t0 full outer join t1 on
+not (sql_min(not ((interval '505207731' day) in (interval '1621733891' day)),
(nullif(t0.tc0, t1.tc0)) between asymmetric (rtrim(t0.tc0)) and (cast((r'_7')
in (r'', t0.tc0) as string(891)))));
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
