Changeset: 8f16e25b2090 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8f16e25b2090
Added Files:
sql/test/analytics/Tests/analytics20.SQL.py
sql/test/miscellaneous/Tests/deallocate.SQL.py
sql/test/miscellaneous/Tests/groupby_error.SQL.py
sql/test/miscellaneous/Tests/select_groupby.SQL.py
Removed Files:
sql/test/analytics/Tests/analytics20.test
Branch: mtest
Log Message:
fixed some miscellaneous tests
diffs (98 lines):
diff --git a/sql/test/analytics/Tests/analytics20.SQL.py
b/sql/test/analytics/Tests/analytics20.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/analytics/Tests/analytics20.SQL.py
@@ -0,0 +1,9 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('analytics20.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertSucceeded()\
+ .assertMatchStableOut(fout='analytics20.stable.out')
diff --git a/sql/test/analytics/Tests/analytics20.test
b/sql/test/analytics/Tests/analytics20.test
deleted file mode 100644
--- a/sql/test/analytics/Tests/analytics20.test
+++ /dev/null
@@ -1,37 +0,0 @@
-statement ok
-start transaction
-
-statement ok
-create table analytics (aa int, bb int, cc bigint)
-
-statement ok
-insert into analytics values (15, 3, 15), (3, 1, 3), (2, 1, 2), (5, 3, 5),
(NULL, 2, NULL), (3, 2, 3), (4, 1, 4), (6, 3, 6), (8, 2, 8), (NULL, 4, NULL)
-
-statement ok
-create table stressme (aa varchar(64), bb int)
-
-statement ok
-insert into stressme values ('one', 1), ('another', 1), ('stress', 1), (NULL,
2), ('ok', 2), ('check', 3), ('me', 3), ('please', 3), (NULL, 4)
-
-statement ok
-prepare select count(*) over (rows ? preceding) from analytics
-
-statement ok
-exec **(2)
-
-statement ok
-prepare select max(aa) over (rows between 5 preceding and ? following) from
stressme
-
-statement ok
-exec **(2)
-
-statement ok
-prepare select max(aa) over (order by bb range between ? preceding and 10
following) from stressme
-
-statement ok
-exec **(2)
-
-statement ok
-rollback
-
-
diff --git a/sql/test/miscellaneous/Tests/deallocate.SQL.py
b/sql/test/miscellaneous/Tests/deallocate.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/deallocate.SQL.py
@@ -0,0 +1,9 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('deallocate.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertMatchStableOut(fout='deallocate.stable.out')\
+ .assertMatchStableError(ferr='deallocate.stable.err')
diff --git a/sql/test/miscellaneous/Tests/groupby_error.SQL.py
b/sql/test/miscellaneous/Tests/groupby_error.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/groupby_error.SQL.py
@@ -0,0 +1,9 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('groupby_error.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertMatchStableOut(fout='groupby_error.stable.out')\
+ .assertMatchStableError(ferr='groupby_error.stable.err')
diff --git a/sql/test/miscellaneous/Tests/select_groupby.SQL.py
b/sql/test/miscellaneous/Tests/select_groupby.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/select_groupby.SQL.py
@@ -0,0 +1,9 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('select_groupby.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertMatchStableOut(fout='select_groupby.stable.out')\
+ .assertMatchStableError(ferr='select_groupby.stable.err')
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
