Simple between support

[dbsrgits/SQL-Abstract-2.0-ish.git] / t / 101_expr_funcitons.t

diff --git a/t/101_expr_funcitons.t b/t/101_expr_funcitons.t
index 29d7dee..13ec805 100644 (file)
--- a/t/101_expr_funcitons.t
+++ b/t/101_expr_funcitons.t
@@ -2,7 +2,7 @@
 use strict;
 use warnings;
 
-use Test::More tests => 3;
+use Test::More tests => 4;
 use Test::Differences;
 
 use_ok('SQL::Abstract') or BAIL_OUT( "$@" );
@@ -37,3 +37,15 @@ is $sqla->dispatch(
 ), "last_insert_id()",
    "last_insert_id";
 
+is $sqla->dispatch(
+  { -type => 'expr',
+    op => 'between',
+    args => [
+      {-type => name => args => [qw/me id/] }, 
+      { -type => 'value', value => 500 },
+      { -type => 'value', value => 599 },
+    ],
+  }
+), "me.id BETWEEN ? AND ?",
+   "between";
+