diff options
Diffstat (limited to 'dbstore/sql/test/queryrow/ids-arg-named.sql')
-rw-r--r-- | dbstore/sql/test/queryrow/ids-arg-named.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/dbstore/sql/test/queryrow/ids-arg-named.sql b/dbstore/sql/test/queryrow/ids-arg-named.sql new file mode 100644 index 0000000..984669d --- /dev/null +++ b/dbstore/sql/test/queryrow/ids-arg-named.sql @@ -0,0 +1,8 @@ +WITH ids(id, sort) AS ( + VALUES ('foo', 1), ('bar', 2), ('baz', 3) +) + +SELECT id + FROM ids + WHERE id = :q + ORDER BY sort; |