Bug #39045 not matching errors for DATA DIRECTORY between myisam and partitioned myisam
Submitted: 26 Aug 2008 16:18 Modified: 26 Aug 2008 19:22
Reporter: Mattias Jonsson
Status: Verified
Category:Server: MyISAM Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Target Version:
Triage: Triaged: D4 (Minor)

[26 Aug 2008 16:18] Mattias Jonsson 
Description:
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 19:22] Sveta Smirnova 
Thank you for the report.

Verified as described.
[27 Aug 2008 11:20] Georgi Kodinov 
This is now merged into main. The test has been temporarily updated to accept both error
codes.
[9 Oct 2008 14: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')