Bug #17246 NDB fails to suppot /*!40100 character set latin2 */
Submitted: 8 Feb 2006 22:32 Modified: 19 May 2006 21:38
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.0 -> OS:Linux (Linux 32 Bit OS)
Assigned to: Pekka Nousiainen CPU Architecture:Any

[8 Feb 2006 22:32] Jonathan Miller 
Description:
Was not able to find anything in know limilitations.

Errors are (from /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 12: query 'create table t1 (w int, a varchar(4), b varchar(4))' failed: 1005: Can't create table 'mysqltest1.t1' (errno: 140)
(the last lines may be the most important ones)

Errors are (from /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 12: query 'create table t1 (a varchar(255) character set latin2, b varchar(4))' failed: 1005: Can't create table 'mysqltest1.t1' (errno: 140)
(the last lines may be the most important ones)

How to repeat:
drop database if exists mysqltest1;
create database mysqltest1 /*!40100 character set latin2 */;
use mysqltest1;
drop table if exists t1;
create table t1 (a varchar(255) character set latin2, b varchar(4));
[8 Feb 2006 22:39] Jonathan Miller 
Seems to be the varchar that is having the issue, I have another test case and it you remove the varchar the table is created.
[10 Feb 2006 10:24] Tomas Ulin 
master> create table t4 (a varchar(255) character set latin2, b varchar(4)) engine=ndb;
ERROR 1005 (HY000): Can't create table 'test.t4' (errno: 140)
master> show warnings;
+-------+------+----------------------------------------------------------------------+
| Level | Code | Message                                                              |
+-------+------+----------------------------------------------------------------------+
| Error | 1296 | Got error 743 'Unsupported character set in table or index' from NDB |
| Error | 1005 | Can't create table 'test.t4' (errno: 140)                            |
+-------+------+----------------------------------------------------------------------+
2 rows in set (0.00 sec)
[6 Mar 2006 9:59] 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/commits/3484
[6 Mar 2006 12:53] 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/commits/3500
[6 Mar 2006 17:13] Jonathan Miller 
In talking with Pekka, something seems to be missing from the build scripts that causes this. Pekka will talk to Bar about it.
[19 May 2006 10:11] Jonas Oreland 
ok.
there is no bug here in NDB.
there might be a bug in a BUILD/* script (not including all charsets)
But there scripts have to my knowledge no requirement spec, no owner, no nothing really...

Jeb, If this still blocks you in anyway,
please reopen specifying exactly how you build. and how you reproduce it.
[19 May 2006 11:46] Jonathan Miller 
It works with a build done from ndb-autotest. I will need to check comp-pent-max as that is the only other way that I build. Will do that later today.
[19 May 2006 21:38] Jonathan Miller 
Testing passess on both ndb-autotest and max compiles.