← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/connect.test

  • Committer: Brian Aker
  • Date: 2008-07-28 18:01:38 UTC
  • Revision ID: brian@tangent.org-20080728180138-q2pxlq0qiapvqsdn
Remove YEAR field type

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/connect.test
1
 
# This test is to check various cases of connections
2
 
# with right and wrong password, with and without database
3
 
# Unfortunately the check is incomplete as we can't connect without database
4
 
 
5
 
--disable_warnings
6
 
drop table if exists t1,t2;
7
 
--enable_warnings
8
 
 
9
 
 
10
 
#connect (con1,localhost,root,,"");
11
 
#show tables;
12
 
connect (con1,localhost,root,,mysql);
13
 
show tables;
14
 
connect (con2,localhost,root,,test);
15
 
show tables;
16
 
 
17
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
18
 
--error 1049
19
 
connect (fail_con,localhost,root,z,test2);
20
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
21
 
connect (fail_con,localhost,root,z,);
22
 
--disconnect fail_con
23
 
 
24
 
# Now check this user with different databases
25
 
#connect (con1,localhost,test,gambling,"");
26
 
#show tables;
27
 
connect (con3,localhost,test,gambling,mysql);
28
 
show tables;
29
 
connect (con4,localhost,test,gambling,test);
30
 
show tables;
31
 
 
32
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
33
 
--error 1049
34
 
connect (fail_con,localhost,test,,test2);
35
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
36
 
--error 1049
37
 
connect (fail_con,localhost,test,,"");
38
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
39
 
--error 1049
40
 
connect (fail_con,localhost,test,zorro,test2);
41
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
42
 
connect (fail_con,localhost,test,zorro,);
43
 
--disconnect fail_con
44
 
 
45
 
 
46
 
 
47
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
48
 
--error 1049
49
 
connect (fail_con,localhost,test,,test2);
50
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
51
 
connect (fail_con,localhost,test,,);
52
 
--disconnect fail_con
53
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
54
 
--error 1049
55
 
connect (fail_con,localhost,test,zorro,test2);
56
 
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
57
 
connect (fail_con,localhost,test,zorro,);
58
 
--disconnect fail_con
59
 
 
60
 
 
61
 
 
62
 
#
63
 
# Bug#12517: Clear user variables and replication events before 
64
 
#            closing temp tables in thread cleanup.
65
 
connect (con7,localhost,root,,test);
66
 
connection con7;
67
 
create table t1 (id integer not null auto_increment primary key);
68
 
create temporary table t2(id integer not null auto_increment primary key);
69
 
set @id := 1;
70
 
delete from t1 where id like @id;
71
 
disconnect con7;
72
 
--sleep 5
73
 
connection default;
74
 
drop table t1;
75
 
 
76
 
--disconnect con1
77
 
--disconnect con2
78
 
--disconnect con3
79
 
--disconnect con4
80
 
 
81
 
--echo # ------------------------------------------------------------------
82
 
--echo # -- End of 4.1 tests
83
 
--echo # ------------------------------------------------------------------
84
 
 
85
 
--echo # ------------------------------------------------------------------
86
 
--echo # -- End of 5.1 tests
87
 
--echo # ------------------------------------------------------------------