Bug #6894 Views: crash if correlated subquery
Submitted: 30 Nov 2004 17:33 Modified: 2 Mar 2005 22:30
Reporter: Peter Gulutzan
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin Target Version:

[30 Nov 2004 17:33] Peter Gulutzan 
Description:
When I use a view in a correlated subquery that contains HAVING but not GROUP BY, 
the server crashes. 
 

How to repeat:
mysql> create table tq (s1 int, s2 char); 
Query OK, 0 rows affected (0.29 sec) 
 
mysql> create view vq as select s1, s2 from tq; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> select s2 from vq vq1 where 2 = (select count(*) from vq vq2 having vq1.s2 = 
vq2.s2); 
ERROR 2013 (HY000): Lost connection to MySQL server during query
[30 Nov 2004 19:16] Miguel Solorzano 
Thank you for the bug report.
[15 Feb 2005 11:15] Oleksandr Byelkin 
ChangeSet
  1.1823 05/02/15 12:13:46 bell@sanja.is.com.ua +3 -0
  Abort processing current Item is it resolved as view field (BUG#6894)
[24 Feb 2005 3:18] Oleksandr Byelkin 
Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.
[2 Mar 2005 22:30] Paul DuBois 
Noted in 5.0.3 changelog.