← Back to branch summary

~dshrews/drizzle/bug673105

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-12-16 18:42:53 UTC
  • mfrom: (1999.1.6 clean)
  • Revision ID: brian@tangent.org-20101216184253-jv6usrdyu9hfunk5
Rollup of error work done by Monty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/r/cumulative.result
3
3
INSERT INTO a VALUES (1);
4
4
INSERT INTO a VALUES (2);
5
5
UPDATE a SET i=9 WHERE i=2;
6
 
SELECT * FROM a;
 
6
SELECT * FROM a ORDER BY i;
7
7
i
8
8
1
9
9
9
10
10
INSERT INTO a VALUES (3);
11
 
SELECT * FROM a;
 
11
SELECT * FROM a ORDER BY i;
12
12
i
13
13
1
14
14
3
15
15
9
16
16
UPDATE a SET i=10 WHERE i=3;
17
17
DELETE FROM a WHERE i=10;
18
 
SELECT * FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS;
19
 
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
20
 
drizzle 1       0       1       2       0       0       1       0       1       0
21
 
drizzle_test    1       1       1       1       0       0       0       0       0       0
22
 
SELECT * FROM DATA_DICTIONARY.CUMULATIVE_USER_STATS;
23
 
USER    BYTES_RECEIVED  BYTES_SENT      DENIED_CONNECTIONS      LOST_CONNECTIONS        ACCESS_DENIED   CONNECTED_TIME_SEC      EXECUTION_TIME_NSEC     ROWS_FETCHED    ROWS_UPDATED    ROWS_DELETED    ROWS_INSERTED
24
 
drizzle #       #       0       2       0       #       #       4       1       0       2
25
 
drizzle_test    #       #       0       1       0       #       #       3       1       1       1
 
18
SELECT IF(COUNT_SELECT, "YES", "NO"), IF(COUNT_UPDATE, "YES", "NO"), IF(COUNT_INSERT, "YES", "NO") FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS WHERE USER != "root" ORDER BY USER;
 
19
IF(COUNT_SELECT, "YES", "NO")   IF(COUNT_UPDATE, "YES", "NO")   IF(COUNT_INSERT, "YES", "NO")
 
20
YES     YES     YES
 
21
YES     YES     YES
 
22
SELECT USER, IF(DENIED_CONNECTIONS, "NO", "YES"), IF(LOST_CONNECTIONS, "YES", "NO"), IF(DENIED_CONNECTIONS, "YES", "NO"),  IF(ROWS_FETCHED, "YES", "NO"), IF(ROWS_UPDATED, "YES", "NO"), IF(ROWS_INSERTED, "YES", "NO")  FROM DATA_DICTIONARY.CUMULATIVE_USER_STATS WHERE USER != "root" ORDER BY USER;
 
23
USER    IF(DENIED_CONNECTIONS, "NO", "YES")     IF(LOST_CONNECTIONS, "YES", "NO")       IF(DENIED_CONNECTIONS, "YES", "NO")     IF(ROWS_FETCHED, "YES", "NO")   IF(ROWS_UPDATED, "YES", "NO")   IF(ROWS_INSERTED, "YES", "NO")
 
24
drizzle YES     YES     NO      YES     YES     YES
 
25
drizzle_test    YES     YES     NO      YES     YES     YES
26
26
DROP TABLE a;