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;
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;