MySQL Bugs: #50294: ER_UNKNOWN_STORAGE_ENGINE produces diff error message in 5.X and 6.0 versions

Bug #50294	ER_UNKNOWN_STORAGE_ENGINE produces diff error message in 5.X and 6.0 versions
Submitted:	13 Jan 2010 0:13	Modified:	24 Feb 2010 20:36
Reporter:	Hema Sridharan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S3 (Non-critical)
Version:	5.6.0-beta, 5.5.99	OS:	Any
Assigned to:	Jon Olav Hauglid	CPU Architecture:	Any

Description:
The error ER_UNKNOWN_STORAGE_ENGINE gives different error message in MySQL 5.X and 6.0 versions.

In 5.x, it gives error message as ERROR 42000: Unknown table engine 'PARADOX'

In 6.0, the message appears as ERROR 42000: Unknown storage engine 'PARADOX'

This results in mismatch of some of the tests(in 5.X and 6.0) that uses this error. There should be no differences noticed in the error messages. 

How to repeat:
Here it is,

CREATE DATABASE db;
CREATE TABLE db.t1 (a int, b char(32));

# .frm file for a table using non-existent storage engine
--let $table_def=$MYSQL_TEST_DIR/std_data/bug30938.frm

# copy description of a table using non-existent storage engine
copy_file $table_def $MYSQLD_DATADIR/db/t2.frm;

# backup test database, an error will be displayed
# as storage engine of the table is not identified

--error ER_UNKNOWN_STORAGE_ENGINE
BACKUP DATABASE db TO "db.backup";

The result file in 5.X
-------------------------
CREATE DATABASE db;
CREATE TABLE db.t1 (a int, b char(32));

BACKUP DATABASE db TO "db.backup";
ERROR 42000: Unknown table engine 'PARADOX'

The result file in 6.0
-----------------------
CREATE DATABASE db;
CREATE TABLE db.t1 (a int, b char(32));

BACKUP DATABASE db TO "db.backup";
ERROR 42000: Unknown storage engine 'PARADOX'

Thank you for the report.

Verified as described. I assume problem is not related to different messages between 5.1 and 6.0 servers.

Backported from 6.0 to 5.5 (mysql-next-mr-bugfixing):
      revno: 2630.22.42
      committer: Konstantin Osipov <kostja@sun.com>
      branch nick: mysql-6.0-runtime
      timestamp: Fri 2008-10-17 14:36:55 +0400
      message:
        Update old wording (table engine -> storage engine).

Note that 5.5 documentation must be updated to reflect that
ER_UNKNOWN_STORAGE_ENGINE is "Unknown storage engine '%s'"

errmsg.txt has now been removed from 5.5 (mysql-next-mr) and 6.0,
making the backport above irrelevant.

Setting the bug to Documenting.

re: "Note that 5.5 documentation must be updated to reflect that
ER_UNKNOWN_STORAGE_ENGINE is "Unknown storage engine '%s'""

The error messages in the manual are created from the errmsg.txt and errmsg-utf8.txt files in the source trees. An incorrect message in the manual reflects and incorrect message in the source tree. Currently, the 5.5 manual is taken from mysql-trunk (which doesn't have Celosia information). When Celosia is pushed to mysql-trunk, the error message will be updated to whatever Celosia has.

No changelog entry needed.