Bug #31133 Disk based statements not accepting magnitude suffixes

• Submitted: 21 Sep 2007 15:25
• Modified: 15 Oct 2007 9:56
• Reporter: Geert Vanderkelen
• Status: Can't repeat
• Category: MySQL Cluster: Disk Data
• Severity: S3 (Non-critical)
• Version: 5.1bk
• OS: Any
• 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