Bug #17246 NDB fails to suppot /*!40100 character set latin2 */
Submitted: 8 Feb 2006 23:32 Modified: 19 May 2006 23:38
Reporter: Jonathan Miller
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.0 -> OS:Linux (Linux 32 Bit OS)
Assigned to: Pekka Nousiainen Target Version:

[8 Feb 2006 23: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 23: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 11: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 10: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 13: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 18: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 12: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 13: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 23:38] Jonathan Miller 
Testing passess on both ndb-autotest and max compiles.