Changeset: f3fd2e1d6152 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f3fd2e1d6152
Branch: mtest
Log Message:
merge
diffs (truncated from 43209 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -1,6 +1,6 @@
query TTTTT rowsort
select * from sys.malfunctions() order by module, "function", address,
signature, comment
----
-64110 values hashing to 2c8d260ec221c669a3c878cf04340222
+65490 values hashing to ca0241b9eab8bb582f3f93a7fd008dd8
diff --git a/sql/test/SQLancer/Tests/sqlancer01.test
b/sql/test/SQLancer/Tests/sqlancer01.test
new file mode 100644
--- /dev/null
+++ b/sql/test/SQLancer/Tests/sqlancer01.test
@@ -0,0 +1,645 @@
+statement ok
+CREATE TABLE tbl_ProductSales (ColID int, Product_Category varchar(64),
Product_Name varchar(64), TotalSales int)
+
+statement ok
+INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO
Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100)
+
+statement ok
+CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6
INT, col7 INT, col8 INT)
+
+statement ok
+INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88),
(111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888)
+
+statement ok
+CREATE TABLE integers(i INTEGER)
+
+statement ok
+INSERT INTO integers VALUES (1), (2), (3), (NULL)
+
+statement ok
+START TRANSACTION
+
+query I rowsort
+select 1 from integers where (((0.7161494983624688) in (integers.i)) = true) =
false
+----
+1
+1
+1
+
+statement ok
+delete from integers where (((0.7161494983624688) in (integers.i)) = true) =
false
+
+query I rowsort
+select i from integers
+----
+NULL
+
+statement ok
+CREATE TABLE t0 (a1 INT, a2 int, a3 int)
+
+statement ok
+UPDATE t0 SET a2 = (- (- (t0.a1))), a3 =
(ascii(CAST(ascii('}æY8K*é5<c>^n8_X1X|p(''bX') AS STRING(920)))) WHERE NOT
(((0.27023923567918073) NOT IN (0.9149447665258329)) = FALSE)
+
+statement ok
+insert into integers(i) values(((length(reverse('8
\rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}')))>>(((- (-
(528640982)))&(ascii('528640982'))))))
+
+query I rowsort
+SELECT i from integers order by i
+----
+0
+NULL
+
+query T rowsort
+select reverse(r'8 \rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}')
+----
+}*4nR<!@s5j4@YMe1pb[@rcr\ 8
+
+query T rowsort
+select true in (1 in (1))
+----
+True
+
+statement ok
+INSERT INTO integers VALUES(ascii(CAST(0.1 AS STRING)) IN (-1.186003652E9))
+
+statement ok
+INSERT INTO another_t(col4) VALUES(-589206676), (-1557408577)
+
+statement ok
+DELETE FROM another_t WHERE ((another_t.col8)<=(+ (another_t.col8)))
+
+statement ok
+ALTER TABLE another_t ADD UNIQUE(col8, col1, col6, col3)
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+create view v0(c0) as (select distinct - (tbl_productsales.totalsales) from
tbl_productsales, another_t)
+
+query I rowsort
+select another_t.col1 from another_t, tbl_productsales cross join v0
+----
+64 values hashing to eb6fb44b762596dc08e5dcdf32cd22d5
+
+statement ok
+ROLLBACK
+
+query T rowsort
+SELECT "sys"."replace"(cast(cast(0.8009925043335998 as clob) as
clob(169)),cast("sys"."replace"('!','','wtkgì¶5,I}æ¥') as
clob),"sys"."concat"("sys"."concat"('?dMHrí2!FU4Rá%',-1194732688),0.7566860950241294))
+----
+0.8009925043335998
+
+query TTTT rowsort
+SELECT "replace"('!','','wtkgì¶5,I}æ¥'), "replace"('','!','wtkgì¶5,I}æ¥'),
"replace"('abc',NULL,'wtkgì¶5,I}æ¥'), "replace"('abc','b',NULL)
+----
+!
+(empty)
+NULL
+NULL
+
+query I rowsort
+select all integers.i from another_t inner join integers on
((another_t.col3)<=(cast((another_t.col4) between symmetric
(cast(0.29924480503501805 as int)) and (another_t.col3) as int)))
+where true union all select all integers.i from another_t join integers on
((another_t.col3)<=(cast((another_t.col4) between symmetric
(cast(0.29924480503501805 as int)) and (another_t.col3) as int)))
+where not (true) union all select all integers.i from another_t join integers
on ((another_t.col3)<=(cast((another_t.col4) between symmetric
(cast(0.29924480503501805 as int)) and (another_t.col3) as int))) where (true)
is null
+----
+
+query I rowsort
+select 1 from another_t join integers on (cast(another_t.col4 between 1 and 2
as int)) where false
+----
+
+query I rowsort
+SELECT another_T.col2 FROM tbl_productsales, integers LEFT OUTER JOIN
another_T ON another_T.col1 > 1 WHERE another_T.col2 > 1 GROUP BY
another_T.col2 HAVING COUNT((another_T.col2) IN (another_T.col2)) > 0
+----
+22
+222
+2222
+
+query I rowsort
+SELECT COUNT(1 IN (1))
+----
+1
+
+statement ok
+START TRANSACTION
+
+statement ok
+create view v0(c0) as (select distinct - (tbl_productsales.totalsales) from
tbl_productsales, another_t)
+
+statement ok
+create view v1(c0) as (select distinct not (not ((((v0.c0)=(1560867215))) =
false)) from integers, another_t, tbl_productsales, v0)
+
+statement ok
+create view v2(c0, c1) as (select v1.c0, -3.025584E8 from v0,
tbl_productsales, v1, another_t)
+
+statement ok
+create view v3(c0, c1, c2) as (select all
0.9104878744438205107059047804796136915683746337890625, -705263737, 0.7147939
from v2 where (cast(v2.c0 as varchar(32))) is null order by v2.c1 desc, v2.c0
desc)
+
+query R rowsort
+SELECT v3.c0 FROM v3, v0, tbl_productsales FULL OUTER JOIN v2 ON v2.c0 RIGHT
OUTER JOIN integers ON (tbl_productsales.TotalSales) BETWEEN (NULL) AND (v2.c1)
JOIN another_t ON v2.c0
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+insert into tbl_productsales(product_name, totalsales) values (((cast(0.1 as
string))||(charindex(cast(((((1)*(-1)))&(((-1)|(-1)))) as string),
+((((rtrim('0.9407860360743894', ''))||(1)))||(cast(1.44041702E9 as
string(75)))),
+((- (((1)*(-1))))*(1))))), -1833694753)
+
+query T rowsort
+select rtrim('0.9407860360743894', '')
+----
+0.9407860360743894
+
+statement ok
+ROLLBACK
+
+query I rowsort
+SELECT another_t.col1 FROM tbl_productsales CROSS JOIN another_t WHERE
((tbl_productsales.product_category) NOT IN (tbl_productsales.product_category,
tbl_productsales.product_category)) IS NULL
+----
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE t0 (c0 int, c1 int)
+
+statement ok
+insert into t0 values (1, 1)
+
+query I rowsort
+select all t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326)
+union all select all t0.c0 from t0 where not (1) not in (1.52414541E9,
0.13482326)
+union all select t0.c0 from t0 where (1) not in (1.52414541E9, 0.13482326) is
null
+----
+1
+
+query I rowsort
+select 1 from t0 where (3 in (1, 2)) is null
+----
+
+query I rowsort
+SELECT 1 FROM t0 WHERE t0.c0 BETWEEN SYMMETRIC (1 IN (2, 1)) AND t0.c0
+----
+1
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0"("c0" DECIMAL(18,3), "c1" BIGINT)
+
+statement ok
+COPY 12 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.244 NULL
+0.578 NULL
+0.119 NULL
+0.773 495026350
+0.329 2108706088
+0.483 1298757529
+0.880 39
+0.084 1
+0.332 859611948
+0.607 NULL
+0.835 0
+0.455 -1239303309
+
+query I rowsort
+SELECT MIN(DISTINCT t0.c1) FROM t0 WHERE 1 >= t0.c0 GROUP BY true
+----
+-1239303309
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE t0 (c0 int, c1 int)
+
+statement ok
+insert into t0 values (1, 1)
+
+statement ok
+CREATE TABLE v0 (c0 int, c1 int)
+
+statement ok
+insert into v0 values (1, 1)
+
+query I rowsort
+select all count(all 0.5923759) from v0 left outer join t0 on (('1')||
+cast((0.95672141382556563637962199209141544997692108154296875) in
(0.93132256561636328484610203304328024387359619140625, t0.c0) as varchar(32))
like('jBlZöx TW9*à¡xwã©*'))
+----
+1
+
+query I rowsort
+select 1 from v0 join t0 on (((substr('1', 1, v0.c0)) || (1) in (1, t0.c0))
like 'a')
+----
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "sys"."t0" (
+ "c0" DECIMAL(18,3),
+ "c1" DOUBLE
+)
+
+statement ok
+COPY 25 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.861 0.6056174268361689
+NULL 0.5542760880735715
+0.566 0.5542760880735715
+0.923 0.052316013908556114
+0.162 0.5542760880735715
+0.329 0.44073078327593473
+0.662 0.5255985140328766
+0.001 NULL
+0.736 NULL
+0.604 0.5394080603985286
+0.988 NULL
+0.232 0.23262100818671297
+0.041 -7.386201860458207e+20
+0.776 NULL
+0.805 NULL
+0.189 NULL
+0.493 NULL
+0.164 0.23262100818671297
+0.316 0.6870041098637464
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
