Bug #39045 not matching errors for DATA DIRECTORY between myisam and partitioned myisam
Submitted: 26 Aug 2008 14:18 Modified: 26 Aug 2008 17:22
Reporter: Mattias Jonsson Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[26 Aug 2008 14:18] Mattias Jonsson
The push for bug#32167 updated the error for a partitioned table's DATA/INDEX DIRECTORY.

But now it is not in sync with a non partitioned table (or if using embedded with partitioning).

How to repeat:
create table t1 (a int) engine myisam data directory 'data-dir';
ERROR 42000: Incorrect table name 'data-dir'
create table t1 (a int) engine myisam
partition by hash (a)
( partition p0,
partition p1 data directory 'data-dir');
ERROR HY000: Incorrect arguments to DATA DIRECTORY

Suggested fix:
let the non partitioned (and embedded) failures return the same error (ER_WRONG_ARGUMENT) and same text.
[26 Aug 2008 17:22] Sveta Smirnova
Thank you for the report.

Verified as described.
[27 Aug 2008 9:20] Georgi Kodinov
This is now merged into main. The test has been temporarily updated to accept both error codes.
[9 Oct 2008 12:25] Mattias Jonsson
The problem is in MyISAM, the fix that made it inconsistent was in Partitioning, so it should be updated in MyISAM as well.

(Changing category from 'Partitioning' to 'MyISAM')