Bug #39045 not matching errors for DATA DIRECTORY between myisam and partitioned myisam

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.

Thank you for the report.

Verified as described.

This is now merged into main. The test has been temporarily updated to accept both error codes.

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')