[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