#60653Parse "exotic" select statements in parenthesis correctly
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.