1-- source include/not_embedded.inc 2 3--echo # 4--echo # Testing multiple indexed UPDATE and DELETE 5--echo # 6CREATE TABLE t1 ( 7id INT(4) NOT NULL, 8msg VARCHAR(16) NOT NULL, 9INDEX IDM(id,msg)) 10ENGINE=CONNECT TABLE_TYPE=DOS; 11INSERT INTO t1 VALUES(1,'one'),(4, 'four'),(7,'seven'),(8,'eight'),(10,'ten'),(11,'eleven'),(40,'forty'),(35,'thirty five'),(60,'sixty'),(72,'seventy two'),(81,'eighty one'); 12INSERT INTO t1 VALUES(1,'un'),(4, 'quatre'),(7,'sept'),(8,'huit'),(10,'dix'),(11,'onze'),(40,'quarante'),(35,'trente cinq'),(60,'soixante'),(72,'soixante douze'),(81,'quatrevingt un'); 13SELECT * FROM t1 IGNORE INDEX (IDM); 14UPDATE t1 SET msg = 'dieci' WHERE id = 10; 15SELECT * FROM t1 IGNORE INDEX (IDM); 16UPDATE t1 SET msg = 'septante deux' WHERE id = 72; 17SELECT * FROM t1 IGNORE INDEX (IDM); 18UPDATE t1 SET id=2, msg='deux' WHERE id=4 AND msg='quatre'; 19SELECT * FROM t1 IGNORE INDEX (IDM); 20DELETE FROM t1 WHERE id IN (8,40); 21SELECT * FROM t1 IGNORE INDEX (IDM); 22DROP TABLE t1; 23