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

François Suter fsu-lists at cobweb.ch
Thu Aug 12 20:58:43 CEST 2010


Hi,

> the problem rise up when you compute where clause with enableField
> function which always add ' AND ...' which doesn't work with empty where
> clause.

I know, but in this case there's no enableField clause added afterwards.

> Normal select should work with empty string though, but not NULL

Indeed. So I would like to have '' instead of '1=1'.

> Anyway adding "1=1" as dummy doesn't harm imho, having where present is
> cleaner than omitting it, especially when you modify at later point.

I disagree. I think having all these '1=1' lying around is really lousy 
programming style.

Cheers

-- 

Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch


More information about the TYPO3-team-core mailing list