Bug #922 comparison problem in subquery
Submitted: 25 Jul 2003 0:34 Modified: 1 Aug 2003 7:29
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (any)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[25 Jul 2003 0:34] Oleksandr Byelkin
server crashes because uninitialized comporator 

How to repeat:
drop table if exists t1,t2; 
create table t1 (s1 int); 
create table t2 (s1 int); 
insert into t1 values (1); 
insert into t2 values (1); 
select * from t1 where exists (select s1 from t2 having max(t2.s1)=t1.s1); 
drop table if exists t1,t2;
[29 Jul 2003 3:03] Oleksandr Byelkin
it was memory overrun 
  1.1589 03/07/29 13:00:32 bell@sanja.is.com.ua +10 -0 
  count HAVING clause elements with select list elements, because agregate 
function can be present in it (BUG#922) 
  removerd unused loop_id