Changeset: 1988923e3ee0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1988923e3ee0
Added Files:
sql/test/SQLancer/Tests/sqlancer07.sql
sql/test/SQLancer/Tests/sqlancer07.stable.err
sql/test/SQLancer/Tests/sqlancer07.stable.out
Modified Files:
sql/server/rel_optimizer.c
sql/test/SQLancer/Tests/All
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
Making SQLancer happy. Don't give points to parameters without points. Also
updated buggy query
diffs (85 lines):
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -5613,6 +5613,8 @@ sql_class_base_score(mvc *sql, sql_colum
{
int de;
+ if (!t)
+ return 0;
switch (ATOMstorage(t->type->localtype)) {
case TYPE_bte:
return 150 - 8;
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
@@ -4,3 +4,4 @@ sqlancer03
sqlancer04
sqlancer05
sqlancer06
+sqlancer07
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -393,6 +393,10 @@ SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1
-- NULL
-- NULL
-- 20:32:11
+SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT t1.c2 FROM
t1, t2) = ALL(SELECT t0.c2 FROM t0, t2);
+ -- NULL
+ -- NULL
+ -- 20:32:11
SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON NOT (t2.c1) WHERE
(((((((0.9842272043385978) NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN
ASYMMETRIC (t2.c0) AND
((SELECT ALL t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT t1.c2 FROM t1, t2) =
ALL(SELECT ALL t0.c2 FROM t0, t1, t2)));
-- NULL
diff --git a/sql/test/SQLancer/Tests/sqlancer07.sql
b/sql/test/SQLancer/Tests/sqlancer07.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer07.sql
@@ -0,0 +1,5 @@
+START TRANSACTION;
+CREATE TABLE "t1" ("c0" DECIMAL(18,3),"c1" BINARY LARGE OBJECT NOT NULL,"c2"
DECIMAL(18,3),CONSTRAINT "t1_c1_unique" UNIQUE ("c1"));
+PREPARE SELECT DISTINCT (SELECT DISTINCT r'|m<kv' FROM t1 WHERE ((t1.c0)<(?))
GROUP BY t1.c2, ?), ?, t1.c2 FROM t1 WHERE CAST(? AS BOOLEAN) LIMIT
2103332269785059850;
+ -- Could not determine type for argument number 2
+ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.err
b/sql/test/SQLancer/Tests/sqlancer07.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.err
@@ -0,0 +1,16 @@
+stderr of test 'sqlancer07` in directory 'sql/test/SQLancer` itself:
+
+
+# 10:16:14 >
+# 10:16:14 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-52758" "--port=31957"
+# 10:16:14 >
+
+MAPI = (monetdb) /var/tmp/mtest-52758/.s.monetdb.31957
+QUERY = PREPARE SELECT DISTINCT (SELECT DISTINCT r'|m<kv' FROM t1 WHERE
((t1.c0)<(?)) GROUP BY t1.c2, ?), ?, t1.c2 FROM t1 WHERE CAST(? AS BOOLEAN)
LIMIT 2103332269785059850;
+ERROR = !Could not determine type for argument number 2
+CODE = 42000
+
+# 10:16:14 >
+# 10:16:14 > "Done."
+# 10:16:14 >
+
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.out
b/sql/test/SQLancer/Tests/sqlancer07.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.out
@@ -0,0 +1,15 @@
+stdout of test 'sqlancer07` in directory 'sql/test/SQLancer` itself:
+
+
+# 10:16:14 >
+# 10:16:14 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-52758" "--port=31957"
+# 10:16:14 >
+
+#START TRANSACTION;
+#CREATE TABLE "t1" ("c0" DECIMAL(18,3),"c1" BINARY LARGE OBJECT NOT NULL,"c2"
DECIMAL(18,3),CONSTRAINT "t1_c1_unique" UNIQUE ("c1"));
+#ROLLBACK;
+
+# 10:16:14 >
+# 10:16:14 > "Done."
+# 10:16:14 >
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
