diff options
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r-- | mysql-test/r/alter_table.result | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index dbdbb7f57a9..d2975c33a47 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -1,3 +1,20 @@ +drop table if exists t1; +create table t1 ( +col1 int not null auto_increment primary key, +col2 varchar(30) not null, +col3 varchar (20) not null, +col4 varchar(4) not null, +col5 enum('PENDING', 'ACTIVE', 'DISABLED') not null, +col6 int not null, to_be_deleted int); +alter table t1 +add column col4_5 varchar(20) not null after col4, +add column col7 varchar(30) not null after col6, +add column col8 datetime not null, drop column to_be_deleted; +drop table t1; +create table t1 (bandID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, payoutID SMALLINT UNSIGNED NOT NULL); +insert into t1 (bandID,payoutID) VALUES (1,6),(2,6),(3,4),(4,9),(5,10),(6,1),(7,12),(8,12); +alter table t1 add column new_col int, order by payoutid,bandid; +select * from t1; bandID payoutID new_col 6 1 NULL 3 4 NULL @@ -7,6 +24,8 @@ bandID payoutID new_col 5 10 NULL 7 12 NULL 8 12 NULL +alter table t1 order by bandid,payoutid; +select * from t1; bandID payoutID new_col 1 6 NULL 2 6 NULL @@ -16,19 +35,76 @@ bandID payoutID new_col 6 1 NULL 7 12 NULL 8 12 NULL +drop table t1; +CREATE TABLE t1 ( +GROUP_ID int(10) unsigned DEFAULT '0' NOT NULL, +LANG_ID smallint(5) unsigned DEFAULT '0' NOT NULL, +NAME varchar(80) DEFAULT '' NOT NULL, +PRIMARY KEY (GROUP_ID,LANG_ID), +KEY NAME (NAME)); +ALTER TABLE t1 CHANGE NAME NAME CHAR(80) not null; +SHOW FULL COLUMNS FROM t1; Field Type Null Key Default Extra Privileges GROUP_ID int(10) unsigned PRI 0 select,insert,update,references LANG_ID smallint(5) unsigned PRI 0 select,insert,update,references NAME char(80) MUL select,insert,update,references +DROP TABLE t1; +create table t1 (n int); +insert into t1 values(9),(3),(12),(10); +alter table t1 order by n; +select * from t1; n 3 9 10 12 +drop table t1; +CREATE TABLE t1 ( +id int(11) unsigned NOT NULL default '0', +category_id tinyint(4) unsigned NOT NULL default '0', +type_id tinyint(4) unsigned NOT NULL default '0', +body text NOT NULL, +user_id int(11) unsigned NOT NULL default '0', +status enum('new','old') NOT NULL default 'new', +PRIMARY KEY (id) +) TYPE=MyISAM; +ALTER TABLE t1 ORDER BY t1.id, t1.status, t1.type_id, t1.user_id, t1.body; +DROP TABLE t1; +CREATE TABLE t1 (AnamneseId int(10) unsigned NOT NULL auto_increment,B BLOB,PRIMARY KEY (AnamneseId)) type=myisam; +insert into t1 values (null,"hello"); +LOCK TABLES t1 WRITE; +ALTER TABLE t1 ADD Column new_col int not null; +UNLOCK TABLES; +OPTIMIZE TABLE t1; Table Op Msg_type Msg_text test.t1 optimize status OK +DROP TABLE t1; +create table t1 (n1 int not null, n2 int, n3 int, n4 float, +unique(n1), +key (n1, n2, n3, n4), +key (n2, n3, n4, n1), +key (n3, n4, n1, n2), +key (n4, n1, n2, n3) ); +alter table t1 disable keys; + insert into t1 values(10,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(9,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(8,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(7,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(6,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(5,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(4,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(3,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(2,RAND()*1000,RAND()*1000,RAND()); + insert into t1 values(1,RAND()*1000,RAND()*1000,RAND()); +alter table t1 enable keys; +drop table t1; +create table t1 (i int unsigned not null auto_increment primary key); +insert into t1 values (null),(null),(null),(null); +alter table t1 drop i,add i int unsigned not null auto_increment, drop primary key, add primary key (i); +select * from t1; i 1 2 3 4 +drop table t1; |