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.

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

Page generated in 0.050 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.