Bug #31133 Disk based statements not accepting magnitude suffixes
Submitted: 21 Sep 2007 15:25 Modified: 15 Oct 2007 9:56
Reporter: Geert Vanderkelen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:5.1bk OS:Any
Assigned to: CPU Architecture:Any

[21 Sep 2007 15:25] Geert Vanderkelen
Description:
The statements CREATE LOGFILE GROUP and CREATE TABLESPACE are supposed to accept the magnitude suffixes, but currently they are failing. (see how to repeat)
Works OK if you give it in bytes.

Found this working in 5.1.21, couldn't test using 5.1.22 yet.

How to repeat:
mysql> CREATE TABLESPACE ts_1 ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 32M ENGINE NDB;
ERROR 1064 (42000) at line 4: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '32M ENGINE NDB' at line 1
[21 Sep 2007 15:25] Geert Vanderkelen
Verified using 5.1bk (5.1.23).
[15 Oct 2007 9:56] Geert Vanderkelen
I somehow can't repeat this anymore with 5.1.22-rc or any CGE