~drizzle-trunk/drizzle/development

DROP TABLE IF EXISTS a;

CREATE TABLE a (i int,  PRIMARY KEY (i));

ALTER TABLE a ADD COLUMN j int;

SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;

USER    IP      COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN

root    127.0.0.1       0       0       0       0       0       0       1       1       1       0

DROP TABLE IF EXISTS A;

CREATE TABLE a (i int,  PRIMARY KEY (i));

INSERT INTO a VALUES (1);

DELETE FROM a WHERE i=1;

SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;

USER    IP      COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN

root    127.0.0.1       1       1       0       1       0       0       2       1       2       0

DROP TABLE IF EXISTS A;

CREATE TABLE a (i int,  PRIMARY KEY (i));

DROP TABLE a;

SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;

USER    IP      COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN

root    127.0.0.1       2       1       0       1       0       0       3       1       4       0

set global logging_stats_enable=false;

SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;

USER    IP      COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN

set global logging_stats_enable=true;