← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/user_limits.result

  • Committer: Grant Limberg
  • Date: 2008-08-12 21:13:01 UTC
  • mto: (322.1.1 codestyle)
  • mto: This revision was merged to the branch mainline in revision 324.
  • Revision ID: grant@glsoftware.net-20080812211301-ym3wsowelkgp16s2
renamed all instances of MYSQL_ to DRIZZLE_

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/user_limits.result
41
41
i
42
42
select * from t1;
43
43
i
44
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
44
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
45
45
ERROR 42000: User 'mysqltest_1' has exceeded the 'max_connections_per_hour' resource (current value: 2)
46
46
select * from t1;
47
47
i
48
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
48
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
49
49
ERROR 42000: User 'mysqltest_1' has exceeded the 'max_connections_per_hour' resource (current value: 2)
50
50
drop user mysqltest_1@localhost;
51
51
flush privileges;
55
55
i
56
56
select * from t1;
57
57
i
58
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
58
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
59
59
ERROR 42000: User 'mysqltest_1' has exceeded the 'max_user_connections' resource (current value: 2)
60
60
select * from t1;
61
61
i
63
63
flush user_resources;
64
64
select * from t1;
65
65
i
66
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
66
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
67
67
ERROR 42000: User 'mysqltest_1' has exceeded the 'max_user_connections' resource (current value: 3)
68
68
drop user mysqltest_1@localhost;
69
69
select @@session.max_user_connections, @@global.max_user_connections;
82
82
2       2
83
83
select * from t1;
84
84
i
85
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
85
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
86
86
ERROR 42000: User mysqltest_1 already has more than 'max_user_connections' active connections
87
87
grant usage on *.* to mysqltest_1@localhost with max_user_connections 3;
88
88
flush user_resources;
89
89
select @@session.max_user_connections, @@global.max_user_connections;
90
90
@@session.max_user_connections  @@global.max_user_connections
91
91
3       2
92
 
connect(localhost,mysqltest_1,,test,MYSQL_PORT,MYSQL_SOCK);
 
92
connect(localhost,mysqltest_1,,test,DRIZZLE_PORT,DRIZZLE_SOCK);
93
93
ERROR 42000: User 'mysqltest_1' has exceeded the 'max_user_connections' resource (current value: 3)
94
94
set global max_user_connections= 0;
95
95
drop user mysqltest_1@localhost;