Changeset: 0f57505bb399 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0f57505bb399
Modified Files:
sql/test/SQLancer/Tests/sqlancer01.test
sql/test/SQLancer/Tests/sqlancer02.test
sql/test/SQLancer/Tests/sqlancer03.test
sql/test/SQLancer/Tests/sqlancer04.test
sql/test/SQLancer/Tests/sqlancer05.test
sql/test/SQLancer/Tests/sqlancer06.test
sql/test/SQLancer/Tests/sqlancer08.test
sql/test/SQLancer/Tests/sqlancer09.test
sql/test/SQLancer/Tests/sqlancer10.test
sql/test/SQLancer/Tests/sqlancer11.test
sql/test/SQLancer/Tests/sqlancer13.test
sql/test/SQLancer/Tests/sqlancer17.test
Branch: default
Log Message:
The server may run without raw strings enabled
diffs (truncated from 1088 to 300 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer01.test
b/sql/test/SQLancer/Tests/sqlancer01.test
--- a/sql/test/SQLancer/Tests/sqlancer01.test
+++ b/sql/test/SQLancer/Tests/sqlancer01.test
@@ -50,7 +50,7 @@ 0
NULL
query T rowsort
-select reverse(r'8 \rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}')
+select reverse('8 \\rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}')
----
}*4nR<!@s5j4@YMe1pb[@rcr\ 8
@@ -479,7 +479,7 @@ statement ok
CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL,"c1" VARCHAR(64))
statement ok
-create view v0(c0, c1) as (select all t0.c0, r'epfNW⟚榢tptPbC{5{ZW}6,R' from
t0) with check option
+create view v0(c0, c1) as (select all t0.c0, 'epfNW⟚榢tptPbC{5{ZW}6,R' from t0)
with check option
query R rowsort
SELECT v0.c0 FROM v0 WHERE (v0.c1) BETWEEN (replace('2', '2', '1')) AND (v0.c1)
@@ -548,7 +548,7 @@ 1511423462.000
NULL
query RR rowsort
-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))*(length(r'u')))))>>(CAST(0.588018201374832 AS INT)))
+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))*(length('u')))))>>(CAST(0.588018201374832 AS INT)))
----
0.100
-939120682.000
@@ -662,7 +662,7 @@ statement ok
CREATE TABLE t0("c0" DOUBLE PRECISION, "c1" VARCHAR(496))
statement ok
-create view v0(c0, c1) as (select all t0.c0, r'epfNW⟚榢tptPbC{5{ZW}6,R' from
t0) with check option
+create view v0(c0, c1) as (select all t0.c0, 'epfNW⟚榢tptPbC{5{ZW}6,R' from t0)
with check option
query I rowsort
select 1 from v0 full outer join t0 on (cast(('a') in ('a') as string) ilike
v0.c0)
diff --git a/sql/test/SQLancer/Tests/sqlancer02.test
b/sql/test/SQLancer/Tests/sqlancer02.test
--- a/sql/test/SQLancer/Tests/sqlancer02.test
+++ b/sql/test/SQLancer/Tests/sqlancer02.test
@@ -93,7 +93,7 @@ 0.1228907839970418
statement error 22012!division by zero.
SELECT AVG(ALL ((((CAST(((+ (-12))/(sql_min(-12, -67))) AS
INT))+(abs(((13)*(10))))))*(((((greatest(12, -11))/(((((34-15)))/(CAST(t0.c0 AS
INT))))))*(- (+ (((-29)*(6))))))))), 0.777 FROM t0 WHERE (0.06) NOT BETWEEN
ASYMMETRIC (t0.c0) AND (t0.c0)
-GROUP BY 0.1, 0.7, 0.2, + (+ (- (length(r'q')))),
greatest(upper(upper(r'623865997')), trim(replace(r'vAd(Lup}Z', r'-1774953973',
r'0.4235712099498189'), substr(r'', -19)))
+GROUP BY 0.1, 0.7, 0.2, + (+ (- (length('q')))),
greatest(upper(upper('623865997')), trim(replace('vAd(Lup}Z', '-1774953973',
'0.4235712099498189'), substr('', -19)))
statement ok
ROLLBACK
@@ -150,11 +150,11 @@ 0.722
0.819
query R rowsort
-select t0.c0 from t0 where
((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest(r'0.29269552476776495', r'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
+select t0.c0 from t0 where
((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest('0.29269552476776495', 'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
between asymmetric (t0.c0) and (t0.c0))) union all
-select all t0.c0 from t0 where not
(((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest(r'0.29269552476776495', r'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
+select all t0.c0 from t0 where not
(((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest('0.29269552476776495', 'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
between asymmetric (t0.c0) and (t0.c0)))) union all
-select all t0.c0 from t0 where
(((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest(r'0.29269552476776495', r'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
+select all t0.c0 from t0 where
(((((cast(0.8800821070828266368124559448915533721446990966796875 as
string))like(cast(greatest('0.29269552476776495', 'Aṵ\tmmz\\v/p*Q2Q5') as
string(667)))))and((0.7706295839241474876502024926594458520412445068359375)
between asymmetric (t0.c0) and (t0.c0)))) is null
----
0.027
@@ -200,7 +200,7 @@ 0.920
0.939
query RRI rowsort
-SELECT ALL CAST((- (- (VAR_POP(ALL ((CAST(CAST(abs(709845242) AS INT) AS
INT))%(abs(CAST((931144491) NOT IN (-587881807) AS INT))))))))^(- (+ (-
(char_length(r'>])'))))) as decimal(10,3)), CAST(0.5186927954967 as
decimal(14,13)), CAST("locate"(lower(r'[]'), rtrim(r'..ۄUH*6鉡q'),
((((-233289450)&(-476676450)))-(- (236876413)))) AS INT)
+SELECT ALL CAST((- (- (VAR_POP(ALL ((CAST(CAST(abs(709845242) AS INT) AS
INT))%(abs(CAST((931144491) NOT IN (-587881807) AS INT))))))))^(- (+ (-
(char_length('>])'))))) as decimal(10,3)), CAST(0.5186927954967 as
decimal(14,13)), CAST("locate"(lower('[]'), rtrim('..ۄUH*6鉡q'),
((((-233289450)&(-476676450)))-(- (236876413)))) AS INT)
FROM t0 WHERE FALSE GROUP BY 1.2807753E7 HAVING MAX(ALL ((t0.c0)>=(NULL)))
----
@@ -228,7 +228,7 @@ NULL 0.36945874012955704 NULL
"M" 0.7309075439656509 NULL
statement ok rowcount 2
-UPDATE t0 SET c2 = r'' WHERE (((length(r'-14'))>>(((patindex(t0.c0,
t0.c2))+(CAST(2 AS INT)))))) NOT IN (0.2, t0.c1, t0.c1, ((CAST(((-1)*(2)) AS
INT))/(2)))
+UPDATE t0 SET c2 = '' WHERE (((length('-14'))>>(((patindex(t0.c0,
t0.c2))+(CAST(2 AS INT)))))) NOT IN (0.2, t0.c1, t0.c1, ((CAST(((-1)*(2)) AS
INT))/(2)))
statement ok
ROLLBACK
@@ -367,14 +367,14 @@ NULL 1970-01-23
"1970-01-08 05:11:41.000000" 1970-01-14
statement ok
-create view v0(c0) as (select t0.c2 from t0 where (t0.c2) not between
asymmetric (date '1970-01-23') and (case when r'true' then t0.c2 when case true
when (true) = true then substr(r' x+㶴9rr7긬X0陷?F5{W>gg0N*#Sꖿs', 1) end then
nullif(t0.c2, t0.c2) end))
+create view v0(c0) as (select t0.c2 from t0 where (t0.c2) not between
asymmetric (date '1970-01-23') and (case when 'true' then t0.c2 when case true
when (true) = true then substr(' x+㶴9rr7긬X0陷?F5{W>gg0N*#Sꖿs', 1) end then
nullif(t0.c2, t0.c2) end))
query I rowsort
SELECT 1 FROM v0 JOIN t0 ON '4321901' LIKE CAST(COALESCE(TIME '21:08:38', TIME
'14:42:56') AS STRING)
----
query TT rowsort
-SELECT ALL t0.c0, v0.c0 FROM v0 JOIN t0 ON ((upper(COALESCE(r'',
r'4321901')))ILIKE(CAST(COALESCE(sql_max(TIME '05:11:41', TIME '21:08:38'),
COALESCE(TIME '05:10:13', TIME '14:42:56'), sql_min(TIME '16:14:39', TIME
'03:01:13')) AS STRING(586))))
+SELECT ALL t0.c0, v0.c0 FROM v0 JOIN t0 ON ((upper(COALESCE('',
'4321901')))ILIKE(CAST(COALESCE(sql_max(TIME '05:11:41', TIME '21:08:38'),
COALESCE(TIME '05:10:13', TIME '14:42:56'), sql_min(TIME '16:14:39', TIME
'03:01:13')) AS STRING(586))))
----
statement ok
@@ -402,8 +402,8 @@ 386205865
statement ok
create view v0(c0, c1, c2, c3) as (
-select distinct cast(case time '03:52:21' when time '05:04:36' then r'0.2' end
as date),
-coalesce (t0.c0, length(coalesce (r't%QB', replace(r' ,yO_5G刵i稶bDßᶏ''',
r'0.8', r'-1e500')))), 1, timestamp '1970-01-16 13:47:20' from t0) with check
option
+select distinct cast(case time '03:52:21' when time '05:04:36' then '0.2' end
as date),
+coalesce (t0.c0, length(coalesce ('t%QB', replace(' ,yO_5G刵i稶bDßᶏ''', '0.8',
'-1e500')))), 1, timestamp '1970-01-16 13:47:20' from t0) with check option
query I rowsort
SELECT COUNT(*) FROM v0 LEFT OUTER JOIN t0 ON COALESCE(v0.c1, v0.c2) BETWEEN
v0.c2 AND t0.c0
@@ -500,8 +500,8 @@ SELECT ALL t1.c0 FROM t1, t2 CROSS JOIN
WHEN 0.05049592582495154857724628527648746967315673828125 THEN t2.c2
END)>(greatest(t2.c2, t2.c0))) FROM t2
RIGHT OUTER JOIN (SELECT ALL l1t1.c0, CASE WHEN l1t1.c0 THEN l1t1.c0 WHEN
l1t1.c0 THEN l1t1.c0 WHEN l1t1.c0
THEN l1t1.c0 END FROM t2 AS l1t2, t1 AS l1t1 WHERE l1t1.c0) AS sub0 ON
((FALSE)OR(TRUE))
-CROSS JOIN (VALUES (r'-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
-THEN r'Bv*氅.x' END), (r'', 0.7763767959438655, "insert"(r'RR6Mw+', 5,
-65604773, r'1225096844'))) AS sub1)) AS sub0
+CROSS JOIN (VALUES ('-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
+THEN 'Bv*氅.x' END), ('', 0.7763767959438655, "insert"('RR6Mw+', 5, -65604773,
'1225096844'))) AS sub1)) AS sub0
CROSS JOIN (VALUES (2, ((0.53827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1
WHERE (3.0) IS NOT NULL
----
@@ -513,8 +513,8 @@ SELECT CAST(SUM(count) AS BIGINT) FROM (
EXCEPT ALL (SELECT ALL ((CASE
0.54967607103225102349597364082001149654388427734375 WHEN
0.05049592582495154857724628527648746967315673828125
THEN t2.c2 END)>(greatest(t2.c2, t2.c0))) FROM t2 RIGHT OUTER JOIN (SELECT
l1t1.c0, CASE WHEN l1t1.c0 THEN l1t1.c0
WHEN l1t1.c0 THEN l1t1.c0 WHEN l1t1.c0 THEN l1t1.c0 END FROM t2 AS l1t2, t1 AS
l1t1 WHERE l1t1.c0) AS sub0 ON ((FALSE)OR(TRUE))
-CROSS JOIN (VALUES (r'-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
-THEN r'Bv*氅.x' END), (r'', 0.7763767959438655, "insert"(r'RR6Mw+', 5,
-65604773, r'1225096844'))) AS sub1)) AS sub0
+CROSS JOIN (VALUES ('-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
+THEN 'Bv*氅.x' END), ('', 0.7763767959438655, "insert"('RR6Mw+', 5, -65604773,
'1225096844'))) AS sub1)) AS sub0
CROSS JOIN (VALUES (2, ((0.53827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1) as res
----
896
diff --git a/sql/test/SQLancer/Tests/sqlancer03.test
b/sql/test/SQLancer/Tests/sqlancer03.test
--- a/sql/test/SQLancer/Tests/sqlancer03.test
+++ b/sql/test/SQLancer/Tests/sqlancer03.test
@@ -1,5 +1,5 @@
query TTT rowsort
-select splitpart(r'%Fz晟2墁', '', 1), splitpart(r'%Fz晟2墁', r'', 2),
splitpart(r'%Fz晟2墁', r'', 1271186887)
+select splitpart('%Fz晟2墁', '', 1), splitpart('%Fz晟2墁', '', 2),
splitpart('%Fz晟2墁', '', 1271186887)
----
%Fz@2@@
(empty)
@@ -57,7 +57,7 @@ SELECT sql_min(sql_max(NULL, ''), '')
NULL
query IR rowsort
-SELECT ALL length(upper(MIN(ALL CAST(((trim(CAST(r'' AS STRING(659)),
CAST(r'o3%+i]抔DCöf▟nßOpNbybಜ7' AS STRING)))||(sql_min(sql_max(NULL, r''),
splitpart(r'x', r',7+.', t0.c1)))) AS STRING(151))))), 0.4179268710155164
+SELECT ALL length(upper(MIN(ALL CAST(((trim(CAST('' AS STRING(659)),
CAST('o3%+i]抔DCöf▟nßOpNbybಜ7' AS STRING)))||(sql_min(sql_max(NULL, ''),
splitpart('x', ',7+.', t0.c1)))) AS STRING(151))))), 0.4179268710155164
FROM v0 LEFT OUTER JOIN t0 ON NOT (t0.c0) WHERE t0.c0 GROUP BY 0.3584962,
CAST(t0.c1 AS STRING(601)), t0.c1
----
@@ -214,7 +214,7 @@ statement ok
CREATE TABLE t0(c0 boolean, c1 boolean, c2 int, UNIQUE(c0, c1))
statement ok rowcount 2
-INSERT INTO t0(c1) VALUES((0.5) NOT BETWEEN SYMMETRIC
(CAST(length(upper(r'z')) AS INT)) AND (2)), (FALSE)
+INSERT INTO t0(c1) VALUES((0.5) NOT BETWEEN SYMMETRIC
(CAST(length(upper('z')) AS INT)) AND (2)), (FALSE)
statement ok rowcount 1
INSERT INTO t0(c0) VALUES(TRUE)
@@ -223,7 +223,7 @@ statement ok rowcount 2
INSERT INTO t0(c1) VALUES(FALSE), (TRUE)
statement ok rowcount 3
-INSERT INTO t0(c2, c0, c1) VALUES(2, (ltrim(lower(r'K'), ((upper(r'4'))||(-
(7))))) IS NOT NULL, (((lower(r'ö
+INSERT INTO t0(c2, c0, c1) VALUES(2, (ltrim(lower('K'), ((upper('4'))||(-
(7))))) IS NOT NULL, (((lower('ö
eg#K,纗HSJw!{cOw⇒l/l!B*H'))||(((CAST(0.1 AS INT))+(-5))))) IN (lower(CAST(TRUE
AS STRING)))), (-9, NULL, (0.3) NOT IN (2.96348087E8, 0.3)), (4, TRUE, (0.5)
NOT IN (-3, 4))
statement ok rowcount 1
@@ -245,7 +245,7 @@ statement ok rowcount 1
DELETE FROM t0 WHERE (t0.c0) = FALSE
statement ok rowcount 1
-INSERT INTO t0(c1, c0, c2) VALUES(TRUE, ((+ (- (1)))>(charindex(CAST(0.3 AS
STRING), ((CAST(TRUE AS STRING(771)))||(0.2)), length(r'd')))), -1)
+INSERT INTO t0(c1, c0, c2) VALUES(TRUE, ((+ (- (1)))>(charindex(CAST(0.3 AS
STRING), ((CAST(TRUE AS STRING(771)))||(0.2)), length('d')))), -1)
statement ok rowcount 14
UPDATE t0 SET c2 = 1 WHERE ((((t0.c1)OR(CAST(t0.c2 AS BOOLEAN))))OR((CAST(0.6
AS DECIMAL)) NOT IN (0.1)))
@@ -604,8 +604,8 @@ True
True
query I rowsort
-select count(all coalesce ((case coalesce (1, 2) when case cast(t0.c0 as
double) when sql_max(r'', null)
-then ((12)/(23)) end then cast("truncate"(r'1', 54) as boolean) else (coalesce
(true, true, r'1', true)) = false end) = true, (t0.c0) not in (t0.c0))) from t0
+select count(all coalesce ((case coalesce (1, 2) when case cast(t0.c0 as
double) when sql_max('', null)
+then ((12)/(23)) end then cast("truncate"('1', 54) as boolean) else (coalesce
(true, true, '1', true)) = false end) = true, (t0.c0) not in (t0.c0))) from t0
----
5
@@ -671,7 +671,7 @@ COPY 4 RECORDS INTO "sys"."t1" FROM stdi
"1970-01-14 01:01:12.000000"
statement error 42000!Wrong format (11313451898)
-select all sum(all cast("concat"(cast("month"(t1.c0) as string),
r'1313451898') as interval month)) from t1
+select all sum(all cast("concat"(cast("month"(t1.c0) as string), '1313451898')
as interval month)) from t1
statement ok
ROLLBACK
@@ -701,8 +701,8 @@ 20
statement ok
create view v0(c0, c1, c2, c3) as (
- select distinct cast(case time '03:52:21' when time '05:04:36' then
r'0.2' end as date),
- coalesce (t0.c0, length(coalesce (r't%QB', replace(r' ,yO_5G刵i稶bDßᶏ''',
r'0.8', r'-1e500')))), 1, timestamp '1970-01-16 13:47:20' from t0) with check
option
+ select distinct cast(case time '03:52:21' when time '05:04:36' then
'0.2' end as date),
+ coalesce (t0.c0, length(coalesce ('t%QB', replace(' ,yO_5G刵i稶bDßᶏ''',
'0.8', '-1e500')))), 1, timestamp '1970-01-16 13:47:20' from t0) with check
option
query T rowsort
select v0.c0 from v0 join t0 on (0.3) not in
@@ -843,7 +843,7 @@ 1411861402 83084647 NULL
1844355385 0.6101178479960011 1733503642.000
statement error 42000!Decimal
(0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131,0.5787210717348131)
doesn't have format (18.3)
-select cast(group_concat(all r'0.5787210717348131') as decimal) from t0 group
by - (abs(- (- (1061572565)))), least(t0.c0, least(cast(0.09300166 as int),
t0.c0))
+select cast(group_concat(all '0.5787210717348131') as decimal) from t0 group
by - (abs(- (- (1061572565)))), least(t0.c0, least(cast(0.09300166 as int),
t0.c0))
statement ok
ROLLBACK
@@ -923,7 +923,7 @@ NULL
query T rowsort
SELECT TIME '08:16:10' FROM t1 JOIN t0 ON (t1.c0) NOT BETWEEN SYMMETRIC
(t1.c0) AND (charindex(CAST(TIME '04:39:29' AS STRING), CASE COALESCE
(TIMESTAMP '1970-01-02 23:16:17', TIMESTAMP '1970-01-02 23:07:33')
-WHEN COALESCE (DATE '1970-01-12', DATE '1970-01-02', DATE '1970-01-02') THEN
COALESCE (r'/6望', r'hr?r3QDF*OD%6癰if}䃒5') END, t0.c0)) GROUP BY t1.c0
+WHEN COALESCE (DATE '1970-01-12', DATE '1970-01-02', DATE '1970-01-02') THEN
COALESCE ('/6望', 'hr?r3QDF*OD%6癰if}䃒5') END, t0.c0)) GROUP BY t1.c0
----
statement ok
@@ -984,11 +984,11 @@ SELECT 1 FROM t0 GROUP BY 1, 2 HAVING MA
1
query IT rowsort
-SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim(r'W', r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING))))
FROM t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING MAX(ALL TRUE)
+SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim('W', '1')))||(lower(CAST((('3')||(INTERVAL '4' MONTH)) AS STRING)))) FROM
t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING MAX(ALL TRUE)
UNION ALL
-SELECT COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING), trim(r'W',
r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING)))) FROM t0 WHERE
((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING NOT (MAX(ALL TRUE))
+SELECT COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING), trim('W',
'1')))||(lower(CAST((('3')||(INTERVAL '4' MONTH)) AS STRING)))) FROM t0 WHERE
((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING NOT (MAX(ALL TRUE))
UNION ALL
-SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim(r'W', r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING))))
FROM t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING (MAX(ALL TRUE)) IS NULL
+SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim('W', '1')))||(lower(CAST((('3')||(INTERVAL '4' MONTH)) AS STRING)))) FROM
t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING (MAX(ALL TRUE)) IS NULL
----
6
0.434
@@ -1017,7 +1017,7 @@ SELECT v2.c0 FROM v2 WHERE v2.c1 = '1' A
----
statement ok
-create view v0(c0, c1, c2, c3) as (select distinct 0.1,
((lower((((('&')||(2)))||(0.1))))||((('-1')||(abs(cast(r'1' as int)))))), 0.1,
cot(((((- (((2)&(3))))+(abs(4))))*(- (cast(cast(5 as string) as int))))) from
t0)
+create view v0(c0, c1, c2, c3) as (select distinct 0.1,
((lower((((('&')||(2)))||(0.1))))||((('-1')||(abs(cast('1' as int)))))), 0.1,
cot(((((- (((2)&(3))))+(abs(4))))*(- (cast(cast(5 as string) as int))))) from
t0)
query R rowsort
SELECT v0.c0 FROM v0 WHERE NOT (NOT (((((((((NOT
(((v0.c1)LIKE(v0.c1))))AND(((v0.c2)>=(v0.c0)))))AND(((v0.c3) BETWEEN SYMMETRIC
(v0.c3) AND (v0.c3)) = TRUE)))AND
@@ -1037,7 +1037,7 @@ statement ok rowcount 1
insert into t0(c0) values (1 between 2 and 3)
statement ok rowcount 3
-insert into t0(c0) values(13), (((cast((0.1) between symmetric (0.2) and (0.3)
as int))%(length(upper(r'u鋔wsD30pYi&ᴮ*2*W쉉t+詫sD^#cjX{'))))),
(cast(cast(cast(0.12 as int) as string(646)) as int))
+insert into t0(c0) values(13), (((cast((0.1) between symmetric (0.2) and (0.3)
as int))%(length(upper('u鋔wsD30pYi&ᴮ*2*W쉉t+詫sD^#cjX{'))))),
(cast(cast(cast(0.12 as int) as string(646)) as int))
query I rowsort
SELECT COUNT(t0.c0 = t0.c0 OR 1 BETWEEN ASYMMETRIC 1 AND 1) FROM t0
@@ -1045,7 +1045,7 @@ SELECT COUNT(t0.c0 = t0.c0 OR 1 BETWEEN
4
query RIR rowsort
-SELECT 0.9, COUNT(ALL (((((((CAST(TRUE AS INT))-(t0.c0)))=(t0.c0))) =
TRUE)OR((CAST(char_length(r'H') AS INT)) BETWEEN ASYMMETRIC (CAST(-1.3 AS INT))
AND (+ (length(r'0')))))), 0.3 FROM t0 GROUP BY 0.5, 0.4
+SELECT 0.9, COUNT(ALL (((((((CAST(TRUE AS INT))-(t0.c0)))=(t0.c0))) =
TRUE)OR((CAST(char_length('H') AS INT)) BETWEEN ASYMMETRIC (CAST(-1.3 AS INT))
AND (+ (length('0')))))), 0.3 FROM t0 GROUP BY 0.5, 0.4
----
0.900
4
diff --git a/sql/test/SQLancer/Tests/sqlancer04.test
b/sql/test/SQLancer/Tests/sqlancer04.test
--- a/sql/test/SQLancer/Tests/sqlancer04.test
+++ b/sql/test/SQLancer/Tests/sqlancer04.test
@@ -13,20 +13,20 @@ 2136089006
query R rowsort
SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0,
t0.c0))))) GROUP BY 0.1
-HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
+HAVING MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
-HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
+HAVING NOT (MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
UNION ALL SELECT ALL SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
-HAVING (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538))))))
IS NULL
+HAVING (MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538))))))
IS NULL
----
query R rowsort
SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0 WHERE
((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0), nullif(t0.c0,
t0.c0))))) GROUP BY 0.1
-HAVING MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
+HAVING MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538)))))
UNION ALL SELECT SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
-HAVING NOT (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
+HAVING NOT (MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS
STRING(538))))))
UNION ALL SELECT ALL SUM(ALL 0.12830007105673624234754015560611151158) FROM t0
WHERE ((sql_min(t0.c0, t0.c0))<>(COALESCE (t0.c0, sql_min(abs(t0.c0),
nullif(t0.c0, t0.c0))))) GROUP BY 0.1
-HAVING (MIN(ALL ((r'946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538))))))
IS NULL
+HAVING (MIN(ALL (('946496923')LIKE(CAST(nullif(0.5, 0.03) AS STRING(538))))))
IS NULL
----
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
