1
CREATE TABLE t1 (f1 VARCHAR (128), f2 VARCHAR (128), f3 VARBINARY (512),
2
f4 TEXT (65525), f5 VARCHAR (128), KEY (f1(1))) ENGINE=HEAP;
3
INSERT IGNORE INTO t1 VALUES
4
( 'o' , "" , NULL , "" , 0 ) ,
5
(NULL, "" , "" , "" , 'f' ) ;
6
INSERT IGNORE INTO t1 SELECT * FROM t1;