|
STRING: SELECT * FROM table LEFT JOIN fnord AS foo ON foo.id = table.bar ORDER BY table.id DESC LIMIT 10, 30
|
|
REGEX: ^(SELECT|UPDATE|INSERT[[:space:]]+INTO|DELETE[[:space:]]+FROM|EXPLAIN|DROP[[:space:]]+TABLE|CREATE[[:space:]]+TABLE|CREATE[[:space:]]+DATABASE|ALTER[[:space:]]+TABLE|TRUNCATE[[:space:]]+TABLE)[[:space:]]+
|
|
RUNS: 100000
|
|
TIME:0.110332
|
|
|
|
STRING: SELECT * FROM table LEFT JOIN fnord AS foo ON foo.id = table.bar ORDER BY table.id DESC LIMIT 10, 30
|
|
REGEX: ^(SELECT|UPDATE|INSERT[[:space:]]+INTO|DELETE[[:space:]]+FROM|EXPLAIN|(DROP|CREATE|ALTER|TRUNCATE)[[:space:]]+TABLE|CREATE[[:space:]]+DATABASE)[[:space:]]+
|
|
RUNS: 100000
|
|
TIME:0.089561
|
|
|
|
STRING: JOIN fnord AS foo ON foo.id = table.bar ORDER BY table.id DESC LIMIT 10, 30
|
|
REGEX: ^(LEFT[[:space:]]+JOIN|LEFT[[:space:]]+OUTER[[:space:]]+JOIN|RIGHT[[:space:]]+JOIN|RIGHT[[:space:]]+OUTER[[:space:]]+JOIN|INNER[[:space:]]+JOIN|JOIN)[[:space:]]+
|
|
RUNS: 100000
|
|
TIME:0.094288
|
|
|
|
STRING: JOIN fnord AS foo ON foo.id = table.bar ORDER BY table.id DESC LIMIT 10, 30
|
|
REGEX: ^(((INNER|(LEFT|RIGHT)([[:space:]]+OUTER)?)[[:space:]]+)?JOIN)[[:space:]]+
|
|
RUNS: 100000
|
|
TIME:0.093633
|
|
|
|
STRING: UNIQUE KEY
|
|
REGEX: ^(KEY|PRIMARY KEY|UNIQUE KEY|UNIQUE)([[:space:]]+|\()
|
|
RUNS: 100000
|
|
TIME:0.103677
|
|
|
|
STRING: UNIQUE KEY
|
|
REGEX: ^(KEY|((PRIMARY|UNIQUE)([[:space:]]+KEY)?))([[:space:]]+|\()
|
|
RUNS: 100000
|
|
TIME:0.137395
|
|
|
|
STRING: ADD PRIMARY KEY dddddd
|
|
REGEX: ^(CHANGE|DROP[[:space:]]+KEY|DROP[[:space:]]+PRIMARY[[:space:]]+KEY|ADD[[:space:]]+KEY|ADD[[:space:]]+PRIMARY[[:space:]]+KEY|ADD[[:space:]]+UNIQUE|DROP|ADD|RENAME|DEFAULT[[:space:]]+CHARACTER[[:space:]]+SET|ENGINE)([[:space:]]+|\(|=)
|
|
RUNS: 100000
|
|
TIME:0.123844
|
|
|
|
STRING: ADD PRIMARY KEY dddddd
|
|
REGEX: ^(CHANGE|(ADD|DROP)[[:space:]]+(PRIMARY[[:space:]]+)?KEY|DROP|ADD([[:space:]]+UNIQUE)?|RENAME|DEFAULT[[:space:]]+CHARACTER[[:space:]]+SET|ENGINE)([[:space:]]+|\(|=)
|
|
RUNS: 100000
|
|
TIME:0.144361
|
|
|
|
STRING: DROP UNIQUE KEY uniqkey
|
|
REGEX: ^(CHANGE|DROP[[:space:]]+KEY|DROP[[:space:]]+PRIMARY[[:space:]]+KEY|ADD[[:space:]]+KEY|ADD[[:space:]]+PRIMARY[[:space:]]+KEY|ADD[[:space:]]+UNIQUE|DROP|ADD|RENAME|DEFAULT[[:space:]]+CHARACTER[[:space:]]+SET|ENGINE)([[:space:]]+|\(|=)
|
|
RUNS: 100000
|
|
TIME:0.130129
|
|
|
|
STRING: DROP UNIQUE KEY uniqkey
|
|
REGEX: ^(CHANGE|(ADD|DROP)[[:space:]]+(PRIMARY[[:space:]]+)?KEY|DROP|ADD([[:space:]]+UNIQUE)?|RENAME|DEFAULT[[:space:]]+CHARACTER[[:space:]]+SET|ENGINE)([[:space:]]+|\(|=)
|
|
RUNS: 100000
|
|
TIME:0.138944
|
|
|
|
STRING: int,
|
|
REGEX: ^(int|smallint|tinyint|mediumint|bigint|double|numeric|decimal|float|varchar|char|text|tinytext|mediumtext|longtext|blob|tinyblob|mediumblob|longblob)([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.113772
|
|
|
|
STRING: int,
|
|
REGEX: ^((small|tiny|medium|big)?int|double|numeric|decimal|float|(var)?char|(tiny|medium|long)?(text|blob))([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.143518
|
|
|
|
STRING: bigint,
|
|
REGEX: ^(int|smallint|tinyint|mediumint|bigint|double|numeric|decimal|float|varchar|char|text|tinytext|mediumtext|longtext|blob|tinyblob|mediumblob|longblob)([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.125842
|
|
|
|
STRING: bigint,
|
|
REGEX: ^((small|tiny|medium|big)?int|double|numeric|decimal|float|(var)?char|(tiny|medium|long)?(text|blob))([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.139609
|
|
|
|
STRING: tinyblob,
|
|
REGEX: ^(int|smallint|tinyint|mediumint|bigint|double|numeric|decimal|float|varchar|char|text|tinytext|mediumtext|longtext|blob|tinyblob|mediumblob|longblob)([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.131100
|
|
|
|
STRING: tinyblob,
|
|
REGEX: ^((small|tiny|medium|big)?int|double|numeric|decimal|float|(var)?char|(tiny|medium|long)?(text|blob))([[:space:],]+|\()
|
|
RUNS: 100000
|
|
TIME:0.163108
|
|
|