| Bug #17423 | Partitioning not working on Windows | ||
|---|---|---|---|
| Submitted: | 15 Feb 2006 12:08 | Modified: | 15 Feb 2006 12:33 |
| Reporter: | Krzysztof Klimczak | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.6-alpha | OS: | Windows (Windows NT, XP) |
| Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[15 Feb 2006 12:33]
MySQL Verification Team
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 bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Additional info:
c:\mysql\bin>mysqladmin -uroot create db17
c:\mysql\bin>mysql -uroot db17
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.7-beta-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE)
-> ENGINE=INNODB
-> PARTITION BY HASH( MONTH(tr_date) )
-> PARTITIONS 6;
Query OK, 0 rows affected (0.63 sec)
mysql> show create table ti\G
*************************** 1. row ***************************
Table: ti
Create Table: CREATE TABLE `ti` (
`id` int(11) default NULL,
`amount` decimal(7,2) default NULL,
`tr_date` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY HASH ( MONTH(tr_date)) PARTITIONS 6
1 row in set (0.17 sec)
mysql>
Description: Commands with partitioning functionality are not executing by MySQL motor. Example from doc: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.1.6-alpha-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE) -> ENGINE=INNODB -> PARTITION BY HASH( MONTH(tr_date) ) -> PARTITIONS 6; ... waiting, waiting, .... waiting ERROR 2013 (HY000): Lost connection to MySQL server during query after kill mysql's pid process. final: table ti is nor crated How to repeat: Every time with mysqld.exe or mysqld-debug.exe or mysqld-nt.exe for version 5.1.6-alpha. Repeatable with every type of partitioning (HASH, RANGE, LIST, KEY). Tested on Windows NT and Windows XP on different machines. Regards Kriss