2
# The goal of this grammar is to stress test the operation of the HEAP storage engine by:
4
# * Creating a small set of tables and executing various operations over those tables
6
# * Employ TEMPORARY tables in as many DML contexts as possible
8
# This grammar goes together with the respective mysqld --init file that creates the tables
12
insert | insert | insert |
13
select | delete | update ;
16
SELECT select_list FROM table_name any_where |
17
SELECT select_list FROM table_name restrictive_where order_by |
18
SELECT select_list FROM table_name restrictive_where full_order_by LIMIT _digit ;
22
field_name , select_list ;
25
DELETE FROM table_name restrictive_where |
26
DELETE FROM table_name restrictive_where |
27
DELETE FROM table_name restrictive_where |
28
DELETE FROM table_name restrictive_where |
29
DELETE FROM table_name any_where full_order_by LIMIT _digit ;
32
UPDATE table_name SET update_list restrictive_where |
33
UPDATE table_name SET update_list restrictive_where |
34
UPDATE table_name SET update_list restrictive_where |
35
UPDATE table_name SET update_list restrictive_where |
36
UPDATE table_name SET update_list any_where full_order_by LIMIT _digit ;
39
permissive_where | restrictive_where;
42
WHERE field_name LIKE(CONCAT( _varchar(2), '%')) |
43
WHERE field_name = _varchar(2) |
44
WHERE field_name BETWEEN _varchar(2) AND _varchar(2) ;
47
WHERE field_name comp_op value ;
50
> | < | >= | <= | <> | != | <=> ;
54
field_name = value , update_list ;
57
insert_single | insert_select |
58
insert_multi | insert_multi | insert_multi ;
61
INSERT IGNORE INTO table_name VALUES ( value , value , value , value ) ;
64
INSERT IGNORE INTO table_name VALUES value_list ;
67
INSERT IGNORE INTO table_name SELECT * FROM table_name restrictive_where full_order_by LIMIT _tinyint_unsigned ;
70
| ORDER BY field_name ;
73
ORDER BY f1 , f2 , f3 , f4 ;
76
( value , value, value , value ) |
77
( value , value, value , value ) , value_list |
78
( value , value, value , value ) , value_list ;
81
small_value | large_value ;
84
_digit | _varchar(1) | _varchar(2) | _varchar(32) | NULL ;
87
_varchar(32) | _varchar(1024) | _data | NULL ;
95
heap_complex_indexes |
97
heap_noindexes_large |
98
heap_noindexes_small |