[TYPO3-core] RFC: Fix bug 4592: Keep indexed_search tables consistent when deleting pages

Dmitry Dulepov dmitry at typo3.org
Mon Feb 5 09:06:14 CET 2007


Hi!

Patch looks good, so go on :) However I remembered one thing that we 
want to consider for future (or at least keep in our heads). Problem can 
be in the quoted lines below:

Michael Stucki wrote:
> +		$where_clause = 'phash IN ('.implode(',',$GLOBALS['TYPO3_DB']->cleanIntArray($pHashesToDelete)).')';
...
> +			$GLOBALS['TYPO3_DB']->exec_DELETEquery($table, $where_clause);

I remember that Oracle (at least, Oracle 8) can have only 99 items in 
"IN" list. This is absolutely no problem here but can be a problem at 
some other place. Just keep it in your head...

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)


More information about the TYPO3-team-core mailing list