~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

# check that CSV engine was compiled in, as the test relies on the presence

# of the log tables (which are CSV-based). By connect mysql; show tables;

--source include/have_csv.inc

--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 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

grant ALL on *.* to test@localhost identified by "gambling";

grant ALL on *.* to test@127.0.0.1 identified by "gambling";

# 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 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

# check if old password version also works

update mysql.user set password=old_password("gambling2") where user=_binary"test";

flush privileges;

connect (con10,localhost,test,gambling2,);

connect (con5,localhost,test,gambling2,mysql);

connection con5;

set password="";

--error 1372

set password='gambling3';

set password=old_password('gambling3');

show tables;

connect (con6,localhost,test,gambling3,test);

show tables;

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

connect (fail_con,localhost,test,,);

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT

--error 1045

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

# remove user 'test' so that other tests which may use 'test'

# do not depend on this test.

delete from mysql.user where user=_binary"test";

flush privileges;

#

# 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 5

connection default;

drop table t1;

--disconnect con1

--disconnect con2

--disconnect con3

--disconnect con4

--disconnect con5

--disconnect con6

--disconnect con10

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

--echo # -- End of 4.1 tests

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

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

--echo # -- End of 5.1 tests

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