Comment 6 for bug 1462433

Revision history for this message
Rafal (andruwn) wrote :

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.