Bug #30583 Partition on DOUBLE key + INNODB + count(*) == crash
Submitted: 23 Aug 2007 1:33 Modified: 22 Oct 2007 18:20
Reporter: Timothy Smith Email Updates:
Status: Closed
Category:Server: Partition Severity:S1 (Critical)
Version:5.1.22 OS:Any
Assigned to: Sergey Vojtovich Target Version:

[23 Aug 2007 1:33] Timothy Smith 
Description:
Found while running partition_float_innodb.test.  I'll attach the backtrace as a file.

The crash doesn't happen with MyISAM.  It requires at least two rows in the table.

How to repeat:
# Doesn't show up with MyISAM
--source include/have_innodb.inc
--disable_warnings
drop table if exists t2;
--enable_warnings

create table t2 (a double not null, primary key(a)) engine='InnoDB'
partition by key (a) partitions 10;
# Must be at least two rows to trigger the crash
eval insert into t2 values (1);
eval insert into t2 values (2);

select count(*) from t2;

drop table t2;
[23 Aug 2007 1:34] Timothy Smith 
bt full

Attachment: gdb.txt (text/plain), 7.71 KiB.
[6 Sep 2007 13:07] 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/33812

ChangeSet@1.2569, 2007-09-06 17:05:07+05:00, svoj@mysql.com +3 -0
  BUG#30583 - Partition on DOUBLE key + INNODB + count(*) == crash
  
  Issuing SELECT COUNT(*) against partitioned InnoDB table may cause
  server crash.
  
  Fixed that not all required fields were included into read_set.
[13 Sep 2007 14: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/34190

ChangeSet@1.2569, 2007-09-13 18:33:40+05:00, svoj@mysql.com +3 -0
  BUG#30583 - Partition on DOUBLE key + INNODB + count(*) == crash
  
  Issuing SELECT COUNT(*) against partitioned InnoDB table may cause
  server crash.
  
  Fixed that not all required fields were included into read_set.
[22 Oct 2007 17:03] Bugs System 
Pushed into 5.1.23-beta
[22 Oct 2007 18:20] Jon Stephens 
Documented bugfix in 5.1.23 changelog.