show_check.result 33.7 KB
Newer Older
unknown's avatar
unknown committed
1
drop table if exists t1,t2;
2
drop table if exists t1aa,t2aa;
3
drop database if exists mysqltest;
4
drop database if exists mysqltest1;
unknown's avatar
unknown committed
5 6 7
delete from mysql.user where user='mysqltest_1' || user='mysqltest_2' || user='mysqltest_3';
delete from mysql.db where user='mysqltest_1' || user='mysqltest_2' || user='mysqltest_3';
flush privileges;
unknown's avatar
unknown committed
8 9
create table t1 (a int not null primary key, b int not null,c int not null, key(b,c));
insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
unknown's avatar
unknown committed
10
check table t1 fast;
11 12
Table	Op	Msg_type	Msg_text
test.t1	check	status	Table is already up to date
unknown's avatar
unknown committed
13
check table t1 fast;
14 15
Table	Op	Msg_type	Msg_text
test.t1	check	status	Table is already up to date
unknown's avatar
unknown committed
16
check table t1 changed;
17 18
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
unknown's avatar
unknown committed
19
insert into t1 values (5,5,5);
unknown's avatar
unknown committed
20
check table t1 changed;
21 22
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
unknown's avatar
unknown committed
23
check table t1 medium;
24 25
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
unknown's avatar
unknown committed
26
check table t1 extended;
27 28
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
unknown's avatar
unknown committed
29
show index from t1;
30 31 32 33
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	a	A	5	NULL	NULL		BTREE	
t1	1	b	1	b	A	1	NULL	NULL		BTREE	
t1	1	b	2	c	A	5	NULL	NULL		BTREE	
unknown's avatar
unknown committed
34
insert into t1 values (5,5,5);
35
ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
unknown's avatar
unknown committed
36
optimize table t1;
37 38
Table	Op	Msg_type	Msg_text
test.t1	optimize	status	OK
unknown's avatar
unknown committed
39
optimize table t1;
40 41
Table	Op	Msg_type	Msg_text
test.t1	optimize	status	Table is already up to date
unknown's avatar
unknown committed
42 43
drop table t1;
show variables like "wait_timeout%";
44 45
Variable_name	Value
wait_timeout	28800
unknown's avatar
unknown committed
46 47 48
show variables like "WAIT_timeout%";
Variable_name	Value
wait_timeout	28800
unknown's avatar
unknown committed
49
show variables like "this_doesn't_exists%";
50
Variable_name	Value
unknown's avatar
unknown committed
51
show table status from test like "this_doesn't_exists%";
52
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
unknown's avatar
unknown committed
53
show databases;
54
Database
55
information_schema
56 57
mysql
test
unknown's avatar
unknown committed
58
show databases like "test%";
59 60
Database (test%)
test
unknown's avatar
unknown committed
61 62 63
create table t1 (f1 int not null, f2 int not null, f3 int not null, f4 int not null, primary key(f1,f2,f3,f4));
insert into t1 values (1,1,1,0),(1,1,2,0),(1,1,3,0),(1,2,1,0),(1,2,2,0),(1,2,3,0),(1,3,1,0),(1,3,2,0),(1,3,3,0),(1,1,1,1),(1,1,2,1),(1,1,3,1),(1,2,1,1),(1,2,2,1),(1,2,3,1),(1,3,1,1),(1,3,2,1),(1,3,3,1);
analyze table t1;
64 65
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
unknown's avatar
unknown committed
66
show index from t1;
67 68 69 70 71
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	f1	A	1	NULL	NULL		BTREE	
t1	0	PRIMARY	2	f2	A	3	NULL	NULL		BTREE	
t1	0	PRIMARY	3	f3	A	9	NULL	NULL		BTREE	
t1	0	PRIMARY	4	f4	A	18	NULL	NULL		BTREE	
unknown's avatar
unknown committed
72
repair table t1;
73 74
Table	Op	Msg_type	Msg_text
test.t1	repair	status	OK
unknown's avatar
unknown committed
75
show index from t1;
76 77 78 79 80
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	f1	A	1	NULL	NULL		BTREE	
t1	0	PRIMARY	2	f2	A	3	NULL	NULL		BTREE	
t1	0	PRIMARY	3	f3	A	9	NULL	NULL		BTREE	
t1	0	PRIMARY	4	f4	A	18	NULL	NULL		BTREE	
unknown's avatar
unknown committed
81 82 83
drop table t1;
create temporary table t1 (a int not null);
show create table t1;
84 85
Table	Create Table
t1	CREATE TEMPORARY TABLE `t1` (
unknown's avatar
unknown committed
86
  `a` int(11) NOT NULL
unknown's avatar
unknown committed
87
) ENGINE=MyISAM DEFAULT CHARSET=latin1
unknown's avatar
unknown committed
88 89
alter table t1 rename t2;
show create table t2;
90 91
Table	Create Table
t2	CREATE TEMPORARY TABLE `t2` (
unknown's avatar
unknown committed
92
  `a` int(11) NOT NULL
unknown's avatar
unknown committed
93
) ENGINE=MyISAM DEFAULT CHARSET=latin1
unknown's avatar
unknown committed
94 95 96
drop table t2;
create table t1 (
test_set set( 'val1', 'val2', 'val3' ) not null default '',
unknown's avatar
unknown committed
97
name char(20) default 'O''Brien' comment 'O''Brien as default',
unknown's avatar
unknown committed
98
c int not null comment 'int column',
unknown's avatar
unknown committed
99
`c-b` int comment 'name with a minus',
unknown's avatar
unknown committed
100 101
`space 2` int comment 'name with a space'
  ) comment = 'it\'s a table' ;
