Issue Bug Closed

#60653Parse "exotic" select statements in parenthesis correctly

Andreas Kienast 07/29/14, 09:26 updated 01/28/15, 20:52

Description

Currently I have the problem that the SqlParser cannot parse complex queries used in the core, e.g. in the extension manager.

For example, it fails at:

((extension_key like 'realurl') * 8 + (extension_key like '%realurl%') * 4 + (title like '%realurl%') * 2 + (author_name like '%realurl%')) as position"

The error is “SQL engine parse ERROR: No field name found as expected in parseFieldList()”. This query is fired after submitting the extension search form.

I tried to hack the specific part in the code by using “parseWhereClause” but that doesn’t work well, too, because it stops parsing at “* 8 + (blah blah)”.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.