Bug #243 MySQL crashes if you convert a table with a point-column to InnoDB

• Submitted: 7 Apr 2003 19:12
• Modified: 8 Apr 2003 10:34
• Reporter: Arjen Lentz
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.0
• OS: Any (any)
• CPU Architecture: Any

[7 Apr 2003 19:12] Arjen Lentz

Description:
MySQL crashes if you convert a table with a point-column to InnoDB.

How to repeat:

Suggested fix:
Check for existance of spatial columns in the table, and report an error instead of trying to do the table type conversion.

[8 Apr 2003 10:34] MySQL Verification Team

Thanks for the report.
Fix will come in 4.1.1.

This is an excerpt from the patch:
===== sql/sql_table.cc 1.157 vs edited =====
*** /tmp/sql_table.cc-1.157-24733       Mon Mar 17 15:06:04 2003
--- edited/sql/sql_table.cc     Tue Apr  8 20:27:28 2003
***************
*** 486,491 ****
--- 486,497 ----
        blob_columns++;
        break;
      case FIELD_TYPE_GEOMETRY:
+       if (!(file->table_flags() & HA_HAS_GEOMETRY))
+       {
+       my_printf_error(ER_WRONG_USAGE,ER(ER_WRONG_USAGE),MYF(0),
+                       "GEOMETRY FIELD TYPE","not supported by this storage engine  ");
+       DBUG_RETURN(-1);
+       }
        sql_field->pack_flag=FIELDFLAG_GEOM |
        pack_length_to_packflag(sql_field->pack_length -
                                portable_sizeof_char_ptr);