resolving conflicts

1 files changed, 16 insertions, 19 deletions

diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result
index 80aa6046e8d..9ed54f7c253 100644
--- a/mysql-test/r/select.result
+++ b/mysql-test/r/select.result
@@ -1,4 +1,3 @@
-use test;
 drop table if exists t1,t2,t3,t4;
 CREATE TABLE t1 (
 Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,
@@ -2493,7 +2492,6 @@ fld1	fld3	period	price	price2
 018601	vacuuming	1001	5987435	234724
 018801	inch	1001	5987435	234724
 018811	repetitions	1001	5987435	234724
-drop table if exists company;
 create table t4 (
 companynr tinyint(2) unsigned zerofill NOT NULL default '00',
 companyname char(30) NOT NULL default '',
@@ -3219,23 +3217,23 @@ Tables_in_test (s%)
 show tables from test like "t?";
 Tables_in_test (t?)
 show full columns from t2;
-Field	Type	Null	Key	Default	Extra	Privileges	Comment
-auto	int(11)		PRI	NULL	auto_increment	select,insert,update,references	
-fld1	int(6) unsigned zerofill		UNI	000000		select,insert,update,references	
-companynr	tinyint(2) unsigned zerofill			00		select,insert,update,references	
-fld3	char(30) character set latin1		MUL			select,insert,update,references	
-fld4	char(35) character set latin1					select,insert,update,references	
-fld5	char(35) character set latin1					select,insert,update,references	
-fld6	char(4) character set latin1					select,insert,update,references	
+Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
+auto	int(11)	binary		PRI	NULL	auto_increment	select,insert,update,references	
+fld1	int(6) unsigned zerofill	binary		UNI	000000		select,insert,update,references	
+companynr	tinyint(2) unsigned zerofill	binary			00		select,insert,update,references	
+fld3	char(30)	latin1		MUL			select,insert,update,references	
+fld4	char(35)	latin1					select,insert,update,references	
+fld5	char(35)	latin1					select,insert,update,references	
+fld6	char(4)	latin1					select,insert,update,references	
 show full columns from t2 from test like 'f%';
-Field	Type	Null	Key	Default	Extra	Privileges	Comment
-fld1	int(6) unsigned zerofill		UNI	000000		select,insert,update,references	
-fld3	char(30) character set latin1		MUL			select,insert,update,references	
-fld4	char(35) character set latin1					select,insert,update,references	
-fld5	char(35) character set latin1					select,insert,update,references	
-fld6	char(4) character set latin1					select,insert,update,references	
+Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
+fld1	int(6) unsigned zerofill	binary		UNI	000000		select,insert,update,references	
+fld3	char(30)	latin1		MUL			select,insert,update,references	
+fld4	char(35)	latin1					select,insert,update,references	
+fld5	char(35)	latin1					select,insert,update,references	
+fld6	char(4)	latin1					select,insert,update,references	
 show full columns from t2 from test like 's%';
-Field	Type	Null	Key	Default	Extra	Privileges	Comment
+Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
 show keys from t2;
 Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
 t2	0	PRIMARY	1	auto	A	1199	NULL	NULL		BTREE	
@@ -3478,7 +3476,6 @@ a	a	a
 2	2	2
 3	3	3
 drop table t1;
-drop table if exists t1,t2;
 CREATE TABLE t1 (  aa char(2),  id int(11) NOT NULL auto_increment,  t2_id int(11) NOT NULL default '0',  PRIMARY KEY  (id),  KEY replace_id (t2_id)) TYPE=MyISAM;
 INSERT INTO t1 VALUES ("1",8264,2506),("2",8299,2517),("3",8301,2518),("4",8302,2519),("5",8303,2520),("6",8304,2521),("7",8305,2522);
 CREATE TABLE t2 ( id int(11) NOT NULL auto_increment,  PRIMARY KEY  (id)) TYPE=MyISAM;
@@ -3490,4 +3487,4 @@ aa	id	t2_id	id
 4	8302	2519	2519
 5	8303	2520	2520
 6	8304	2521	2521
-drop table if exists t1,t2;
+drop table t1,t2;