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

« back to all changes in this revision

Viewing changes to plugin/logging_stats/tests/r/max_session.result

  • 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:
14
14
INSERT INTO b VALUES (12);
15
15
INSERT INTO b VALUES (13);
16
16
INSERT INTO b VALUES (14);
17
 
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS;
 
17
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS WHERE USER != "root";
18
18
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
19
19
drizzle 0       0       0       1       0       0       0       0       0       0
 
20
drizzle 0       0       0       1       0       0       0       0       0       0
 
21
drizzle 0       0       0       1       0       0       0       0       0       0
 
22
drizzle 0       0       0       1       0       0       0       0       0       0
 
23
drizzle 0       0       0       1       0       0       0       0       0       0
 
24
drizzle 0       0       0       1       0       0       0       0       0       0
20
25
drizzle_test    0       0       0       1       0       0       0       0       0       0
21
 
root    0       0       0       0       0       0       0       0       1       0
22
 
drizzle 0       0       0       1       0       0       0       0       0       0
23
 
root    0       0       0       1       0       0       1       0       0       0
24
 
drizzle 0       0       0       1       0       0       0       0       0       0
25
 
drizzle 0       0       0       1       0       0       0       0       0       0
26
 
drizzle 0       0       0       1       0       0       0       0       0       0
27
 
drizzle 0       0       0       1       0       0       0       0       0       0
28
26
DROP TABLE b;
29
27
show global status;
30
28
Variable_name   Value