Changeset: b816d9442281 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b816d9442281
Added Files:
sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py
Modified Files:
sql/test/BugTracker-2022/Tests/All
Branch: Jan2022
Log Message:
Add test for Bug-7298.
diffs (72 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
@@ -1,3 +1,4 @@
+incomplete-sql-script.Bug-7298
transaction-conflict.Bug-7228
insert-not-null.Bug-7232
!ARCH_BITS32?index-function-query.Bug-7238
diff --git
a/sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py
b/sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2022/Tests/incomplete-sql-script.Bug-7298.SQL.py
@@ -0,0 +1,59 @@
+from MonetDBtesting.sqltest import SQLTestCase
+import tempfile
+
+with SQLTestCase() as tc:
+
+ with tempfile.TemporaryFile('w+') as tf:
+ s1 = "select foo"
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!syntax error, unexpected
$end in: "select foo"')
+ tf.seek(0)
+ tf.truncate(0)
+
+ s1 = "select E'foo"
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!Unexpected end of input')
+ tf.seek(0)
+ tf.truncate(0)
+
+ s1 = "select foo."
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!syntax error, unexpected
$end, expecting SCOLON in: "select foo."')
+ tf.seek(0)
+ tf.truncate(0)
+
+ s1 = "select foo-"
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!syntax error, unexpected
$end, expecting SCOLON in: "select foo-"')
+ tf.seek(0)
+ tf.truncate(0)
+
+ s1 = "select f001234"
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!syntax error, unexpected
$end in: "select f001234"')
+ tf.seek(0)
+ tf.truncate(0)
+
+ s1 = "select \"foo"
+ tf.write(s1)
+ tf.flush()
+ tf.seek(0)
+
+ tc.execute(None, '-fraw', client='mclient',
stdin=tf).assertFailed(err_code="42000", err_message='!Unexpected end of input')
+ tf.seek(0)
+ tf.truncate(0)
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
