Bug #13154 Inserting data into MyISAM table with PARTITION BY KEY causes mysqld core

• Submitted: 13 Sep 2005 20:41
• Modified: 14 Sep 2005 16:27
• Reporter: Jonathan Miller
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.1
• OS: Linux (Linux)
• Assigned to: Mikael Ronström
• CPU Architecture: Any

[13 Sep 2005 20:41] Jonathan Miller

Description:
ndbdev@ndb08:~/jmiller/builds> ./bin/resolve_stack_dump -s /tmp/mysqld.sym -n ./libexec/core.txt
0x818699b handle_segfault + 515
0x574420 (?)
0xa4ac424 _end + 32814828
0x81ed4a1 _Z12write_recordP3THDP8st_tableP12st_copy_info + 45
0x81f14a7 _Z12mysql_insertP3THDP13st_table_listR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb + 2519
0x81a0560 _Z21mysql_execute_commandP3THD + 22852
0x81a35fb _Z11mysql_parseP3THDPcj + 559
0x81a3c39 _Z16dispatch_command19enum_server_commandP3THDPcj + 1337
0x81a56fc handle_one_connection + 2036
0xa25b80 (?)
0x97d9ce (?)

How to repeat:
See private comments

[14 Sep 2005 16:14] Mikael Ronström

Used AND (&) when MOD (%) should have been used for
calculating partition identity for PARTITION BY KEY and also for
SUBPARTITION BY KEY