MySQL Bugs: #29368: Incorrect error, 1467, for syntax error when creating partition

Bug #29368	Incorrect error, 1467, for syntax error when creating partition
Submitted:	26 Jun 2007 18:50	Modified:	15 Nov 2007 15:26
Reporter:	Matthew Lord	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S3 (Non-critical)
Version:	5.1.19	OS:	Any
Assigned to:	Mattias Jonsson	CPU Architecture:	Any
Tags:	CREATE TABLE, partitioning

Description:
 PARTITION p2 VALU ES LESS THAN (1182452400000) causes error 1467.

How to repeat:
CREATE TABLE `foo` (
  `GUID` binary(16) NOT NULL,
  `applicationID` smallint(5) unsigned NOT NULL,
  `startTime` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`GUID`,`startTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (startTime) (PARTITION p1 VALUES LESS THAN (1182441600000) ENGINE = InnoDB, PARTITION p2 VALU
ES LESS THAN (1182452400000) ENGINE = InnoDB);

Suggested fix:
This should cause a standard syntax error as it's very confusing/misleading when
all of the partitions do have VALUES LESS THAN.

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/36035

ChangeSet@1.2595, 2007-10-22 14:54:07+02:00, mattiasj@mattiasj-laptop.(none) +4 -0
  Bug#29368: Modified error messages
  New test cases

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/37512

ChangeSet@1.2595, 2007-11-10 13:09:18+01:00, mattiasj@mattiasj-laptop.(none) +4 -0
  Bug#29368: Modified error messages
  
  Problem: there was no standard syntax error when
           creating partitions with syntax error in
           the partitioning clause.
  
  Solution: added "Syntax error: " to the error message

Pushed into 6.0.4-alpha

Pushed into 5.1.23-rc

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented feature addition in 5.1.23 and 6.0.4 changelogs.