751
751
SELECT * FROM t1;
756
# Bug#31291 ALTER TABLE CONVERT TO CHARACTER SET does not change some data types
758
create table t1 (a tinytext character set latin1);
759
alter table t1 convert to character set utf8;
760
show create table t1;
762
create table t1 (a mediumtext character set latin1);
763
alter table t1 convert to character set utf8;
764
show create table t1;
754
767
--echo End of 5.0 tests
964
# Bug#39372 "Smart" ALTER TABLE not so smart after all.
966
create table t1(f1 int not null, f2 int not null, key (f1), key (f2));
971
EVAL insert into t1 values (1,1),(1,1),(1,1),(1,1),(1,1);
972
EVAL insert into t1 values (2,2),(2,2),(2,2),(2,2),(2,2);
977
select index_length into @unpaked_keys_size from
978
information_schema.tables where table_name='t1';
979
alter table t1 pack_keys=1;
980
select index_length into @paked_keys_size from
981
information_schema.tables where table_name='t1';
982
select (@unpaked_keys_size > @paked_keys_size);
984
select max_data_length into @orig_max_data_length from
985
information_schema.tables where table_name='t1';
986
alter table t1 max_rows=100;
987
select max_data_length into @changed_max_data_length from
988
information_schema.tables where table_name='t1';
989
select (@orig_max_data_length > @changed_max_data_length);
952
994
# Bug #23113: Different behavior on altering ENUM fields between 5.0 and 5.1