← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/logging_stats/tests/t/max_user.test

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-12-21 16:39:40 UTC
  • mfrom: (1.2.4 upstream)
  • Revision ID: james.westby@ubuntu.com-20101221163940-c1pfo1jjvx7909xq
Tags: 2010.12.06-0ubuntu1
* New upstream release.
* Added libaio-dev build depend for InnoDB.
* Removed libpcre patch - applied upstream.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/t/max_user.test
5
5
--enable_warnings
6
6
CREATE TABLE a (i int,  PRIMARY KEY (i));
7
7
 
8
 
--echo Create 750 users  
 
8
--echo Create 750 users
9
9
--disable_query_log
10
10
let $1=750;
11
11
let $2=0;
14
14
  inc $2;
15
15
  connect (con3, localhost, $2,,);
16
16
  eval INSERT INTO a VALUES ($2);
17
 
  connection default; 
 
17
  connection default;
18
18
  disconnect con3;
19
19
  dec $1;
20
20
}
21
21
--enable_query_log
22
22
--sleep 1
23
 
SELECT * FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS ORDER BY USER + 0 ASC;
 
23
SELECT
 
24
  IF(COUNT_SELECT, "NO", "YES"),
 
25
  IF(COUNT_DELETE, "NO", "YES"),
 
26
  IF(COUNT_UPDATE, "NO", "YES"),
 
27
  IF(COUNT_INSERT, "YES", "NO"),
 
28
  IF(COUNT_ROLLBACK, "NO", "YES"),
 
29
  IF(COUNT_COMMIT, "NO", "YES"),
 
30
  IF(COUNT_CREATE, "NO", "YES"),
 
31
  IF(COUNT_ALTER, "NO", "YES"),
 
32
  IF(COUNT_DROP, "NO", "YES"),
 
33
  IF(COUNT_ADMIN, "NO", "YES")
 
34
  FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS ORDER BY USER + 0 ASC;
24
35
 
25
36
 
26
37
SHOW CREATE TABLE data_dictionary.GLOBAL_STATEMENTS;
27
38
--replace_column 1 #
28
39
SELECT count(*) FROM data_dictionary.GLOBAL_STATEMENTS;
 
40
--replace_column 2 #
29
41
SELECT * FROM data_dictionary.GLOBAL_STATEMENTS;
30
42
 
31
43
DROP TABLE a;