Bug #15142 | Partitions: crash if list(convert_tz) | ||
---|---|---|---|
Submitted: | 22 Nov 2005 16:54 | Modified: | 3 Apr 2006 12:04 |
Reporter: | Peter Gulutzan | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | 5.1.2-alpha-debug-log | OS: | Linux (SUSE 10.0) |
Assigned to: | Bugs System | CPU Architecture: | Any |
[22 Nov 2005 16:54]
Peter Gulutzan
[4 Dec 2005 5:37]
Peter Laursen
Take this into account too: With this example from the docs CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT, store_id INT ) PARTITION BY LIST(store_id) ( PARTITION pNorth VALUES IN (3,5,6,9,17), PARTITION pEast VALUES IN (1,2,10,11,19,20), PARTITION pWest VALUES IN (4,12,13,14,18), PARTITION pCentral VALUES IN (7,8,15,16) ); server will crash if a value '0' (zero) NULL or <no value at all> for store_id is entered with an INSERT statement like insert into `test`.`employees` ( `id`, `fname`, `lname`, `hired`, `separated`, `job_code`, `store_id` ) values ( '', 'e', 'f', '1970-01-01', '9999-12-31', '', '0' ) or insert into `test`.`employees` ( `id`, `fname`, `lname`, `hired`, `separated`, `job_code`, `store_id` ) values ( '', 'e', 'f', '1970-01-01', '9999-12-31', '', NULL ) or insert into `test`.`employees` ( `id`, `fname`, `lname`, `hired`, `separated`, `job_code` ) values ( '', 'e', 'f', '1970-01-01', '9999-12-31', '' )
[4 Dec 2005 17:16]
Peter Gulutzan
The comment from Peter Laursen looks like an example of bug#14365.
[9 Mar 2006 15:34]
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/3646
[3 Apr 2006 12:04]
Mikael Ronström
This will be fixed by not allowing convert_tz in partition function and this will be fixed by bug18198 so this bug is put in Duplicate