mysql-test/suite/innodb/r/bug33657235.result
raw| 1 | CREATE TABLE t1 ( |
| 2 | id INT PRIMARY KEY, |
| 3 | u CHAR(2) NOT NULL, |
| 4 | v CHAR(2) NOT NULL, |
| 5 | UNIQUE INDEX by_u_1 (u(1)), |
| 6 | INDEX by_v_1 (v(1)) |
| 7 | ); |
| 8 | INSERT INTO t1 VALUES (0,"aa","aa"),(10,"ee","ee"),(20,"oo","oo"); |
| 9 | BEGIN; |
| 10 | SELECT COUNT(*) FROM t1 FORCE INDEX ( by_v_1 ) WHERE v>"b" AND id<>10 FOR SHARE; |
| 11 | COUNT(*) |
| 12 | 1 |
| 13 | BEGIN; |
| 14 | UPDATE t1 SET u="oo",v="ef" WHERE id=10; |
| 15 | ERROR 23000: Duplicate entry 'o' for key 't1.by_u_1' |
| 16 | ROLLBACK; |
| 17 | DROP TABLE t1; |