test for between

[dbsrgits/Data-Query.git] / t / expr-helpers.t

diff --git a/t/expr-helpers.t b/t/expr-helpers.t
index 7b7137b..a64c9f3 100644 (file)
--- a/t/expr-helpers.t
+++ b/t/expr-helpers.t
@@ -86,3 +86,14 @@ dq_sql_is
   ),
   ['SELECT COUNT( * ) FROM foo'],
   'count';
+
+dq_sql_is
+  Where(
+    Operator({ 'SQL.Naive' => 'BETWEEN' }, [
+      Identifier('x'),
+      map Literal('SQL', '?', [ binding($_) ]), (1,2),
+    ]),
+    Select([ Identifier('*') ], Identifier('foo')),
+  ),
+  [ 'SELECT * FROM foo WHERE ( x BETWEEN ? AND ? )', map binding($_), 1, 2, ],
+  'between';