← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/logging_stats/tests/t/command.test

  • Committer: Joe Daly
  • Date: 2010-03-08 04:23:54 UTC
  • mto: This revision was merged to the branch mainline in revision 1380.
  • Revision ID: skinny.moey@gmail.com-20100308042354-7k0jibdqaxkhac7o
scoreboard implementation for statistics

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/t/command.test
 
1
# Test alter table
 
2
--disable_warnings
 
3
DROP TABLE IF EXISTS a;
 
4
--enable_warnings
 
5
CREATE TABLE a (i int,  PRIMARY KEY (i));
 
6
ALTER TABLE a ADD COLUMN j int;
 
7
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
 
8
 
 
9
# Test delete
 
10
--disable_warnings
 
11
DROP TABLE IF EXISTS A;
 
12
--enable_warnings
 
13
CREATE TABLE a (i int,  PRIMARY KEY (i));
 
14
INSERT INTO a VALUES (1);
 
15
DELETE FROM a WHERE i=1;
 
16
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
 
17
 
 
18
# Test drop
 
19
--disable_warnings
 
20
DROP TABLE IF EXISTS A;
 
21
--enable_warnings
 
22
CREATE TABLE a (i int,  PRIMARY KEY (i));
 
23
DROP TABLE a;
 
24
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
 
25
 
 
26
# disable the plugin
 
27
set global logging_stats_enable=false;
 
28
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
 
29
# renable it
 
30
set global logging_stats_enable=true;
 
31
 
 
32