ezsystems/ezoracle — pull request #14 by jjCavalleri (2013-05-09 14:56:24+00:00)
Title: Fixed #20824: ezoracledb->generateSQLINStatement - not working correctly for items > 1000

all credit should goes to Felix Woldt (Thank you, sir)

This patch enforces that **OR** clauses are encapsulated in braces ( **(** ... **)** ) , on the referred method

Sample test case:
$db = eZDB::instance();
$idList = range( 1, 2005 );
$sqlINString = $db->generateSQLINStatement( $idList, ' table_name.id', false, false, 'int' );
$cli->output( "select * from table_name where $sqlINString and cond=1" );

(without the patch, "cond=1" is only combined with the last remaining 5 id's)