Bug #4614 Views: Join of view and base table causes crash
Submitted: 19 Jul 2004 2:33 Modified: 20 Jul 2004 23:24
Reporter: Trudy Pelzer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[19 Jul 2004 2:33] Trudy Pelzer
Description:
If one creates a simple table and a simple view based on a string constant, then attempts to do a simple (concatenated) join, the MySQL server crashes:
ERROR 2013 (HY000): Lost connection to MySQL server during query

How to repeat:
create table t (t_column int);
create view v as select 'a';
select * from v, t;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[19 Jul 2004 19:15] Aleksey Kishkin
verified on slackware 9
[20 Jul 2004 9:39] Oleksandr Byelkin
ChangeSet 
  1.1712 04/07/20 10:34:39 bell@sanja.is.com.ua +3 -0 
  fix case what VIEW have not tables (BUG#4614)
[20 Jul 2004 23:24] Oleksandr Byelkin
Thank you for bugreport. bug is fixed, patch is pushed to our source repository.