mysql-test/suite/query_rewrite_plugins/include/trivial.inc
raw| 1 | DELETE FROM query_rewrite.rewrite_rules; |
| 2 | |
| 3 | INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement ) |
| 4 | VALUES ( 'SELECT * FROM mydb.mytable WHERE mycol = ?', 'select "rule1"' ); |
| 5 | |
| 6 | CALL query_rewrite.flush_rewrite_rules(); |
| 7 | |
| 8 | CREATE DATABASE mydb; |
| 9 | CREATE TABLE mydb.mytable ( mycol char(3), mycol2 CHAR(100) ); |
| 10 | INSERT INTO mydb.mytable VALUES ( 'xxx', 'Not supposed to be seeing this.' ); |
| 11 | |
| 12 | SELECT * FROM mydb.mytable WHERE mycol = 'xxx'; |
| 13 | |
| 14 | DROP DATABASE mydb; |