[TYPO3-core] FYI #15396: Wrong query - crashes with DBAL

Xavier Perseguers typo3 at perseguers.ch
Thu Aug 12 14:12:44 CEST 2010


> i normally use only WHERE 1 ...
> This looks in my eyes as a better placeholder for empty where instead of
> 1=1.
> Is that possible with DBAL?

It should not because the query would then be invalid, at least with Oracle:

ORA-00920: invalid relational operator
00920. 00000 -  "invalid relational operator"

This is the problem with MySQL and all those "PHP-like conditions" that 
are silently fixed.

Xavier


More information about the TYPO3-team-core mailing list