Changeset: f9ea742dbab9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f9ea742dbab9
Branch: mtest
Log Message:
merged
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
