|
Date: 2002-07-17 23:59
Sender: nobody Logged In: NO yea, there is big problem with correlated subqueries in IB (and also firebird). some cases are described in PLANalyzer help, but it is not complete and there is more situations, where IB takes subquery as correlated, even it may not. Another testcase for subqueries:
create table test(id int, val char(5)); insert into test values(1, 'red'); insert into test values(2, 'green'); insert into test values(3, 'blue'); insert into test values(2, 'green');*/ delete from test where test.ID in (select id from test GROUP BY id HAVING count(id)>1); Results for "select * from test" must be: id value -- ----- 01 red 03 blue and NOT: 01 red 02 green 03 blue |
Sender: serralta
Logged In: YES
user_id=1086939
When this will be fixed ? I think its a very important fix..