mORMot Open Source

alpinistbg

Member

Registered: 2014-11-12

Posts: 124

Incorrect handling of sub-select

Hi Arnaud,

I have recently found that the where clause in form CreateAndFillPrepare(Rest, 'Col1=? AND Col2 IN (SELECT Col3 FROM OtherTable WHERE Col4=?)', [Val1, Val2]) does not work. I think the internal parser doesn't handle that particular case, just 'X IN (V1,V2,...)' case.

Regards,

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: Incorrect handling of sub-select

With an external db, I guess?

But the virtual tables should handle such queries.

The best in such case is to use a direct SQL on the external db, or put the sub query in memory cache.