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:
None 
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 
Description:
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 
 
ChangeSet 
  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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.