unknown's avatar
unknown committed
102
show create table t1;
103 104
Table	Create Table
t1	CREATE TABLE `t1` (
105 106
  `test_set` set('val1','val2','val3') NOT NULL DEFAULT '',
  `name` char(20) DEFAULT 'O''Brien' COMMENT 'O''Brien as default',
unknown's avatar
unknown committed
107
  `c` int(11) NOT NULL COMMENT 'int column',
108 109
  `c-b` int(11) DEFAULT NULL COMMENT 'name with a minus',
  `space 2` int(11) DEFAULT NULL COMMENT 'name with a space'
unknown's avatar
unknown committed
110 111 112 113 114
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='it''s a table'
set sql_quote_show_create=0;
show create table t1;
Table	Create Table
t1	CREATE TABLE t1 (
115 116
  test_set set('val1','val2','val3') NOT NULL DEFAULT '',
  `name` char(20) DEFAULT 'O''Brien' COMMENT 'O''Brien as default',
unknown's avatar
unknown committed
117
  c int(11) NOT NULL COMMENT 'int column',
118 119
  `c-b` int(11) DEFAULT NULL COMMENT 'name with a minus',
  `space 2` int(11) DEFAULT NULL COMMENT 'name with a space'
unknown's avatar
unknown committed
120
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='it''s a table'
unknown's avatar
unknown committed
121
set sql_quote_show_create=1;
unknown's avatar
unknown committed
122
show full columns from t1;
123
Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
124
test_set	set('val1','val2','val3')	latin1_swedish_ci	NO				select,insert,update,references	
125
name	char(20)	latin1_swedish_ci	YES		O'Brien		select,insert,update,references	O'Brien as default
126
c	int(11)	NULL	NO				select,insert,update,references	int column
unknown's avatar
unknown committed
127 128
c-b	int(11)	NULL	YES		NULL		select,insert,update,references	name with a minus
space 2	int(11)	NULL	YES		NULL		select,insert,update,references	name with a space
unknown's avatar
unknown committed
129 130 131
drop table t1;
create table t1 (a int not null, unique aa (a));
show create table t1;
132 133
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
134
  `a` int(11) NOT NULL,
135
  UNIQUE KEY `aa` (`a`)
unknown's avatar
unknown committed
136
) ENGINE=MyISAM DEFAULT CHARSET=latin1
unknown's avatar
unknown committed
137 138 139
drop table t1;
create table t1 (a int not null, primary key (a));
show create table t1;
140 141
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
142
  `a` int(11) NOT NULL,
143
  PRIMARY KEY (`a`)
unknown's avatar
unknown committed
144
) ENGINE=MyISAM DEFAULT CHARSET=latin1
unknown's avatar
unknown committed
145 146 147
drop table t1;
flush tables;
show open tables;
148
Database	Table	In_use	Name_locked
149
mysql	general_log	1	0
150
mysql	slow_log	1	0
unknown's avatar
unknown committed
151 152 153
create table t1(n int);
insert into t1 values (1);
show open tables;
154
Database	Table	In_use	Name_locked
155
mysql	general_log	1	0
156 157
mysql	slow_log	1	0
test	t1	0	0
unknown's avatar
unknown committed
158
drop table t1;
unknown's avatar
unknown committed
159
create table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed;
unknown's avatar
unknown committed
160 161 162
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
163
  `a` int(11) NOT NULL,
