Developer a Query Rewrite plugin for MySQL 5.7
$30-250 USD
Paid on delivery
We need a Query Rewrite plugin written for MySQL 5.7 that will replace certain clauses in the query with alternate values.
A discussion on the Query Rewrite plugin can be found here:
[url removed, login to view]
The plugin should be controlled via a table containing a list of the clauses that need to be replaced along with the target replacement clause.
For example:
Inbound Query:
CREATE TABLE SEQUENCECONTROL (
NAME VARCHAR(32) NOT NULL,
CURRENTVALUE INT NOT NULL,
INITIALVALUE INT NOT NULL,
INCR INT NOT NULL,
MAXVALUE INT NOT NULL,
CACHESIZE INT NOT NULL,
RESETTOINITIAL CHAR(1) NOT NULL
) TYPE=InnoDB;
Altered Query:
CREATE TABLE SEQUENCECONTROL (
NAME VARCHAR(32) NOT NULL,
CURRENTVALUE INT NOT NULL,
INITIALVALUE INT NOT NULL,
INCR INT NOT NULL,
MAX_VALUE INT NOT NULL,
CACHESIZE INT NOT NULL,
RESETTOINITIAL CHAR(1) NOT NULL
) ENGINE=InnoDB;
As you can see MAXVALUE has been rewitten as MAX_VALUE and TYPE=InnoDB has been rewritten as ENGINE=InnoDB.
Project ID: #8229145