1 files changed, 79 insertions, 9 deletions
diff --git a/tests/codeigniter/database/query_builder/group_test.php b/tests/codeigniter/database/query_builder/group_test.php
index b40e5e507..df3f168c6 100644
--- a/tests/codeigniter/database/query_builder/group_test.php
+++ b/tests/codeigniter/database/query_builder/group_test.php
@@ -23,10 +23,10 @@ class Group_test extends CI_TestCase {
 	public function test_group_by()
 	{
 		$jobs = $this->db->select('name')
-					->from('job')
-					->group_by('name')
-					->get()
-					->result_array();
+			->from('job')
+			->group_by('name')
+			->get()
+			->result_array();
 
 		$this->assertCount(4, $jobs);
 	}
@@ -39,11 +39,81 @@ class Group_test extends CI_TestCase {
 	public function test_having_by()
 	{
 		$jobs = $this->db->select('name')
-					->from('job')
-					->group_by('name')
-					->having('SUM(id) > 2')
-					->get()
-					->result_array();
+			->from('job')
+			->group_by('name')
+			->having('SUM(id) > 2')
+			->get()
+			->result_array();
+
+		$this->assertCount(2, $jobs);
+	}
+
+	// ------------------------------------------------------------------------
+
+	/**
+	 * @see ./mocks/schema/skeleton.php
+	 */
+	public function test_having_in()
+	{
+		$jobs = $this->db->select('name')
+			->from('job')
+			->group_by('name')
+			->having_in('SUM(id)', array(1, 2, 5))
+			->get()
+			->result_array();
+
+		$this->assertCount(2, $jobs);
+	}
+
+	// ------------------------------------------------------------------------
+
+	/**
+	 * @see ./mocks/schema/skeleton.php
+	 */
+	public function test_or_having_in()
+	{
+		$jobs = $this->db->select('name')
+			->from('job')
+			->group_by('name')
+			->or_having_in('SUM(id)', array(1, 5))
+			->or_having_in('SUM(id)', array(2, 6))
+			->get()
+			->result_array();
+
+		$this->assertCount(2, $jobs);
+	}
+
+	// ------------------------------------------------------------------------
+
+	/**
+	 * @see ./mocks/schema/skeleton.php
+	 */
+	public function test_having_not_in()
+	{
+		$jobs = $this->db->select('name')
+			->from('job')
+			->group_by('name')
+			->having_not_in('SUM(id)', array(3, 6))
+			->get()
+			->result_array();
+
+		$this->assertCount(3, $jobs);
+	}
+
+	// ------------------------------------------------------------------------
+
+	/**
+	 * @see ./mocks/schema/skeleton.php
+	 */
+	public function test_or_having_not_in()
+	{
+		$jobs = $this->db->select('name')
+			->from('job')
+			->group_by('name')
+			->or_having_not_in('SUM(id)', array(1, 2, 3))
+			->or_having_not_in('SUM(id)', array(1, 3, 4))
+			->get()
+			->result_array();
 
 		$this->assertCount(2, $jobs);
 	}