Project

General

Profile

Actions

Bug #22116

closed

IFNULL operator cannot be parsed

Added by Xavier Perseguers almost 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-02-13
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)


Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #17552: IFNULL operator cannot be parsedClosedXavier Perseguers2007-08-22

Actions
Actions #1

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

Actions

Also available in: Atom PDF