diff options
| author | Tatiana A. Nurnberg <azundris@mysql.com> | 2009-10-09 23:57:43 +0200 |
|---|---|---|
| committer | Tatiana A. Nurnberg <azundris@mysql.com> | 2009-10-09 23:57:43 +0200 |
| commit | 2fc28dd6889bd7d926031c1b054dc6438c76b668 (patch) | |
| tree | e0cf457f4f571c165631ed104b1234d2fcdd602c /mysql-test/t/alter_table.test | |
| parent | 6e4039ce673b82a9335350bc80539473ea0d4a55 (diff) | |
| parent | 798ce98340ded50323522aa436c4102e86a829a9 (diff) | |
| download | mariadb-git-2fc28dd6889bd7d926031c1b054dc6438c76b668.tar.gz | |
manual merge of Bug#43508
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 17549745203..5534aa0a234 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -1046,4 +1046,19 @@ ALTER TABLE t1 MODIFY COLUMN a SET('a1','a2','a0','xx','a5','a6','a7','a8','a9', --disable_info DROP TABLE t1; +# +# Bug#43508: Renaming timestamp or date column triggers table copy +# + +CREATE TABLE t1 (f1 TIMESTAMP NULL DEFAULT NULL, + f2 INT(11) DEFAULT NULL) ENGINE=MYISAM DEFAULT CHARSET=utf8; + +INSERT INTO t1 VALUES (NULL, NULL), ("2009-10-09 11:46:19", 2); + +--echo this should affect no rows as there is no real change +--enable_info +ALTER TABLE t1 CHANGE COLUMN f1 f1_no_real_change TIMESTAMP NULL DEFAULT NULL; +--disable_info +DROP TABLE t1; + --echo End of 5.1 tests |