#014855: IN with subselects generates excessive braces

Description:

$q->select('id')->from('qualified_determinant')->where($q->expr->in('id', $sq));
$sq->select('determinant_profile_id')->from('q_det_ci')
    ->where($sq->expr->eq('car_id',$sq->bindValue($carindex)));

becomes:

SELECT id FROM qualified_determinant
WHERE id IN ( ( SELECT determinant_profile_id FROM q_det_ci WHERE car_id = :ezcValue1 ) )
    AND ( extra_id IN ( '413', '488', '506', '507', '698', '699', '700' ) OR extra_code IN ( 'DCP' ) )

This does work fine for the SQLite handler though.

Environment:

Operating System:
PHP Version: (please be specific, like '4.4.3' or '5.1.5')
Database and version:
Browser (and version):


- Attachments

No attachments for this issue.


- Comments

Fixed in rev. #10215.

#261473 by Derick Rethans on May 5th, 2009 [Permanent Link]

- History
Properties
Type Bug
Priority Medium
Component Components » Database
Affects Unknown
Fix Versions 2008.2.3 - eZ components 2008.2.3
2009.1alpha1 - eZ components 2009.1alpha1
Reporter Derick Rethans
Responsible Derick Rethans
Status 0 Closed
Resolution Fixed
Created May 5th, 2009
Updated May 5th, 2009
Resolved May 5th, 2009
 
Navigation [Permanent Link]
Previous Issue
Back to Issues List
Next Issue: #015537
  Graph shows to small and truncated rotated axis labels