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