Bug #6814 Views: Crashes if view exists with complex selection
Submitted: 24 Nov 2004 21:46 Modified: 2 Mar 2005 21:26
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[24 Nov 2004 21:46] Peter Gulutzan 
Description:
If a database contains a view definition with certain GROUP BY and HAVING clauses, 
attempts to USE the database will crash the server. 
Since database corruption is possible, I suggest starting the test with a new database. 
 

How to repeat:
<< start mysql client >> 
 
create database db80; 
use db80; 
create function f () returns int return 5; 
create table t (s1 int); 
create table t1 (s1 char,s2 char); 
create view vl as select s2,sum(s1) - count(s2) as vx from t1 group by s2 having sum(s1) - 
count(s2) < (select f() from t); 
quit; 
 
<< start mysql client again >> 
use db80; 
/* The return is "Database changed" but in fact the server has crashed by now. */
[30 Nov 2004 23:04] Peter Gulutzan 
I can cause the same results with a view that contains no grouping, but calls a function.
[13 Feb 2005 19:48] Oleksandr Byelkin 
ChangeSet
  1.1822 05/02/13 21:47:00 bell@sanja.is.com.ua +2 -0
  fixed SP processing for mysql_list_fields() command (BUG#6814)
[24 Feb 2005 2:17] Oleksandr Byelkin 
Thank you for bugreport!
Bugfix is pushed into 5.0.3 source repository.
[2 Mar 2005 21:26] Paul DuBois 
Noted in 5.0.3 changelog.