Fix it_dbi NOT IN with empty array and added IN/NOT IN tests

1 files changed, 20 insertions, 0 deletions

diff --git a/tests/it_dbi.t b/tests/it_dbi.t
index 9ffadc7..934e965 100755
--- a/tests/it_dbi.t
+++ b/tests/it_dbi.t
@@ -50,6 +50,26 @@ is(
 	"bar",
 	"select with multiple parameters (foo part)"
 );
+is(
+	$record->select(array('ID IN' => array(2,3))),
+	2,
+	"select with IN",
+);
+is(
+	$record->select(array('ID NOT IN' => array(2,3))),
+	1,
+	"select with NOT IN",
+);
+is(
+	$record->select(array('ID IN' => array())),
+	0,
+	"select with empty IN",
+);
+is(
+	$record->select(array('ID NOT IN' => array())),
+	3,
+	"select with empty NOT IN",
+);
 
 it_dbi::createclass(array('table' => "it_dbi_test", 'forcecreate' => true));