Changeset: d97e0b58ba9c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d97e0b58ba9c
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.test
sql/test/SQLancer/Tests/sqlancer06.test
sql/test/SQLancer/Tests/sqlancer07.test
sql/test/SQLancer/Tests/sqlancer08.test
Branch: mtest
Log Message:
Fixed errors on sqlancer tests conversions
diffs (112 lines):
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
@@ -136,9 +136,11 @@ INSERT INTO t0(c0) VALUES(TRUE)
statement ok
INSERT INTO t0(c1) VALUES(FALSE), (TRUE)
-statement error
+statement ok
INSERT INTO t0(c2, c0, c1) VALUES(2, (ltrim(lower(r'K'), ((upper(r'4'))||(-
(7))))) IS NOT NULL, (((lower(r'ö
-eg
+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
INSERT INTO t0(c1) VALUES(TRUE)
statement ok
@@ -168,6 +170,8 @@ SELECT t0.c0 FROM t0 WHERE ((CAST(t0.c2
True
True
True
+True
+True
query T rowsort
SELECT t0.c0 FROM t0 WHERE (t0.c2) BETWEEN (t0.c0) AND ((t0.c2) NOT IN (t0.c2))
diff --git a/sql/test/SQLancer/Tests/sqlancer06.test
b/sql/test/SQLancer/Tests/sqlancer06.test
--- a/sql/test/SQLancer/Tests/sqlancer06.test
+++ b/sql/test/SQLancer/Tests/sqlancer06.test
@@ -144,10 +144,12 @@ 1
1
1
-statement error
-SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(t2.c2 AS INT) as count
FROM t2 LEFT OUTER JOIN t0 ON (CASE CAST(t2.c0 AS VARCHAR(32)) WHEN CAST('*D'
AS VARCHAR(32)) THEN CASE 'u
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(t2.c2 AS INT) as count
FROM t2 LEFT OUTER JOIN t0 ON (CASE CAST(t2.c0 AS VARCHAR(32)) WHEN CAST('*D'
AS VARCHAR(32)) THEN CASE 'u--'
WHEN 'Q' THEN 0.81 END WHEN CAST(t2.c2 AS VARCHAR(32)) THEN CASE 51854410 WHEN
0.6132552 THEN 134188918 END WHEN COALESCE('鈋', 'Nb|k', 's{%g.8Bj') THEN
CAST(571120738 AS INT)
ELSE CAST(0.13 AS REAL) END) IS NOT NULL CROSS JOIN (SELECT ALL
COALESCE(t1.c0, t0.c0) FROM t0, t1) AS sub0) as res
+----
+54
statement ok
ROLLBACK
diff --git a/sql/test/SQLancer/Tests/sqlancer07.test
b/sql/test/SQLancer/Tests/sqlancer07.test
--- a/sql/test/SQLancer/Tests/sqlancer07.test
+++ b/sql/test/SQLancer/Tests/sqlancer07.test
@@ -103,7 +103,7 @@ CREATE TABLE "t1" ("c0" DECIMAL(18,3))
statement ok
CREATE TABLE "t2" ("c0" DECIMAL(18,3),"c2" DATE)
-statement error
+statement ok
PREPARE (SELECT DISTINCT t0.c0, INTERVAL '1734780053' SECOND FROM t0, t1)
UNION ALL (SELECT ?, ? FROM t2)
statement ok
@@ -143,7 +143,7 @@ CREATE TABLE "t1" ("c1" TIMESTAMP,"c2" I
statement ok
CREATE TABLE "t2" ("c0" DATE,"c1" TIMESTAMP,"c2" INTEGER)
-statement error
+statement ok
PREPARE (SELECT ?, t1.c2 FROM t1, t0 WHERE (SELECT DISTINCT (t1.c2) BETWEEN
ASYMMETRIC (?) AND (t1.c2) FROM t1 CROSS JOIN
((SELECT DISTINCT 6.9089063E7, TRUE FROM t2 WHERE TRUE) EXCEPT (SELECT ALL
0.4, FALSE FROM t2, t1 INNER JOIN t0 ON FALSE)) AS sub0 WHERE FALSE)) INTERSECT
DISTINCT (SELECT DISTINCT 0.2, ? FROM t0, t2 WHERE ?)
@@ -356,7 +356,7 @@ SELECT 1 WHERE (SELECT 1 WHERE FALSE) IS
----
1
-statement error
+statement ok
PREPARE SELECT 1 WHERE greatest(true, ?)
statement error
@@ -702,10 +702,10 @@ SELECT CAST(((24829)+(((0.97677510311405
----
False
-statement error
+statement ok
PREPARE SELECT (1 + CAST(l0t0.c0 AS BIGINT)) * scale_up(?, 2) FROM (select 1)
AS l0t0(c0)
-statement error
+statement ok
PREPARE SELECT DISTINCT ((((CAST(l0t0.c0 AS INT))-(CAST(? AS
BIGINT))))*(scale_up(?, ((-438139776)*(-813129345))))) FROM (select 1) AS
l0t0(c0)
query T rowsort
diff --git a/sql/test/SQLancer/Tests/sqlancer08.test
b/sql/test/SQLancer/Tests/sqlancer08.test
--- a/sql/test/SQLancer/Tests/sqlancer08.test
+++ b/sql/test/SQLancer/Tests/sqlancer08.test
@@ -287,10 +287,10 @@ DELETE FROM salesmart WHERE (((CAST(CAST
statement ok
ROLLBACK
-statement error
+statement ok
PREPARE SELECT round(-'b', ?)
-statement error
+statement ok
PREPARE SELECT sql_max(+ (0.29353363282850464), round(- (sql_min('-Infinity',
?)), ?)) LIMIT 8535194086169274474
statement error
@@ -431,7 +431,7 @@ select round(t2.tc0, 88) from t2
statement ok
ROLLBACK
-statement error
+statement ok
PREPARE (SELECT DISTINCT ((CAST(- (CASE r'' WHEN r'tU1{D^㙝U' THEN 1739172851
WHEN ? THEN -1313600539 WHEN r'X(%4}' THEN NULL WHEN r')帘''舻CD' THEN 95 END)
AS BIGINT))&(least(- (-235253756), 64)))
WHERE ((rtrim(r'Z'))LIKE(r'rK'))) UNION ALL (SELECT ALL ? WHERE
(scale_down(ifthenelse(TRUE, 18, ?), r'4')) IS NULL)
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
