3
select | select | call |
8
START TRANSACTION | COMMIT | ROLLBACK ;
11
SELECT /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ select_item AS f1
16
CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ procedure_name ( @inout1 ) |
17
SET @inout1 = 0 ; CALL procedure_name ( @inout1 ) ; SELECT /* RESULTSET_SINGLE_INTEGER_ONE */ IF(@inout1 IN (0,1), 1, 999);
25
pick_table_name UPDATE $table_name SET _field = _digit ;
28
pick_table_name INSERT INTO $table_name SELECT * FROM $table_name LIMIT 0 ;
31
pick_table_name DELETE FROM $table_name LIMIT 1 ;
35
function_name ( _digit ) |
36
function_name ( _field ) ;
43
pick_table_name $table_name |
44
pick_view_name $view_name ;
48
WHERE argument operator argument;
53
function_name ( argument ) ;
64
# | trigger_ddl ; # bug46748
67
pick_table_name create_table | pick_table_name create_table | pick_table_name create_table |
68
pick_table_name alter_table ;
69
pick_table_name drop_table ; create_table ;
72
pick_function_name create_function | pick_function_name create_function | pick_function_name create_function |
73
pick_function_name drop_function ; create_function ;
76
pick_procedure_name create_procedure | pick_procedure_name create_procedure | pick_procedure_name create_procedure |
77
pick_procedure_name drop_procedure ; create_procedure ;
80
pick_trigger_name create_trigger | pick_trigger_name create_trigger | pick_trigger_name create_trigger |
81
pick_trigger_name drop_trigger ; create_trigger ;
84
pick_view_name create_view | pick_view_name create_view | pick_view_name create_view |
85
pick_view_name alter_view | pick_view_name drop_view ; create_view ;
88
{ $function_name = 'func_'.$prng->int(1,3) ; return undef } ;
91
{ $procedure_name = 'proc_'.$prng->int(1,3) ; return undef } ;
94
# { $table_name = $prng->arrayElement($executors->[0]->tables()) ; return undef } |
95
{ $table_name = 'table_'.$prng->int(1,3) ; return undef } ;
98
{ $trigger_name = 'trigger_'.$prng->int(1..9) ; return undef } ;
101
{ $view_name = 'view_'.$prng->int(1..3) ; return undef } ;
104
{ 'func_'.$prng->int(1,3) } ;
107
{ 'proc_'.$prng->int(1,3) } ;
110
CREATE FUNCTION $function_name (in1 INTEGER) RETURNS INTEGER deterministic function_body ;
113
CREATE PROCEDURE $procedure_name (INOUT inout1 INT) procedure_body ;
116
CREATE temporary TABLE $table_name ( `int` INTEGER, `int_key` INTEGER, KEY (`int_key`) ) select ;
119
CREATE OR REPLACE ALGORITHM = view_algorithm VIEW $view_name AS select ;
122
ALTER ALGORITHM = view_algorithm VIEW $view_name AS select ;
125
DROP VIEW $view_name ;
128
UNDEFINED | MERGE | TEMPTABLE ;
132
# | TEMPORARY ; # bug46747
135
pick_table_name CREATE TRIGGER $trigger_name trigger_time trigger_event ON $table_name FOR EACH ROW update ;
144
DROP TRIGGER $trigger_name;
147
DROP TABLE IF EXISTS $table_name;
150
ALTER TABLE $table_name ADD COLUMN `default` INTEGER DEFAULT _digit |
151
ALTER TABLE $table_name CHANGE COLUMN `default` `default` INTEGER DEFAULT _digit ;
154
DROP FUNCTION $function_name ;
157
DROP PROCEDURE $procedure_name ;
164
BEGIN SELECT COUNT(DISTINCT select_item ) INTO inout1 FROM join_list where ; END |
165
BEGIN SELECT select_item FROM join_list where ; END ;
168
| DETERMINISTIC | NOT DETERMINISTIC ;