Changeset: 8795abd5ea50 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8795abd5ea50
Modified Files:
sql/test/SQLancer/Tests/sqlancer09.test
Branch: default
Log Message:
Updated test
diffs (156 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer09.test
b/sql/test/SQLancer/Tests/sqlancer09.test
--- a/sql/test/SQLancer/Tests/sqlancer09.test
+++ b/sql/test/SQLancer/Tests/sqlancer09.test
@@ -494,3 +494,152 @@ select (-1.7976931348623157E308)/(0.9806
statement error
values (round(-1.4999792343698102e+308, 15)),(1.2)
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "sys"."t2" ("c0" REAL NOT NULL, "c1" DECIMAL(15,3),
+ CONSTRAINT "t2_c0_pkey" PRIMARY KEY ("c0"),
+ CONSTRAINT "t2_c0_unique" UNIQUE ("c0"),
+ CONSTRAINT "t2_c0_c1_unique" UNIQUE ("c0", "c1")
+)
+
+statement ok
+COPY 33 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+26 0.991
+0.13630049 37.000
+0.51769805 0.784
+-1.6852343e+09 NULL
+0.21530622 NULL
+113.135216 NULL
+1.0975889 0.000
+0.5668781 0.163
+0.07123395 0.808
+0.8320952 NULL
+0.35641629 NULL
+1.4285428e+12 NULL
+0.5716349 0.925
+-1.1734946e+08 0.000
+0.030607125 0.874
+0.83317256 0.000
+-1.7515901e+09 0.246
+5.855687e+08 0.630
+0.6815483 NULL
+0.0059321974 NULL
+0.8218823 0.960
+-4.015704e+08 0.000
+0.34888306 NULL
+-0.5051734 NULL
+0.34162566 NULL
+-1.0525191e+09 -1697412576.000
+0.5970499 NULL
+8.183423e+08 0.664
+0.5821468 0.721
+1.7945473e+09 1535759864.000
+0.24326971 0.329
+-1.0841585e+09 NULL
+10098 0.846
+
+statement ok
+ALTER TABLE t2 ADD CONSTRAINT "t2_c0_c1_fkey" FOREIGN KEY ("c0", "c1")
REFERENCES "sys"."t2" ("c0", "c1")
+
+statement error
+update t2 set c1 = 0.012427403386733981704992402228526771068572998046875 where
(((t2.c0)%(t2.c1))) between symmetric
+(coalesce(-1053775800, 991217471)) and (((0.6974006550632457)+(1832026960)))
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "sys"."t1" ("c0" REAL NOT NULL,CONSTRAINT "t1_c0_pkey" PRIMARY
KEY ("c0"),CONSTRAINT "t1_c0_unique" UNIQUE ("c0"))
+
+statement ok
+COPY 10 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+4.2328605e+08
+0.69732165
+0.71200204
+4.466514e+07
+0
+1.3677554e+09
+0.36787975
+0.961471
+0.6692194
+0.3954379
+
+statement ok
+create or replace view v64(vc0, vc1, vc2, vc3) as (select -34, 'A',
+((0.2457749548974355047192830170388333499431610107421875)*(5)), cast(-43 as
int)) with check option
+
+statement ok
+create or replace view v110(vc0) as (values ('a'), ('8'), ('g'), (null)) with
check option
+
+query I rowsort
+select 1 from v64, t1, v110 where t1.c0 > v64.vc2
+----
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+create or replace view v11(vc0, vc1) as (values (cast(r'<' as string),
((((356910743)||(324718164)))<<(sql_max(962062904, -1226062612)))),
+(r'e]+)Nik', ((cast(-1267863719 as tinyint))&(- (340796877)))), (case when
((r'24060')not like(r'f')) then r'vyA,R' else r'68' end,
++ (greatest(113, 0.61746233049203114173764106453745625913143157958984375))))
+
+statement ok
+create or replace view v13(vc0, vc1) as (values
(((0.9896616954779023)<(greatest(-1982788333,
0.76584341990855342441335551484371535480022430419921875)))
+, cast(1938193505 as boolean)), (greatest(false, false), cast(cast(r'rHIVNz'
as int) as boolean))) with check option
+
+statement ok
+create or replace view v23(vc0, vc1) as (values (case when ((false)and(true))
then ((25922)*(697298603)) when not (false) then - (2909) end,
+cast(case r'17841' when r'155' then 2909 when r'116' then 17275 end as int)))
+
+query I rowsort
+SELECT CAST(SUM(agg0) as BIGINT) FROM (
+ SELECT count(ALL 1) as agg0 FROM v23, v13, v11 CROSS JOIN (VALUES
(scale_down(CAST(0.31366895126242933 AS BIGINT),
+ NULLIF(0.6018914, 0.947574)), "isauuid"(r''))) AS sub0 WHERE
((greatest(v11.vc0, v11.vc0))NOT LIKE(CAST(r'' AS STRING(299))))
+ UNION ALL
+ SELECT count(ALL 1) as agg0 FROM v23, v13, v11 CROSS JOIN (VALUES
(scale_down(CAST(0.31366895126242933 AS BIGINT),
+ NULLIF(0.6018914, 0.947574)), "isauuid"(r''))) AS sub0 WHERE NOT
(((greatest(v11.vc0, v11.vc0))NOT LIKE(CAST(r'' AS STRING(299)))))
+ UNION ALL
+ SELECT count(ALL 1) as agg0 FROM v23, v13, v11 CROSS JOIN (VALUES
(scale_down(CAST(0.31366895126242933 AS BIGINT),
+ NULLIF(0.6018914, 0.947574)), "isauuid"(r''))) AS sub0 WHERE
(((greatest(v11.vc0, v11.vc0))NOT LIKE(CAST(r'' AS STRING(299))))) IS NULL
+ ) as asdf
+----
+6
+
+statement ok
+create or replace view v11(vc0) as (values ('<'), ('a'))
+
+query I rowsort
+SELECT 1 FROM v11 WHERE v11.vc0 LIKE '' IS NULL
+----
+
+statement ok
+ROLLBACK
+
+query I rowsort
+SELECT 1 HAVING group_concat('') NOT LIKE '3' IS NULL
+----
+
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
