Changeset: b5b7439391c1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b5b7439391c1
Added Files:
sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.SQL.py
sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.SQL.py
Removed Files:
sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.test
sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.test
Branch: mtest
Log Message:
fix more prepare tests
diffs (75 lines):
diff --git
a/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.SQL.py
b/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.SQL.py
new file mode 100644
--- /dev/null
+++
b/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.SQL.py
@@ -0,0 +1,11 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('prepare-where.SF-1238867.1238959.1238965.1240124.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+
.assertMatchStableOut(fout='prepare-where.SF-1238867.1238959.1238965.1240124.stable.out')\
+
.assertMatchStableError(ferr='prepare-where.SF-1238867.1238959.1238965.1240124.stable.err')
+
+
diff --git
a/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.test
b/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.test
deleted file mode 100644
---
a/sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.test
+++ /dev/null
@@ -1,13 +0,0 @@
-statement ok
-prepare select * from env() as env where 1 = ?
-
-statement error
-prepare select * from env() as env where ? = ?
-
-statement error
-prepare select ? from env() as env
-
-statement ok
-prepare select * from env() as env where name in (?)
-
-
diff --git a/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.SQL.py
b/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.SQL.py
@@ -0,0 +1,12 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ # optional or default connection
+ tc.connect()
+ with open('prepare_doesnot_like_LIKE.SF-1234205.sql') as f:
+ tc.execute(query=None, client='mclient', stdin=f)\
+ .assertSucceeded()\
+
.assertMatchStableOut(fout='prepare_doesnot_like_LIKE.SF-1234205.stable.out')\
+
+
+
diff --git a/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.test
b/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.test
deleted file mode 100644
--- a/sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.test
+++ /dev/null
@@ -1,19 +0,0 @@
-statement ok
-create table t1234205 (name varchar(1024))
-
-statement ok
-insert into t1234205 values ('niels'),('fabian'),('martin')
-
-statement ok
-prepare select name from t1234205 where name like ?
-
-statement ok
-exec ** ('%')
-
-statement ok
-prepare select name from t1234205 where name like 'n%'
-
-statement ok
-exec ** ()
-
-
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
