mysql> INSERT INTO `test` (`data`) VALUES('222'); mysql> UPDATE `test` SET `data`[1] = 'ab', `data`[3] = 'cd';
Last request Query Rewrite Plugins must rewrite to (or something like that): mysql> UPDATE `test` SET `data` = INSERT(RPAD(`data`,MAX(LENGTH(`data`), 1+LENGTH('ab')),'\0'), 1, LENGTH('ab'), 'ab'), `data` = INSERT(RPAD(`data`,MAX(LENGTH(`data`), 3+LENGTH('cd')),'\0'), 3, LENGTH('cd'), 'cd');
Sveta, сan you help me implement this through Query Rewrite Plugins? Thanks.
mysql> INSERT INTO `test` (`data`) VALUES('222');
mysql> UPDATE `test` SET `data`[1] = 'ab', `data`[3] = 'cd';
Last request Query Rewrite Plugins must rewrite to (or something like that): RPAD(`data` ,MAX(LENGTH( `data`) , 1+LENGTH( 'ab')), '\0'), 1, LENGTH('ab'), 'ab'), `data` = INSERT( RPAD(`data` ,MAX(LENGTH( `data`) , 3+LENGTH( 'cd')), '\0'), 3, LENGTH('cd'), 'cd');
mysql> UPDATE `test` SET `data` = INSERT(
Sveta, сan you help me implement this through Query Rewrite Plugins?
Thanks.