← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Jay Pipes
  • Date: 2010-04-08 16:27:25 UTC
  • mfrom: (1405.6.10 replication-pairs)
  • mto: This revision was merged to the branch mainline in revision 1457.
  • Revision ID: jpipes@serialcoder-20100408162725-sugbgn38oxjqclq2
Merge trunk and replication-pairs with conflict resolution

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/r/max_session.result
 
1
DROP TABLE IF EXISTS b;
 
2
CREATE TABLE b (i int,  PRIMARY KEY (i));
 
3
INSERT INTO b VALUES (1);
 
4
INSERT INTO b VALUES (2);
 
5
INSERT INTO b VALUES (3);
 
6
INSERT INTO b VALUES (4);
 
7
INSERT INTO b VALUES (5);
 
8
INSERT INTO b VALUES (6);
 
9
INSERT INTO b VALUES (7);
 
10
INSERT INTO b VALUES (8);
 
11
INSERT INTO b VALUES (9);
 
12
INSERT INTO b VALUES (10);
 
13
INSERT INTO b VALUES (11);
 
14
INSERT INTO b VALUES (12);
 
15
INSERT INTO b VALUES (13);
 
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;
 
18
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
19
drizzle 0       0       0       1       0       0       0       0       0       0
 
20
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
DROP TABLE b;