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

[Martin Kutschker]

Am 12.08.2010 14:12, schrieb Xavier Perseguers:
>> 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:

AFAIR also PostgreSQL doesn't like it.

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

Yep, Mysql and PHP allow a very sloppy style. Remember not to rely on implicit type-casting.

Masi