← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2011-01-08 03:39:25 UTC
  • mfrom: (2062.1.2 build)
  • Revision ID: kalebral@gmail.com-20110108033925-koobar399kwrm4ba
Merge Brian - parser clean up
Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/r/command.result
12
12
START TRANSACTION;
13
13
INSERT INTO a VALUES (1);
14
14
COMMIT;
15
 
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";
16
 
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
15
SELECT USERNAME, 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 USERNAME != "root";
 
16
USERNAME        COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
17
17
set global logging_stats_enable=false;
18
 
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";
19
 
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
18
SELECT USERNAME, 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 USERNAME != "root";
 
19
USERNAME        COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
20
20
set global logging_stats_enable=true;
21
21
SHOW CREATE TABLE data_dictionary.SESSION_STATEMENTS;
22
22
Table   Create Table
69
69
CREATE TABLE b (i int,  PRIMARY KEY (i));
70
70
INSERT INTO b VALUES (1);
71
71
INSERT INTO b VALUES (2);
72
 
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";
73
 
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
72
SELECT USERNAME, 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 USERNAME != "root";
 
73
USERNAME        COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
74
74
drizzle 0       0       0       1       0       0       0       0       0       0
75
75
SELECT SCOREBOARD_SIZE, NUMBER_OF_RANGE_LOCKS, MAX_USERS_LOGGED FROM DATA_DICTIONARY.SCOREBOARD_STATISTICS;
76
76
SCOREBOARD_SIZE NUMBER_OF_RANGE_LOCKS   MAX_USERS_LOGGED