Bug #22116
closedIFNULL operator cannot be parsed
0%
Description
When using tt_news and choosing to restrict the list of news with a set of news categories, FE rendering crashes with:
Could not parse where clause in /path/to/dbal/class.ux_t3lib_db.php : 1072
This is due by tt_news which issues this kind of query:
1=1 AND (IFNULL IN (21,22)) AND tt_news.sys_language_uid IN (0,-1) AND tt_news.pid > 0 AND tt_news.pid IN (61) AND tt_news.deleted=0 AND tt_news.t3ver_state<=0 AND tt_news.hidden=0 AND tt_news.starttime<=1266057900 AND (tt_news.endtime=0 OR tt_news.endtime>1266057900) AND (tt_news.fe_group='' OR tt_news.fe_group IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR tt_news.fe_group='-1'))
Problem is the IFNULL which cannot be parsed ATM.
(issue imported from #M13531)
Updated by Xavier Perseguers almost 15 years ago
- Oracle equivalent is NVL : http://www.techonthenet.com/oracle/functions/nvl.php
- MSSQL is IFNULL too
- PostgreSQL would use COALESCE