Subject Filter parsing bug in 4.3Aa
Author Andreas Pohl
There is a small but easy to reproduce bug while searching with inline
selects:

IB_Query.SQL.Text:

select
(select name from table1 t1 where t1.nr=t2.nr2) as name1,
(select name from table1 t1 where t1.nr=t2.nr2) as name2,
t2.*
from table2 t2

IB_Query.Search;

Search condition for *first* inline select statement in where clause is
always missing opening bracket:

select
(select name from table1 t1 where t1.nr=t2.nr2) as name1,
(select name from table1 t1 where t1.nr=t2.nr2) as name2,
t2.*
from table2 t2
WHERE select name from table1 t1 where t1.nr=t2.nr2) = '12'
AND (select name from table1 t1 where t1.nr=t2.nr2) = '1'

Searching for next inline selects will work without any problems.

--
Andreas