drizzledump handles multi-part indexes incorrectly

Bug #732849 reported by Andrew Hutchings
6
This bug affects 1 person
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
*************************** 1. row ***************************
       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_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
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='utf8_general_ci';

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- Dump completed on 2011-Mar-10 20:47:15

Related branches

Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.