drizzledump handles multi-part indexes incorrectly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Critical
|
Andrew Hutchings | ||
7.0 |
Fix Released
|
Critical
|
Andrew Hutchings |
Bug Description
drizzle> create table t1 (a text, b int, key ab (a(15),b));
drizzle> show create table t1\G
*******
Table: t1
Create Table: CREATE TABLE `t1` (
`a` TEXT COLLATE utf8_general_ci,
`b` INT DEFAULT NULL,
KEY `ab` (`a`(15),`b`)
) ENGINE=InnoDB COLLATE = utf8_general_ci
1 row in set (0.000512 sec)
$ bin/drizzledump test
-- drizzledump 2011.03.11.2227 libdrizzle 7, for unknown-linux-gnu (x86_64)
--
-- Host: localhost Database: test
-- -------
-- Server version 2011.03.11.2227 (Drizzle server)
SET @OLD_UNIQUE_
SET @OLD_FOREIGN_
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
`a` TEXT COLLATE utf8_general_ci DEFAULT NULL,
`b` INT DEFAULT NULL,
KEY `ab` (`a`(15),`b`(15))
) ENGINE='InnoDB' COLLATE=
SET FOREIGN_
SET UNIQUE_
-- Dump completed on 2011-Mar-10 20:47:15
Related branches
- Drizzle Developers: Pending requested
-
Diff: 110 lines (+34/-12)6 files modifiedclient/drizzledump_data.cc (+5/-6)
client/drizzledump_data.h (+3/-2)
client/drizzledump_drizzle.cc (+2/-2)
client/drizzledump_mysql.cc (+2/-2)
tests/suite/regression/r/732849.result (+14/-0)
tests/suite/regression/t/732849.test (+8/-0)
Changed in drizzle: | |
assignee: | nobody → Andrew Hutchings (linuxjedi) |