Changeset: 37eb0372ed86 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=37eb0372ed86
Added Files:
sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py
Modified Files:
sql/test/BugTracker-2020/Tests/All
Branch: Jun2020
Log Message:
Added test for bug 6846
diffs (33 lines):
diff --git a/sql/test/BugTracker-2020/Tests/All
b/sql/test/BugTracker-2020/Tests/All
--- a/sql/test/BugTracker-2020/Tests/All
+++ b/sql/test/BugTracker-2020/Tests/All
@@ -7,3 +7,4 @@ NOT_WIN32&HAVE_LIBR&HAVE_LIBPY3?function
cume-dist-wrong-results.Bug-6827
window-order-by-extract.Bug-6828
ntile-wrong-results.Bug-6829
+HAVE_PYMONETDB?global_table_propagation.Bug-6846
diff --git
a/sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py
b/sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/global_table_propagation.Bug-6846.py
@@ -0,0 +1,20 @@
+import os, pymonetdb
+
+port = int(os.environ['MAPIPORT'])
+db = os.environ['TSTDB']
+
+client1 = pymonetdb.connect(port=port,database=db,autocommit=True)
+client2 = pymonetdb.connect(port=port,database=db,autocommit=True)
+cursor1 = client1.cursor()
+cursor2 = client2.cursor()
+
+cursor1.execute('CREATE GLOBAL TEMPORARY TABLE close_d (qaid int, value_
float) ON COMMIT PRESERVE ROWS;')
+cursor1.execute('INSERT INTO tmp.close_d VALUES (1,1);')
+cursor2.execute('SELECT qaid, value_ FROM tmp.close_d;')
+cursor1.execute('SELECT qaid, value_ FROM tmp.close_d;')
+cursor1.execute('DROP TABLE tmp.close_d;')
+
+cursor1.close()
+cursor2.close()
+client1.close()
+client2.close()
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
