16
16
UPDATE a SET i=10 WHERE i=3;
17
17
DELETE FROM a WHERE i=10;
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;
18
SELECT IF(COUNT_SELECT, "YES", "NO"), IF(COUNT_UPDATE, "YES", "NO"), IF(COUNT_INSERT, "YES", "NO") FROM DATA_DICTIONARY.CUMULATIVE_SQL_COMMANDS WHERE USERNAME != "root" ORDER BY USERNAME;
19
19
IF(COUNT_SELECT, "YES", "NO") IF(COUNT_UPDATE, "YES", "NO") IF(COUNT_INSERT, "YES", "NO")
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")
22
SELECT USERNAME, 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 USERNAME != "root" ORDER BY USERNAME;
23
USERNAME 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
24
drizzle YES YES NO YES YES YES
25
25
drizzle_test YES YES NO YES YES YES
added
removed
plugin/logging_stats/tests/r/cumulative.result
