Bug #17875 Crash with bdb + gis when table has "PRIMARY KEY AUTO_INCREMENT"

• Submitted: 2 Mar 2006 20:13
• Modified: 3 Mar 2006 11:30
• Reporter: Magnus Blåudd
• Status: Closed
• Category: MySQL Server: BDB
• Severity: S2 (Serious)
• Version: 5.1.8
• OS: Linux (FC4)
• Assigned to: Magnus Blåudd
• CPU Architecture: Any

[2 Mar 2006 20:13] Magnus Blåudd

Description:
A bdb table with primary key type "PRIMARY KEY AUTO_INCREMENT" and gis datatypes wil crash on "SHOW CREATE TABLE"

mysqltest: At line 3: query 'SHOW CREATE TABLE gis_point' failed: 2013: Lost connection to MySQL server during query

How to repeat:
CREATE TABLE gis_point  (fid INTEGER PRIMARY KEY AUTO_INCREMENT, g POINT) engine=bdb;

SHOW CREATE TABLE gis_point;

Server crashes inside ha_berkeley::open()

[2 Mar 2006 21:10] Magnus Blåudd

Recompiled with -O0 and couldn't reproduce anymore.

[3 Mar 2006 11:30] Magnus Blåudd

Must have been a bad recompile after pull