Changeset: d38adecdb7fa for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d38adecdb7fa
Added Files:
sql/test/sysmon/timeout/Tests/timeout_cross.test
Removed Files:
sql/test/sysmon/timeout/Tests/timeout_cross.SQL.py
Branch: Jan2022
Log Message:
Converted test.
diffs (39 lines):
diff --git a/sql/test/sysmon/timeout/Tests/timeout_cross.SQL.py
b/sql/test/sysmon/timeout/Tests/timeout_cross.SQL.py
deleted file mode 100644
--- a/sql/test/sysmon/timeout/Tests/timeout_cross.SQL.py
+++ /dev/null
@@ -1,11 +0,0 @@
-from MonetDBtesting.sqltest import SQLTestCase
-
-with SQLTestCase() as tc:
- tc.connect()
- tc.execute("create table foo(id bigserial, value int);").assertSucceeded()
- tc.execute("create table bar(id bigserial, value int);").assertSucceeded()
- # test cross product
- tc.execute("insert into foo(value) (select * from
generate_series(0,10000));").assertSucceeded()
- tc.execute("insert into bar(value) (select * from
generate_series(0,10000));").assertSucceeded()
- tc.execute("call sys.setquerytimeout(1); select * from foo, bar;")\
- .assertFailed(err_code="HYT00", err_message="Query aborted due to
timeout")
diff --git a/sql/test/sysmon/timeout/Tests/timeout_cross.test
b/sql/test/sysmon/timeout/Tests/timeout_cross.test
new file mode 100644
--- /dev/null
+++ b/sql/test/sysmon/timeout/Tests/timeout_cross.test
@@ -0,0 +1,18 @@
+statement ok
+create table foo(id bigserial, value int)
+
+statement ok
+create table bar(id bigserial, value int)
+
+statement ok
+insert into foo(value) (select * from generate_series(0,10000))
+
+statement ok
+insert into bar(value) (select * from generate_series(0,10000))
+
+statement ok
+call sys.setquerytimeout(1)
+
+statement error HYT00!Query aborted due to timeout
+select * from foo, bar
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
