From 3e691e8e56417de13e2b958386af2059ba80ebbd Mon Sep 17 00:00:00 2001
From: Christian Schneider
Date: Tue, 17 Feb 2009 13:48:04 +0000
Subject: Fix it_dbi NOT IN with empty array and added IN/NOT IN tests

---
 tests/it_dbi.t | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'tests')

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));
 
-- 
cgit v1.2.3