Changeset: 787129b6e7d4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/787129b6e7d4
Modified Files:
sql/test/prepare/Tests/named_placeholders.test
Branch: default
Log Message:
Add more tests for the named parameters
diffs (28 lines):
diff --git a/sql/test/prepare/Tests/named_placeholders.test
b/sql/test/prepare/Tests/named_placeholders.test
--- a/sql/test/prepare/Tests/named_placeholders.test
+++ b/sql/test/prepare/Tests/named_placeholders.test
@@ -3,3 +3,24 @@ SELECT :banana;
statement error 42000!Named placeholder ('pear') not used in the query.
SELECT :banana : ( pear 'mango' );
+
+query T
+SELECT :banana : ( banana 'foo');
+----
+foo
+
+statement ok
+create table tst_table (x int, y int);
+
+statement ok
+insert into tst_table (x, y) values (:x, :y) : (x 1, y 1);
+insert into tst_table (x, y) values (:x, :y) : (x 2, y 4);
+
+query II rowsort
+SELECT x, y from tst_table;
+----
+1
+1
+2
+4
+
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
