Comment 1 for bug 613408

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Test case:

CREATE TABLE IF NOT EXISTS X (
         f1 CHAR(255) BINARY ,
         f2 CHAR(255) BINARY NOT NULL DEFAULT '0',
         f3 CHAR(255) BINARY NOT NULL ,
         f4 CHAR(255) BINARY NOT NULL DEFAULT '0' ,
         v3 CHAR(255) BINARY AS ( ( f1 NOT LIKE '%' ) ) PERSISTENT ,
         KEY (v3)
) ENGINE=Maria;
INSERT INTO X ( f1 , f2 , f3 , f4 ) SELECT f1 , f4 , f1 , f4 FROM X;
DELETE FROM X;