4
4
timestamp: 1297869656
5
5
query: 'DROP TABLE IF EXISTS a;'
8
9
timestamp: 1297869656
9
10
query: 'CREATE TABLE a(id INT,value CHAR(20));'
12
14
timestamp: 1297869656
13
15
query: 'set long_query_time= 0;'
15
18
timestamp: 1297869656
16
19
query: 'set long_query_time= 0;'
18
22
timestamp: 1297869656
19
23
query: 'set long_query_time= 0;'
21
26
timestamp: 1297869656
22
27
query: 'INSERT INTO a VALUES(0,^first^);'
24
30
timestamp: 1297869656
25
31
query: 'INSERT INTO a VALUES(1,^second^);'
27
34
timestamp: 1297869656
28
35
query: 'SELECT count(*) FROM a;'
30
38
timestamp: 1297869656
31
39
query: 'INSERT INTO a VALUES(2,^third^);'
34
query: 'SELECT count(*) FROM a;'
37
query: 'SELECT count(*) FROM a;'
43
query: 'SELECT count(*) FROM a;'
47
query: 'SELECT count(*) FROM a;'
39
50
timestamp: 1297869656
40
51
query: 'INSERT INTO a VALUES(3,"fourth");'
42
54
timestamp: 1297869656
43
55
query: 'SELECT /* multi\n#line\n--comment\n*/ count(*) FROM a;'
46
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
49
query: 'SELECT count(*) FROM a;'
52
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
55
query: 'SELECT count(*) FROM a;'
58
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
61
query: 'SELECT count(*) FROM a;'
59
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
63
query: 'SELECT count(*) FROM a;'
67
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
71
query: 'SELECT count(*) FROM a;'
75
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1, name from a;'
79
query: 'SELECT count(*) FROM a;'
63
82
timestamp: 1297869656
64
83
query: 'INSERT INTO a SELECT id + (select max(id) from a) +1 , name from a;'
66
86
timestamp: 1297869656
67
87
query: 'SELECT count(*) FROM a;'
69
90
timestamp: 1297869656
70
91
query: 'SELECT * FROM a;'
72
94
timestamp: 1297869656
73
95
query: 'SELECT * FROM a;'
75
98
timestamp: 1297869656
78
102
timestamp: 1297869656
81
106
timestamp: 1297869656