|
1
by brian
clean slate |
1 |
drop table if exists t1,t2;
|
2 |
show tables;
|
|
3 |
Tables_in_mysql
|
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
4 |
show tables;
|
5 |
Tables_in_test
|
|
6 |
connect(localhost,root,z,test2,MASTER_PORT,);
|
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
7 |
ERROR 42000: Unknown schema 'test2'
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
8 |
show tables;
|
9 |
Tables_in_mysql
|
|
10 |
show tables;
|
|
11 |
Tables_in_test
|
|
12 |
connect(localhost,test,,test2,MASTER_PORT,);
|
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
13 |
ERROR 42000: Unknown schema 'test2'
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
14 |
connect(localhost,test,,"",MASTER_PORT,);
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
15 |
ERROR 42000: Unknown schema '""'
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
16 |
connect(localhost,test,zorro,test2,MASTER_PORT,);
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
17 |
ERROR 42000: Unknown schema 'test2'
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
18 |
connect(localhost,test,,test2,MASTER_PORT,);
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
19 |
ERROR 42000: Unknown schema 'test2'
|
|
722.2.16
by Monty Taylor
Fixed connect.test. |
20 |
connect(localhost,test,zorro,test2,MASTER_PORT,);
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
21 |
ERROR 42000: Unknown schema 'test2'
|
|
1
by brian
clean slate |
22 |
create table t1 (id integer not null auto_increment primary key);
|
23 |
create temporary table t2(id integer not null auto_increment primary key);
|
|
24 |
set @id := 1;
|
|
25 |
delete from t1 where id like @id;
|
|
26 |
drop table t1;
|
|
27 |
# ------------------------------------------------------------------
|
|
28 |
# -- End of 4.1 tests
|
|
29 |
# ------------------------------------------------------------------
|
|
30 |
# ------------------------------------------------------------------
|
|
31 |
# -- End of 5.1 tests
|
|
32 |
# ------------------------------------------------------------------
|