Changeset: a8cf49ef4444 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a8cf49ef4444
Added Files:
sql/test/BugTracker-2022/Tests/pkey-restart.Bug-7263.SQL.py
Modified Files:
sql/test/BugTracker-2022/Tests/All
Branch: Jan2022
Log Message:
Added test for bug #7263 Looking into it
diffs (42 lines):
diff --git a/sql/test/BugTracker-2022/Tests/All
b/sql/test/BugTracker-2022/Tests/All
--- a/sql/test/BugTracker-2022/Tests/All
+++ b/sql/test/BugTracker-2022/Tests/All
@@ -3,3 +3,4 @@ insert-not-null.Bug-7232
!ARCH_BITS32?index-function-query.Bug-7238
recreate-view.Bug-7241
HAVE_LIBPY3?python-udf-inside-udf.Bug-7252
+pkey-restart.Bug-7263
diff --git a/sql/test/BugTracker-2022/Tests/pkey-restart.Bug-7263.SQL.py
b/sql/test/BugTracker-2022/Tests/pkey-restart.Bug-7263.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2022/Tests/pkey-restart.Bug-7263.SQL.py
@@ -0,0 +1,29 @@
+import os, tempfile
+
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+from MonetDBtesting.sqltest import SQLTestCase
+
+with tempfile.TemporaryDirectory() as farm_dir:
+ os.mkdir(os.path.join(farm_dir, 'db1'))
+
+ with process.server(mapiport='0', dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE, stdout =
process.PIPE, stderr = process.PIPE) as s:
+ with SQLTestCase() as mdb:
+ mdb.connect(database='db1', port=s.dbport, username="monetdb",
password="monetdb")
+ mdb.execute("CREATE TABLE x (k int PRIMARY KEY, v
int);").assertSucceeded()
+ mdb.execute("INSERT INTO x VALUES(1, 1);").assertSucceeded()
+ mdb.execute("SELECT k, v FROM
x;").assertSucceeded().assertDataResultMatch([(1,1)])
+ mdb.execute("INSERT INTO x VALUES(1,
2);").assertFailed(err_code="40002", err_message="INSERT INTO: PRIMARY KEY
constraint 'x.x_k_pkey' violated")
+ mdb.execute("SELECT k, v FROM
x;").assertSucceeded().assertDataResultMatch([(1,1)])
+ s.communicate()
+
+ with process.server(mapiport='0', dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE, stdout =
process.PIPE, stderr = process.PIPE) as s:
+ with SQLTestCase() as mdb:
+ mdb.connect(database='db1', port=s.dbport, username="monetdb",
password="monetdb")
+ mdb.execute("SELECT k, v FROM
x;").assertSucceeded().assertDataResultMatch([(1,1)])
+ mdb.execute("INSERT INTO x VALUES(1,
2);").assertFailed(err_code="40002", err_message="INSERT INTO: PRIMARY KEY
constraint 'x.x_k_pkey' violated")
+ mdb.execute("SELECT k, v FROM
x;").assertSucceeded().assertDataResultMatch([(1,1)])
+ mdb.execute("DROP TABLE x;").assertSucceeded()
+ s.communicate()
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
