~drizzle-trunk/drizzle/development

# This test is to check various cases of connections

# with right and wrong password, with and without database

# Unfortunately the check is incomplete as we can't connect without database

--disable_warnings

drop table if exists t1,t2;

--enable_warnings

#connect (con1,localhost,root,,"");

#show tables;

connect (con1,localhost,root,,mysql);

show tables;

connect (con2,localhost,root,,test);

show tables;

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,root,z,test2);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

connect (fail_con,localhost,root,z,);

--disconnect fail_con

# Now check this user with different databases

#connect (con1,localhost,test,gambling,"");

#show tables;

connect (con3,localhost,test,gambling,mysql);

show tables;

connect (con4,localhost,test,gambling,test);

show tables;

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,test,,test2);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,test,,"");

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,test,zorro,test2);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

connect (fail_con,localhost,test,zorro,);

--disconnect fail_con

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,test,,test2);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

connect (fail_con,localhost,test,,);

--disconnect fail_con

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error ER_BAD_DB_ERROR

connect (fail_con,localhost,test,zorro,test2);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

connect (fail_con,localhost,test,zorro,);

--disconnect fail_con

#

# Bug#12517: Clear user variables and replication events before 

#            closing temp tables in thread cleanup.

connect (con7,localhost,root,,test);

connection con7;

create table t1 (id integer not null auto_increment primary key);

create temporary table t2(id integer not null auto_increment primary key);

set @id := 1;

delete from t1 where id like @id;

disconnect con7;

--sleep 0.5

connection default;

drop table t1;

--disconnect con1

--disconnect con2

--disconnect con3

--disconnect con4

--echo # ------------------------------------------------------------------

--echo # -- End of 4.1 tests

--echo # ------------------------------------------------------------------

--echo # ------------------------------------------------------------------

--echo # -- End of 5.1 tests

--echo # ------------------------------------------------------------------