MonetDB: Jun2020 - 3 new SQLancer bugs to finish the day :S

[Pedro Ferreira]

Changeset: 44b76880fac9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=44b76880fac9
Modified Files:
        sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:

3 new SQLancer bugs to finish the day :S


diffs (69 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql 
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -232,6 +232,65 @@ START TRANSACTION;
 CREATE TABLE t0 (c0 integer DEFAULT CAST(0 AS INT));
 ROLLBACK;
 
+START TRANSACTION; -- Bug 6903 and 6904
+CREATE TABLE "sys"."t0" ("c0" DOUBLE, "c1" VARCHAR(496));
+COPY 20 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.1438664733406536     NULL
+0.1765302987566959     NULL
+NULL   "0.6278315174254069"
+0.9937940991911638     "470810.02006337716"
+0.925750874406328      " \\Z᳣s}LfFQk呗8Mßßl07VXpgoVDy\015'X\n}呗x逖n\015>⎑s%cQyIQ"
+NULL   "0.17744327397271142"
+NULL   "y"
+NULL   "緦좺VDOKB "
+1511423462     "470810.02006337716"
+0.5249207035059663     "470810.02006337716"
+1      "470810.02006337716"
+0.3762066043983153     "470810.02006337716"
+-939120682     "c2lT^9BY0smjöA罀A&ß14_[#*r"
+0.522051822144801      "0.008675985"
+0.5347718465897517     "c2lt^9by0smjöa罀a&ß14_[#*r"
+NULL   "true"
+NULL   "-844489501"
+NULL   "0.44968215744290607"
+NULL   ".v"
+NULL   "-174251119"
+
+SELECT ALL CAST(VAR_SAMP(ALL abs(CAST(t0.c1 AS INT))) AS INT) FROM t0 GROUP BY 
CAST(t0.c1 AS INT), t0.c1;
+SELECT ALL 0.1002352, AVG(ALL t0.c0) FROM t0 GROUP BY CAST(t0.c0 AS 
STRING(799)), 0.4665444117594173, ((sql_min(+ ("locate"('', 'F', 150648381)), 
((((-1039870396)||(390810869)))*(length(r'u')))))>>(CAST(0.588018201374832 AS 
INT)));
+ROLLBACK;
+
+START TRANSACTION; -- Bug 6905
+CREATE TABLE "sys"."t0" ("c0" INTEGER,"c1" DOUBLE);
+COPY 15 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+-1498252621    -1498252621
+0      NULL
+-539579569     -539579569
+-108613919     NULL
+0      0
+8      NULL
+1783007739     NULL
+498706403      NULL
+0      0.6103170716911988
+1493854316     0.6198781779645515
+-1608947797    1
+1      0.8356779050811012
+-101868623     0.16442926747225173
+1493854316     -1498252621
+1      0.9401903184230552
+
+SELECT t0.c0 FROM t0 WHERE (0.9952398693354088) IN (t0.c1, t0.c1);
+       --empty (this one is right)
+SELECT ALL t0.c0 FROM t0 WHERE NOT ((0.9952398693354088) IN (t0.c1, t0.c1));
+       -- 10 rows (this one is right)
+SELECT t0.c0 FROM t0 WHERE ((0.9952398693354088) IN (t0.c1, t0.c1)) IS NULL;
+       --          0
+       -- -108613919
+       --          8
+       -- 1783007739
+       --  498706403
+ROLLBACK;
+
 DROP TABLE tbl_ProductSales;
 DROP TABLE another_T;
 DROP TABLE integers;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list