mORMot Open Source

imperyal

Member

Registered: 2018-10-11

Posts: 51

Possible bug executing SQL instructions with parentheses

Hello!

I'm using direct SQL execution to do some tasks. Today I encountered a problem that seems to be a Bug, but need your opinion/confirmation.
I'm using firebird. I debugged the code and my suspect is the TSQLRestStorageExternal.AdaptSQLForEngineList function.

The SQL gets cutted in this example:

Input SQL: SELECT codigo FROM rec_prf WHERE (nome='' OR nome IS NULL) AND EscolaID='Example'
Output SQL: select Codigo from rec_prf where (Nome='' or Nome is null

If no parentheses are used it works as expected.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,238

Website

Re: Possible bug executing SQL instructions with parentheses

Parenthesis are not yet supported, as documented.

imperyal

Member

Registered: 2018-10-11

Posts: 51

Re: Possible bug executing SQL instructions with parentheses

You're right, I found it mentioned.

Is there any way to execute a query without any conversion?