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
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
