Changeset: 357518f559e0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/357518f559e0
Modified Files:
sql/test/SQLancer/Tests/sqlancer12.SQL.py
Branch: Jul2021
Log Message:
Update test with dropping query causing inconsistency in the catalog
diffs (18 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer12.SQL.py
b/sql/test/SQLancer/Tests/sqlancer12.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer12.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer12.SQL.py
@@ -20,6 +20,8 @@ with tempfile.TemporaryDirectory() as fa
mdb.execute("CREATE TABLE t0(c0 CLOB, c1 boolean, c2 tinyint, c3
int, UNIQUE(c3, c1, c0, c2));").assertSucceeded()
mdb.execute("INSERT INTO t0(c0, c1, c3, c2) VALUES ('a', false, 2,
6);").assertSucceeded().assertRowCount(1)
mdb.execute("SELECT c0, c1, c2, c3 FROM
t0;").assertSucceeded().assertDataResultMatch([('a', False, 6, 2)])
+ mdb.execute('CREATE TABLE "t1" ("c0" INT,"c2" INT,CONSTRAINT
"con3" UNIQUE ("c0"));').assertSucceeded()
+ mdb.execute("ALTER TABLE t1 DROP c0 CASCADE;").assertSucceeded()
s.communicate()
with process.server(mapiport=port, dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE, stdout =
process.PIPE, stderr = process.PIPE) as s:
@@ -27,4 +29,5 @@ with tempfile.TemporaryDirectory() as fa
mdb.connect(database='db1', port=port, username="monetdb",
password="monetdb")
mdb.execute("SELECT c0, c1, c2, c3 FROM
t0;").assertSucceeded().assertDataResultMatch([('a', False, 6, 2)])
mdb.execute("DROP TABLE t0;").assertSucceeded()
+ mdb.execute("DROP TABLE t1;").assertSucceeded()
s.communicate()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
