diff options
author | Vasil Dimov <vasil.dimov@oracle.com> | 2010-04-16 19:19:07 +0300 |
---|---|---|
committer | Vasil Dimov <vasil.dimov@oracle.com> | 2010-04-16 19:19:07 +0300 |
commit | eaadb377af7cf6145e324acd008d8f2d3cc00aaf (patch) | |
tree | 71463e53ee744af5c89101393ffdba2fdd955ff5 /mysql-test/suite/innodb/t/innodb_bug34300.test | |
parent | 23dd437b8089c6f7e7b021c48bb8becdbe06c35b (diff) | |
download | mariadb-git-eaadb377af7cf6145e324acd008d8f2d3cc00aaf.tar.gz |
Move InnoDB mysql-tests to the innodb suite.
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb_bug34300.test')
-rw-r--r-- | mysql-test/suite/innodb/t/innodb_bug34300.test | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_bug34300.test b/mysql-test/suite/innodb/t/innodb_bug34300.test new file mode 100644 index 00000000000..68c385fd72a --- /dev/null +++ b/mysql-test/suite/innodb/t/innodb_bug34300.test @@ -0,0 +1,34 @@ +# +# Bug#34300 Tinyblob & tinytext fields currupted after export/import and alter in 5.1 +# http://bugs.mysql.com/34300 +# + +-- source include/have_innodb.inc + +-- disable_query_log +-- disable_result_log + +# set packet size and reconnect +let $max_packet=`select @@global.max_allowed_packet`; +SET @@global.max_allowed_packet=16777216; +--connect (newconn, localhost, root,,) + +DROP TABLE IF EXISTS bug34300; +CREATE TABLE bug34300 ( + f4 TINYTEXT, + f6 MEDIUMTEXT, + f8 TINYBLOB +) ENGINE=InnoDB; + +INSERT INTO bug34300 VALUES ('xxx', repeat('a', 8459264), 'zzz'); + +-- enable_result_log + +SELECT f4, f8 FROM bug34300; + +ALTER TABLE bug34300 ADD COLUMN (f10 INT); + +SELECT f4, f8 FROM bug34300; + +DROP TABLE bug34300; +EVAL SET @@global.max_allowed_packet=$max_packet; |