Bug #10213 mysqldump crashes when dumping VIEWs
Submitted: 27 Apr 2005 18:35 Modified: 14 Jun 2005 10:11
Reporter: John David Duncan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.4/BK source OS:MacOS (Mac OS X,)
Assigned to: Magnus Blåudd CPU Architecture:Any

[27 Apr 2005 18:35] John David Duncan 
Description:
There are some problems using mysqldump to dump databases that contain views.  It looks like the problem with the current 5.0.4 is that mysqldump dies with a Bus Error (on Mac OS X.  On other systems this would probably be a segfault).

How to repeat:
Create database bb;
use bb;

CREATE TABLE `w` (
  `a` varchar(30) default NULL,
  KEY `a` (`a`(5))
);

INSERT INTO `w` VALUES ('alfred');
INSERT INTO `w` VALUES ('angie');
INSERT INTO `w` VALUES ('bingo');
INSERT INTO `w` VALUES ('waffle');
INSERT INTO `w` VALUES ('lemon');

create view wv as select * from w where a like 'a%' with check option;

--------
mysqldump bb
[27 Apr 2005 19:46] MySQL Verification Team 
I was unable for to repeat the behavior reported with server from current
BK source and running on Slackware 10.0.
[27 Apr 2005 20:44] John David Duncan 
I was also using source code that I pulled from bitkeeper today.  Can you maybe relabel the bug as specific to Mac OS X and reopen it?
[10 Jun 2005 9:19] Magnus Blåudd 
I will add test cases for this to mysql-test.
[10 Jun 2005 13:14] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/25859
[14 Jun 2005 10:10] Magnus Blåudd 
Added testcases for mysql-test to 5.0.8
[14 Jun 2005 10:11] Magnus Blåudd 
Tested on powermacg5 with the newly added testcase. Sucessful. The testcase will howevere be run on all of our test machines before the next release.