Subject | Filter parsing bug in 4.3Aa |
---|---|
Author | Andreas Pohl |
Post date | 2005-02-04T08:30:59Z |
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
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