Changeset: 5305cc5cbb8a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5305cc5cbb8a
Modified Files:
sql/test/SQLancer/Tests/sqlancer19.SQL.py
sql/test/SQLancer/Tests/sqlancer21.SQL.py
Branch: default
Log Message:
algebra.fetch generated call on remote plans is an issue, so move it to test
file with failing tests
diffs (54 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
@@ -331,13 +331,6 @@ with SQLTestCase() as cli:
("BW5z",),(".#OJruk",),("lU1覃Nlm",),(None,),("968786590",)])
cli.execute("ROLLBACK;")
- cli.execute("CREATE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a;")
- # At the moment I take this as a feature. Later we could replace the
algebra.fetch call with something more appropriate
- cli.execute("SELECT 1 FROM rt3 HAVING (min(TIME '02:00:00') IN (TIME
'02:00:00')) IS NULL;") \
- .assertFailed(err_message="Illegal argument: cannot fetch a single row
from an empty input")
- cli.execute("SELECT 1 FROM rt3 HAVING mybooludf(min(false));") \
- .assertFailed(err_message="Illegal argument: cannot fetch a single row
from an empty input")
-
cli.execute("""
START TRANSACTION;
DROP TABLE rt1;
@@ -355,5 +348,4 @@ with SQLTestCase() as cli:
DROP TABLE t5;
DROP TABLE t6;
DROP TABLE t7;
- DROP FUNCTION mybooludf(bool);
COMMIT;""").assertSucceeded()
diff --git a/sql/test/SQLancer/Tests/sqlancer21.SQL.py
b/sql/test/SQLancer/Tests/sqlancer21.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer21.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer21.SQL.py
@@ -12,6 +12,7 @@ with SQLTestCase() as cli:
START TRANSACTION;
CREATE TABLE "t1" ("c0" BIGINT,"c1" INTERVAL MONTH);
INSERT INTO "t1" VALUES (1, INTERVAL '9' MONTH),(5, INTERVAL '6'
MONTH),(5, NULL),(7, NULL),(2, INTERVAL '1' MONTH),(2, INTERVAL '1' MONTH);
+ CREATE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a;
COMMIT;
START TRANSACTION;
@@ -36,8 +37,19 @@ with SQLTestCase() as cli:
cli.execute("SELECT 1 FROM rt1 where rt1.c0 = 1 AND abs(0.4) = 0;") \
.assertSucceeded().assertDataResultMatch([])
+ # We should replace algebra.fetch call with something more appropriate
+ cli.execute("SELECT 1 FROM t1 HAVING (min(TIME '02:00:00') IN (TIME
'02:00:00')) IS NULL;") \
+ .assertSucceeded().assertDataResultMatch([])
+ cli.execute("SELECT 1 FROM rt1 HAVING (min(TIME '02:00:00') IN (TIME
'02:00:00')) IS NULL;") \
+ .assertSucceeded().assertDataResultMatch([])
+ cli.execute("SELECT 1 FROM t1 HAVING mybooludf(min(false));") \
+ .assertSucceeded().assertDataResultMatch([])
+ cli.execute("SELECT 1 FROM rt1 HAVING mybooludf(min(false));") \
+ .assertSucceeded().assertDataResultMatch([])
+
cli.execute("""
START TRANSACTION;
DROP TABLE rt1;
DROP TABLE t1;
+ DROP FUNCTION mybooludf(bool);
COMMIT;""").assertSucceeded()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
