mirror of
https://github.com/MariaDB/server.git
synced 2025-04-16 20:25:33 +02:00
5 lines
282 B
Text
5 lines
282 B
Text
CREATE TABLE t1(c1 INT default 0,c2 INT,c3 CHAR(10),c4 CHAR(10),c5 CHAR(10),PRIMARY KEY(c1),INDEX(c3,c4(1),c5(1)),INDEX(c2)) ENGINE=TokuDB;
|
|
INSERT INTO t1 VALUES(),(),(),(),();
|
|
ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
|
|
UPDATE t1 SET c1=1 WHERE c1=1 OR c2=1;
|
|
DROP TABLE t1;
|