** Description changed:
- 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...
+ Will re-submit with info on how to duplicate...
+ (did not mean to submit until I had it all in the report, but I did,
somehow...)
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:
+
+ Logs.var.log.mysql.error.log:
+ MySQLConf.etc.mysql.conf.d..keepme:
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
- [mysqld_safe]
- # syslog
+ [mysqld_safe]
+ # syslog
MySQLVarLibDirListing: False
ProcEnviron:
- TERM=xterm
- PATH=(custom, no user)
- XDG_RUNTIME_DIR=<set>
- LANG=en_US.UTF-8
- SHELL=/bin/bash
+ 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
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to 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-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
