Bug #10435 Need updated error message for 5.x->4.x downgrade
Submitted: 7 May 2005 15:01 Modified: 19 May 2005 0:31
Reporter: Trudy Pelzer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:
Assigned to: Jim Winstead

[7 May 2005 15:01] Trudy Pelzer
Description:
See bug#8171.

A problem exists with the "true varchar" change: 
if I create a table with a VARCHAR column in 5.0.3,
then try to read the database with a 4.1.x version
of MySQL (e.g. 4.1.10), I get an error:
ERROR 1033 (HY000): Incorrect information in file: '<table name>'

The message is too ambiguous. It should say:
Table '<table name>' was created with a different version of MySQL and cannot be read

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.3-alpha-debug

mysql> use tp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> create table t1 (col1 int, col2 varchar(7500));
Query OK, 0 rows affected (0.01 sec)

mysql> show create table t1;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------+
| Table | Create Table                                                          
                                                       |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `col1` int(11) default NULL,
  `col2` varchar(7500) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------+
1 row in set (0.00 sec)

mysql> insert into t1 values (50,'hello');
Query OK, 1 row affected (0.01 sec)

mysql> quit;

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.10-debug

mysql> use tp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 't1'
Database changed

mysql> select * from t1;
ERROR 1033 (HY000): Incorrect information in file: './tp/t1.frm'
[7 May 2005 20:55] 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/24688
[7 May 2005 20:56] Jim Winstead
Added a hardcoded error message in 4.1 -- when merging to 5.0, I will create a new (translatable) error message.
[13 May 2005 16:49] Jim Winstead
Fixed in 4.1.12 and 5.0.6.
[19 May 2005 0:31] Paul Dubois
Noted in 4.1.12, 5.0.6 changelogs.