[Bug 1406813] [NEW] Piping ALTER TABLE commands throuh mysql client corrupts INNODB tables

[Larry Irwin]

Public bug reported:

Enter mysql command line client and execute the following:

Drop Database test;
Create Database test;
USE test;
CREATE TABLE mrpatfl (
 id int(10) unsigned NOT NULL auto_increment,
 account int(10) unsigned default NULL,
 PRIMARY KEY (id),
 UNIQUE KEY dir1 (account)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO mrpatfl VALUES (NULL,1);
CREATE TABLE emtruns (
 id int(10) unsigned NOT NULL auto_increment,
 run_id varchar(32) NOT NULL,
 account int(10) unsigned NOT NULL,
 runstat varchar(3) default NULL,
 invoice varchar(20) default NULL,
 ts timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 PRIMARY KEY (id),
 UNIQUE KEY dir1 (run_id,account),
 KEY run_id (run_id),
 KEY ts (ts),
 KEY account (account),
 CONSTRAINT emtruns_ibfk_1 FOREIGN KEY (account) REFERENCES mrpatfl (account)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO emtruns VALUES (NULL,'RUN54321',1,NULL,NULL,NULL);
quit;

Now create a bash script:

MYSQL="mysql -u root -p[password] -BN"
CMD="ALTER TABLE emtruns ADD COLUMN impdate date AFTER invoice"
echo "USE test; ${CMD};" | ${MYSQL}

And run it...

ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: mysql-server-5.5 5.5.40-0ubuntu0.14.04.1
ProcVersionSignature: Ubuntu 3.13.0-34.60-generic 3.13.11.4
Uname: Linux 3.13.0-34-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.6
Architecture: amd64
Date: Wed Dec 31 15:53:57 2014
InstallationDate: Installed on 2014-08-18 (135 days ago)
InstallationMedia: Ubuntu-Server 14.04.1 LTS "Trusty Tahr" - Release amd64 (20140722.3)
Logs.var.log.daemon.log:
 
Logs.var.log.mysql.error.log: 
MySQLConf.etc.mysql.conf.d..keepme: 
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 # syslog
MySQLVarLibDirListing: False
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 XDG_RUNTIME_DIR=<set>
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.mysql.conf.d.mysqld.safe.syslog.cnf: [modified]
mtime.conffile..etc.mysql.conf.d.mysqld.safe.syslog.cnf: 2014-08-18T17:14:53.949242

** Affects: mysql-5.5 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug trusty

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.5 in Ubuntu.
https://bugs.launchpad.net/bugs/1406813

Title:
  Piping ALTER TABLE commands throuh mysql  client corrupts INNODB
  tables

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1406813/+subscriptions