Author: dr
Date: Thu Jan 3 16:48:02 2008
New Revision: 7060
Log:
- Add a test cast for bug #11784.
Modified:
trunk/Database/tests/sqlabstraction/query_subselect_test.php
Modified: trunk/Database/tests/sqlabstraction/query_subselect_test.php
==============================================================================
--- trunk/Database/tests/sqlabstraction/query_subselect_test.php [iso-8859-1]
(original)
+++ trunk/Database/tests/sqlabstraction/query_subselect_test.php [iso-8859-1]
Thu Jan 3 16:48:02 2008
@@ -159,6 +159,24 @@
$this->assertEquals( $reference, $q2->getQuery() );
}
+ public function testBug11784()
+ {
+ $db = ezcDbInstance::get();
+ $q = $db->createSelectQuery();
+ $q->select( 'somecol' )->from( 'quiz' );
+
+ $qQuestions = $q->subSelect();
+ $qQuestions->select( 'id' )->from( 'question' )->where(
+ $qQuestions->expr->eq( 'quiz', $qQuestions->bindValue( 1 ) )
+ );
+
+ $q->where(
+ $q->expr->in( 'question', $qQuestions )
+ );
+
+ $this->assertEquals( "SELECT somecol FROM quiz WHERE question IN ( (
SELECT id FROM question WHERE quiz = :ezcValue1 ) )", $q->getQuery() );
+ }
+
public static function suite()
{
--
svn-components mailing list
svn-components@lists.ez.no
http://lists.ez.no/mailman/listinfo/svn-components
