Changeset: 33e5332e892a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/33e5332e892a
Modified Files:
sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: default
Log Message:
Add test
diffs (14 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
@@ -365,6 +365,10 @@ with SQLTestCase() as cli:
.assertSucceeded().assertDataResultMatch([(None,),(None,),(None,),(None,),(None,),(None,)])
cli.execute("SELECT CASE WHEN rt3.c0 = 3 THEN (1) IN (SELECT 2 FROM rt3)
END FROM rt3;") \
.assertSucceeded().assertDataResultMatch([(None,),(None,),(None,),(None,),(None,),(None,)])
+ cli.execute("SELECT abs(2.47), ltrim(count(*)), ltrim(count(*),count(*)),
lower(count(*)) FROM t3 where t3.c0 = 1;") \
+
.assertSucceeded().assertDataResultMatch([(Decimal('2.47'),"1","","1")])
+ cli.execute("SELECT abs(2.47), ltrim(count(*)), ltrim(count(*),count(*)),
lower(count(*)) FROM rt3 where rt3.c0 = 1;") \
+
.assertSucceeded().assertDataResultMatch([(Decimal('2.47'),"1","","1")])
cli.execute("ROLLBACK;")
cli.execute("SELECT CASE 1 WHEN 5 THEN ((SELECT t3.c0) INTERSECT (SELECT
9)) ELSE (VALUES (t3.c0), (1)) END FROM t3;") \
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