164
  `b` varchar(10) DEFAULT NULL,
unknown's avatar
unknown committed
165
  KEY `b` (`b`)
unknown's avatar
unknown committed
166
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test'
unknown's avatar
unknown committed
167 168 169 170
alter table t1 MAX_ROWS=200 ROW_FORMAT=dynamic PACK_KEYS=0;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
171
  `a` int(11) NOT NULL,
172
  `b` varchar(10) DEFAULT NULL,
unknown's avatar
unknown committed
173
  KEY `b` (`b`)
unknown's avatar
unknown committed
174
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=10 MAX_ROWS=200 AVG_ROW_LENGTH=10 PACK_KEYS=0 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='test'
unknown's avatar
unknown committed
175 176 177 178
ALTER TABLE t1 AVG_ROW_LENGTH=0 CHECKSUM=0 COMMENT="" MIN_ROWS=0 MAX_ROWS=0 PACK_KEYS=DEFAULT DELAY_KEY_WRITE=0 ROW_FORMAT=default;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
179
  `a` int(11) NOT NULL,
180
  `b` varchar(10) DEFAULT NULL,
unknown's avatar
unknown committed
181
  KEY `b` (`b`)
unknown's avatar
unknown committed
182
) ENGINE=MyISAM DEFAULT CHARSET=latin1
unknown's avatar
unknown committed
183
drop table t1;
184 185
create table t1 (a decimal(9,2), b decimal (9,0), e double(9,2), f double(5,0), h float(3,2), i float(3,0));
show columns from t1;
186 187 188 189 190 191 192
Field	Type	Null	Key	Default	Extra
a	decimal(9,2)	YES		NULL	
b	decimal(9,0)	YES		NULL	
e	double(9,2)	YES		NULL	
f	double(5,0)	YES		NULL	
h	float(3,2)	YES		NULL	
i	float(3,0)	YES		NULL	
unknown's avatar
unknown committed
193
show full columns from t1;
194
Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
195 196 197 198 199 200
a	decimal(9,2)	NULL	YES		NULL		select,insert,update,references	
b	decimal(9,0)	NULL	YES		NULL		select,insert,update,references	
e	double(9,2)	NULL	YES		NULL		select,insert,update,references	
f	double(5,0)	NULL	YES		NULL		select,insert,update,references	
h	float(3,2)	NULL	YES		NULL		select,insert,update,references	
i	float(3,0)	NULL	YES		NULL		select,insert,update,references	
201
drop table t1;
unknown's avatar
unknown committed
202
create table t1 (
203
type_bool bool not null default 0,
unknown's avatar
unknown committed
204 205 206 207 208 209 210 211 212 213
type_tiny tinyint not null auto_increment primary key,
type_short smallint(3),
type_mediumint mediumint,
type_bigint bigint,
type_decimal decimal(5,2),
type_numeric numeric(5,2),
empty_char char(0),
type_char char(2),
type_varchar varchar(10),
type_timestamp timestamp not null,
214 215 216
type_date date not null default '0000-00-00',
type_time time not null default '00:00:00',
type_datetime datetime not null default '0000-00-00 00:00:00',
unknown's avatar
unknown committed
217 218 219 220 221 222 223 224
type_year year,
type_enum enum ('red', 'green', 'blue'),
type_set enum ('red', 'green', 'blue'),
type_tinyblob tinyblob,
type_blob blob,
type_medium_blob mediumblob,
type_long_blob longblob,
index(type_short)
unknown's avatar
unknown committed
225
) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" ENGINE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed CHARSET=latin1;
unknown's avatar
unknown committed
226 227 228
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245
  `type_bool` tinyint(1) NOT NULL DEFAULT '0',
  `type_tiny` tinyint(4) NOT NULL AUTO_INCREMENT,
  `type_short` smallint(3) DEFAULT NULL,
  `type_mediumint` mediumint(9) DEFAULT NULL,
  `type_bigint` bigint(20) DEFAULT NULL,
  `type_decimal` decimal(5,2) DEFAULT NULL,
  `type_numeric` decimal(5,2) DEFAULT NULL,
  `empty_char` char(0) DEFAULT NULL,
  `type_char` char(2) DEFAULT NULL,
  `type_varchar` varchar(10) DEFAULT NULL,
  `type_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `type_date` date NOT NULL DEFAULT '0000-00-00',
  `type_time` time NOT NULL DEFAULT '00:00:00',
  `type_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type_year` year(4) DEFAULT NULL,
  `type_enum` enum('red','green','blue') DEFAULT NULL,
  `type_set` enum('red','green','blue') DEFAULT NULL,
unknown's avatar
unknown committed
246 247 248 249
  `type_tinyblob` tinyblob,
  `type_blob` blob,
  `type_medium_blob` mediumblob,
  `type_long_blob` longblob,
250
  PRIMARY KEY (`type_tiny`),
unknown's avatar
unknown committed
251
  KEY `type_short` (`type_short`)
unknown's avatar
unknown committed
252
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=10 MAX_ROWS=100 AVG_ROW_LENGTH=10 PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=FIXED COMMENT='test'
unknown's avatar
unknown committed
253 254 255
insert into t1 (type_timestamp) values ("2003-02-07 10:00:01");
select * from t1;
type_bool	type_tiny	type_short	type_mediumint	type_bigint	type_decimal	type_numeric	empty_char	type_char	type_varchar	type_timestamp	type_date	type_time	type_datetime	type_year	type_enum	type_set	type_tinyblob	type_blob	type_medium_blob	type_long_blob
unknown's avatar
unknown committed
256
0	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2003-02-07 10:00:01	0000-00-00	00:00:00	0000-00-00 00:00:00	NULL	NULL	NULL	NULL	NULL	NULL	NULL
unknown's avatar
unknown committed
257
drop table t1;
258 259 260 261
create table t1 (a int not null);
create table t2 select max(a) from t1;
show columns from t2;
Field	Type	Null	Key	Default	Extra
262
max(a)	int(11)	YES		NULL	
263
drop table t1,t2;
264 265
create table t1 (c decimal, d double, f float, r real);
show columns from t1;
266 267 268 269 270
Field	Type	Null	Key	Default	Extra
c	decimal(10,0)	YES		NULL	
d	double	YES		NULL	
f	float	YES		NULL	
r	double	YES		NULL	
271 272 273
drop table t1;
create table t1 (c decimal(3,3), d double(3,3), f float(3,3));
show columns from t1;
274
Field	Type	Null	Key	Default	Extra
275 276 277
c	decimal(3,3)	YES		NULL	
d	double(3,3)	YES		NULL	
f	float(3,3)	YES		NULL	
278
drop table t1;
279 280
SET @old_sql_mode= @@sql_mode, sql_mode= '';
SET @old_sql_quote_show_create= @@sql_quote_show_create, sql_quote_show_create= OFF;
281 282 283 284
CREATE TABLE ```ab``cd``` (i INT);
SHOW CREATE TABLE ```ab``cd```;
Table	Create Table
`ab`cd`	CREATE TABLE ```ab``cd``` (
285
  i int(11) DEFAULT NULL
286 287 288 289 290 291
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE ```ab``cd```;
CREATE TABLE ```ab````cd``` (i INT);
SHOW CREATE TABLE ```ab````cd```;
Table	Create Table
`ab``cd`	CREATE TABLE ```ab````cd``` (
292
  i int(11) DEFAULT NULL
293 294 295 296 297 298
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE ```ab````cd```;
CREATE TABLE ```a` (i INT);
SHOW CREATE TABLE ```a`;
Table	Create Table
`a	CREATE TABLE ```a` (
299
  i int(11) DEFAULT NULL
300 301 302 303 304 305
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE ```a`;
CREATE TABLE `a.1` (i INT);
SHOW CREATE TABLE `a.1`;
Table	Create Table
a.1	CREATE TABLE `a.1` (
306
  i int(11) DEFAULT NULL
307 308 309 310 311 312 313
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE `a.1`;
SET sql_mode= 'ANSI_QUOTES';
CREATE TABLE """a" (i INT);
SHOW CREATE TABLE """a";
Table	Create Table
"a	CREATE TABLE """a" (
314
  i int(11) DEFAULT NULL
315 316
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE """a";
317 318
SET sql_mode= '';
SET sql_quote_show_create= OFF;
319 320 321 322
CREATE TABLE t1 (i INT);
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE t1 (
323
  i int(11) DEFAULT NULL
324 325 326 327 328 329
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
CREATE TABLE `table` (i INT);
SHOW CREATE TABLE `table`;
Table	Create Table
table	CREATE TABLE `table` (
330
  i int(11) DEFAULT NULL
331 332
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE `table`;
333 334
SET sql_quote_show_create= @old_sql_quote_show_create;
SET sql_mode= @old_sql_mode;
335 336
select @@max_heap_table_size;
@@max_heap_table_size
337
1048576
338 339
CREATE TABLE t1 (
a int(11) default NULL,
340
KEY a USING BTREE (a)
341 342 343 344 345 346 347 348
) ENGINE=HEAP;
CREATE TABLE t2 (
b int(11) default NULL,
index(b)
) ENGINE=HEAP;
CREATE TABLE t3 (
a int(11) default NULL,
b int(11) default NULL,
349
KEY a USING BTREE (a),
350 351 352 353 354 355
index(b)
) ENGINE=HEAP;
insert into t1 values (1),(2);
insert into t2 values (1),(2);
insert into t3 values (1,1),(2,2);
show table status;
356
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
357 358 359
t1	MEMORY	10	Fixed	2	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	2	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	2	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
360 361 362 363
insert into t1 values (3),(4);
insert into t2 values (3),(4);
insert into t3 values (3,3),(4,4);
show table status;
364
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
365 366 367
t1	MEMORY	10	Fixed	4	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	4	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	4	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
368 369 370 371
insert into t1 values (5);
insert into t2 values (5);
insert into t3 values (5,5);
show table status;
372
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
373 374 375
t1	MEMORY	10	Fixed	5	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	5	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	5	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
376 377 378 379
delete from t1 where a=3;
delete from t2 where b=3;
delete from t3 where a=3;
show table status;
380
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
381 382 383
t1	MEMORY	10	Fixed	4	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	4	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	4	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
384 385 386
truncate table t1;
truncate table t2;
truncate table t3;
387
show table status;
388
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
389 390 391
t1	MEMORY	10	Fixed	0	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	0	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	0	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
392 393 394 395
insert into t1 values (5);
insert into t2 values (5);
insert into t3 values (5,5);
show table status;
396
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
397 398 399
t1	MEMORY	10	Fixed	1	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	1	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	1	#	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
400 401 402 403
delete from t1 where a=5;
delete from t2 where b=5;
delete from t3 where a=5;
show table status;
404
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
405 406 407
t1	MEMORY	10	Fixed	0	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t2	MEMORY	10	Fixed	0	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
t3	MEMORY	10	Fixed	0	#	#	#	#	#	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
408
drop table t1, t2, t3;
409 410
create database mysqltest;
show create database mysqltest;
unknown's avatar
unknown committed
411
Database	Create Database
412 413 414 415 416 417
mysqltest	CREATE DATABASE `mysqltest` /*!40100 DEFAULT CHARACTER SET latin1 */
create table mysqltest.t1(a int);
insert into mysqltest.t1 values(1);
grant select on `mysqltest`.* to mysqltest_1@localhost;
grant usage  on `mysqltest`.* to mysqltest_2@localhost;
grant drop   on `mysqltest`.* to mysqltest_3@localhost;
unknown's avatar
unknown committed
418 419 420
select * from t1;
a
1
421
show create database mysqltest;
unknown's avatar
unknown committed
422
Database	Create Database
423
mysqltest	CREATE DATABASE `mysqltest` /*!40100 DEFAULT CHARACTER SET latin1 */
unknown's avatar
unknown committed
424
drop table t1;
unknown's avatar
unknown committed
425
ERROR 42000: DROP command denied to user 'mysqltest_1'@'localhost' for table 't1'
426 427 428
drop database mysqltest;
ERROR 42000: Access denied for user 'mysqltest_1'@'localhost' to database 'mysqltest'
select * from mysqltest.t1;
unknown's avatar
unknown committed
429
ERROR 42000: SELECT command denied to user 'mysqltest_2'@'localhost' for table 't1'
430 431 432
show create database mysqltest;
ERROR 42000: Access denied for user 'mysqltest_2'@'localhost' to database 'mysqltest'
drop table mysqltest.t1;
unknown's avatar
unknown committed
433
ERROR 42000: DROP command denied to user 'mysqltest_2'@'localhost' for table 't1'
434 435 436
drop database mysqltest;
ERROR 42000: Access denied for user 'mysqltest_2'@'localhost' to database 'mysqltest'
select * from mysqltest.t1;
unknown's avatar
unknown committed
437
ERROR 42000: SELECT command denied to user 'mysqltest_3'@'localhost' for table 't1'
438
show create database mysqltest;
439 440
Database	Create Database
mysqltest	CREATE DATABASE `mysqltest` /*!40100 DEFAULT CHARACTER SET latin1 */
441 442
drop table mysqltest.t1;
drop database mysqltest;
443
set names binary;
unknown's avatar
unknown committed
444 445 446 447 448
delete from mysql.user 
where user='mysqltest_1' || user='mysqltest_2' || user='mysqltest_3';
delete from mysql.db   
where user='mysqltest_1' || user='mysqltest_2' || user='mysqltest_3';
flush privileges;
449 450 451 452
CREATE TABLE t1 (i int, KEY (i)) ENGINE=MEMORY;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
453
  `i` int(11) DEFAULT NULL,
454
  KEY `i` (`i`)
unknown's avatar
unknown committed
455
) ENGINE=MEMORY DEFAULT CHARSET=latin1
456 457 458 459 460
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY USING HASH (i)) ENGINE=MEMORY;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
461
  `i` int(11) DEFAULT NULL,
unknown's avatar
unknown committed
462
  KEY `i` (`i`) USING HASH
unknown's avatar
unknown committed
463
) ENGINE=MEMORY DEFAULT CHARSET=latin1
464 465 466 467 468
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MEMORY;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
469
  `i` int(11) DEFAULT NULL,
unknown's avatar
unknown committed
470
  KEY `i` (`i`) USING BTREE
unknown's avatar
unknown committed
471
) ENGINE=MEMORY DEFAULT CHARSET=latin1
472 473 474 475 476
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY (i)) ENGINE=MyISAM;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
477
  `i` int(11) DEFAULT NULL,
478 479 480 481 482 483 484
  KEY `i` (`i`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
485
  `i` int(11) DEFAULT NULL,
unknown's avatar
unknown committed
486
  KEY `i` (`i`) USING BTREE
487 488 489 490 491 492
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY (i)) ENGINE=MyISAM;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
493
  `i` int(11) DEFAULT NULL,
494 495 496 497 498 499
  KEY `i` (`i`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
ALTER TABLE t1 ENGINE=MEMORY;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
500
  `i` int(11) DEFAULT NULL,
501
  KEY `i` (`i`)
unknown's avatar
unknown committed
502
) ENGINE=MEMORY DEFAULT CHARSET=latin1
503 504 505 506 507
DROP TABLE t1;
CREATE TABLE t1 (i int, KEY USING BTREE (i)) ENGINE=MyISAM;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
508
  `i` int(11) DEFAULT NULL,
unknown's avatar
unknown committed
509
  KEY `i` (`i`) USING BTREE
510 511 512 513 514
) ENGINE=MyISAM DEFAULT CHARSET=latin1
ALTER TABLE t1 ENGINE=MEMORY;
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
515
  `i` int(11) DEFAULT NULL,
unknown's avatar
unknown committed
516
  KEY `i` (`i`) USING BTREE
unknown's avatar
unknown committed
517
) ENGINE=MEMORY DEFAULT CHARSET=latin1
518
DROP TABLE t1;
unknown's avatar
unknown committed
519 520 521 522 523 524
CREATE TABLE t1(
field1 text NOT NULL,
PRIMARY KEY(field1(1000))
);
show index from t1;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
525 526 527 528 529 530 531 532 533 534 535 536
def			STATISTICS	TABLE_NAME	Table	253	64	2	N	1	0	63
def			STATISTICS	NON_UNIQUE	Non_unique	8	1	1	N	32769	0	63
def			STATISTICS	INDEX_NAME	Key_name	253	64	7	N	1	0	63
def			STATISTICS	SEQ_IN_INDEX	Seq_in_index	8	2	1	N	32769	0	63
def			STATISTICS	COLUMN_NAME	Column_name	253	64	6	N	1	0	63
def			STATISTICS	COLLATION	Collation	253	1	1	Y	0	0	63
def			STATISTICS	CARDINALITY	Cardinality	8	21	1	Y	32768	0	63
def			STATISTICS	SUB_PART	Sub_part	8	3	4	Y	32768	0	63
def			STATISTICS	PACKED	Packed	253	10	0	Y	0	0	63
def			STATISTICS	NULLABLE	Null	253	3	0	N	1	0	63
def			STATISTICS	INDEX_TYPE	Index_type	253	16	5	N	1	0	63
def			STATISTICS	COMMENT	Comment	253	16	0	Y	0	0	63
unknown's avatar
unknown committed
537 538 539
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t1	0	PRIMARY	1	field1	A	0	1000	NULL		BTREE	
drop table t1;
540 541 542 543 544 545 546 547 548
create table t1 (
c1 int NOT NULL,
c2 int NOT NULL,
PRIMARY KEY USING HASH (c1),
INDEX USING BTREE(c2)
);
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
unknown's avatar
unknown committed
549 550
  `c1` int(11) NOT NULL,
  `c2` int(11) NOT NULL,
unknown's avatar
unknown committed
551 552
  PRIMARY KEY (`c1`) USING HASH,
  KEY `c2` (`c2`) USING BTREE
553 554
) ENGINE=MyISAM DEFAULT CHARSET=latin1
DROP TABLE t1;
555 556 557 558 559 560
flush tables;
SHOW TABLE STATUS like 't1';
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t1	NULL	NULL	NULL	NULL	#	#	#	#	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Incorrect information in file: './test/t1.frm'
show create table t1;
ERROR HY000: Incorrect information in file: './test/t1.frm'
561
drop table if exists t1;
562 563 564 565 566 567 568 569
CREATE TABLE txt1(a int);
CREATE TABLE tyt2(a int);
CREATE TABLE urkunde(a int);
FLUSH TABLES;
SELECT 1 FROM mysql.db, mysql.proc, mysql.user, mysql.time_zone, mysql.time_zone_name, txt1, tyt2, urkunde LIMIT 0;
1
SHOW OPEN TABLES;
Database	Table	In_use	Name_locked
570
mysql	proc	0	0
571 572
test	urkunde	0	0
mysql	time_zone	0	0
573
mysql	db	0	0
574
test	txt1	0	0
575
mysql	slow_log	1	0
576
test	tyt2	0	0
577
mysql	general_log	1	0
578
mysql	user	0	0
579 580 581
mysql	time_zone_name	0	0
SHOW OPEN TABLES FROM mysql;
Database	Table	In_use	Name_locked
582
mysql	proc	0	0
583
mysql	time_zone	0	0
584 585
mysql	db	0	0
mysql	slow_log	1	0
586
mysql	general_log	1	0
587 588 589 590 591 592 593 594 595 596 597 598 599
mysql	user	0	0
mysql	time_zone_name	0	0
SHOW OPEN TABLES FROM mysql LIKE 'u%';
Database	Table	In_use	Name_locked
mysql	user	0	0
SHOW OPEN TABLES LIKE 't%';
Database	Table	In_use	Name_locked
mysql	time_zone	0	0
test	txt1	0	0
test	tyt2	0	0
mysql	time_zone_name	0	0
SHOW OPEN TABLES LIKE '%o%';
Database	Table	In_use	Name_locked
600
mysql	proc	0	0
601
mysql	time_zone	0	0
602
mysql	slow_log	1	0
603
mysql	general_log	1	0
604 605 606 607
mysql	time_zone_name	0	0
FLUSH TABLES;
SHOW OPEN TABLES;
Database	Table	In_use	Name_locked
608
mysql	general_log	1	0
609
mysql	slow_log	1	0
610 611 612
DROP TABLE txt1;
DROP TABLE tyt2;
DROP TABLE urkunde;
613 614
SHOW TABLES FROM non_existing_database;
ERROR 42000: Unknown database 'non_existing_database'
unknown's avatar
unknown committed
615 616 617 618 619
End of 4.1 tests
DROP VIEW IF EXISTS v1;
DROP PROCEDURE IF EXISTS p1;
CREATE VIEW v1 AS SELECT 1;
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
620 621
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 AS `1`	binary	binary
unknown's avatar
unknown committed
622 623 624
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_CACHE 1;
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
625 626
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_cache 1 AS `1`	binary	binary
unknown's avatar
unknown committed
627 628 629
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_NO_CACHE 1;
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
630 631
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_no_cache 1 AS `1`	binary	binary
unknown's avatar
unknown committed
632 633 634
DROP VIEW v1;
CREATE VIEW v1 AS SELECT NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
635 636
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
637 638 639
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_CACHE NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
640 641
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_cache now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
642 643 644
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_NO_CACHE NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
645 646
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_no_cache now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
647 648 649
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_CACHE SQL_NO_CACHE NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
650 651
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_no_cache now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
652 653 654
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_NO_CACHE SQL_CACHE NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
655 656
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_no_cache now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
657 658 659
DROP VIEW v1;
CREATE VIEW v1 AS SELECT SQL_CACHE SQL_NO_CACHE SQL_CACHE NOW();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
660 661
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_no_cache now() AS `NOW()`	binary	binary
unknown's avatar
unknown committed
662 663 664 665 666 667 668 669 670 671
DROP VIEW v1;
CREATE PROCEDURE p1()
BEGIN
SET @s= 'CREATE VIEW v1 AS SELECT SQL_CACHE 1';
PREPARE stmt FROM @s;
EXECUTE stmt;
DROP PREPARE stmt;
END |
CALL p1();
SHOW CREATE VIEW v1;
unknown's avatar
unknown committed
672 673
View	Create View	character_set_client	collation_connection
v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sql_cache 1 AS `1`	binary	binary
unknown's avatar
unknown committed
674 675
DROP PROCEDURE p1;
DROP VIEW v1;
676 677 678 679
SHOW TABLES FROM no_such_database;
ERROR 42000: Unknown database 'no_such_database'
SHOW COLUMNS FROM no_such_table;
ERROR 42S02: Table 'test.no_such_table' doesn't exist
680 681
flush status;
show status like 'slow_queries';
682 683
Variable_name	Value
Slow_queries	0
684 685 686
show tables;
Tables_in_test
show status like 'slow_queries';
687 688
Variable_name	Value
Slow_queries	1
689 690 691 692
select 1 from information_schema.tables limit 1;
1
1
show status like 'slow_queries';
693 694 695
Variable_name	Value
Slow_queries	2
End of 5.0 tests.
unknown's avatar
unknown committed
696
SHOW AUTHORS;
697 698 699 700 701 702 703 704 705 706 707 708 709 710 711
create database mysqltest;
show create database mysqltest;
Database	Create Database
mysqltest	CREATE DATABASE `mysqltest` /*!40100 DEFAULT CHARACTER SET latin1 */
create table mysqltest.t1(a int);
insert into mysqltest.t1 values(1);
grant select on `mysqltest`.`t1` to mysqltest_4@localhost;
show create database mysqltest;
Database	Create Database
mysqltest	CREATE DATABASE `mysqltest` /*!40100 DEFAULT CHARACTER SET latin1 */
delete from mysql.user where user='mysqltest_4';
delete from mysql.db where user='mysqltest_4';
delete from mysql.tables_priv where user='mysqltest_4';
flush privileges;
drop database mysqltest;
712 713 714
show full plugin;
show warnings;
Level	Code	Message
unknown's avatar
unknown committed
715
Warning	1543	The syntax 'SHOW PLUGIN' is deprecated and will be removed in MySQL 5.2. Please use 'SHOW PLUGINS' instead
716 717
show plugin;
show plugins;
718 719 720 721 722 723 724 725 726 727 728 729 730 731 732
create database `mysqlttest\1`;
create table `mysqlttest\1`.`a\b` (a int);
show tables from `mysqlttest\1`;
Tables_in_mysqlttest\1
a\b
show fields from `mysqlttest\1`.`a\b`;
Field	Type	Null	Key	Default	Extra
a	int(11)	YES		NULL	
show columns from `a\b` from `mysqlttest\1`;
Field	Type	Null	Key	Default	Extra
a	int(11)	YES		NULL	
show keys from `mysqlttest\1`.`a\b`;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
drop table `mysqlttest\1`.`a\b`;
drop database `mysqlttest\1`;
733 734 735 736 737 738 739 740 741 742 743 744 745 746
show engine foobar status;
ERROR 42000: Unknown table engine 'foobar'
show engine foobar logs;
ERROR 42000: Unknown table engine 'foobar'
show engine foobar mutex;
ERROR 42000: Unknown table engine 'foobar'
show engine mutex status;
ERROR 42000: Unknown table engine 'mutex'
show engine csv status;
Type	Name	Status
show engine csv logs;
Type	Name	Status
show engine csv mutex;
Type	Name	Status
747 748 749 750 751 752 753 754
set names utf8;
drop table if exists `été`;
create table `été` (field1 int);
show full tables;
Tables_in_test	Table_type
été	BASE TABLE
drop table `été`;
set names latin1;
755
show columns from `#mysql50#????????`;
unknown's avatar
unknown committed
756
Got one of the listed errors
unknown's avatar
unknown committed
757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828
DROP TABLE IF EXISTS t1;
DROP PROCEDURE IF EXISTS p1;
CREATE TABLE t1(c1 INT);
CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1;
SHOW CREATE TRIGGER t1_bi;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CREATE PROCEDURE p1() SHOW CREATE TRIGGER t1_bi;
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
CALL p1();
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
PREPARE stmt1 FROM 'SHOW CREATE TRIGGER t1_bi';
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
EXECUTE stmt1;
Trigger	sql_mode	SQL Original Statement	character_set_client	collation_connection	Database Collation
t1_bi		CREATE DEFINER=`root`@`localhost` TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
DROP TABLE t1;
DROP PROCEDURE p1;
DEALLOCATE PREPARE stmt1;
829
End of 5.1 tests