Debian Codegraph @

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;