Debian Codegraph @

mysql-test/suite/innodb/r/innodb-replace.result

raw
1 drop table if exists t1;
2 create table t1 (c1 char(5) unique not null, c2 int, stamp timestamp) engine=innodb;
3 select * from t1;
4 c1 c2 stamp
5 replace delayed into t1 (c1, c2) values ( "text1","11");
6 ERROR HY000: DELAYED option not supported for table 't1'
7 select * from t1;
8 c1 c2 stamp
9 replace delayed into t1 (c1, c2) values ( "text1","12");
10 ERROR HY000: DELAYED option not supported for table 't1'
11 select * from t1;
12 c1 c2 stamp
13 drop table t1;
14 #
15 # MDEV-35115 Inconsistent Replace behaviour when multiple
16 # unique index exist
17 #
18 CREATE TABLE t1 (c1 NUMERIC UNSIGNED NOT NULL,
19 c2 INT3 UNIQUE,
20 c3 BIT(2) PRIMARY KEY)ENGINE=InnoDB;
21 ALTER TABLE t1 ADD UNIQUE INDEX(c1);
22 INSERT INTO t1 (c1,c2,c3) VALUES (0,0,b'01');
23 INSERT INTO t1 (c1,c2,c3) VALUES (1,1,b'10');
24 FLUSH STATUS;
25 SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME IN ('HANDLER_DELETE','HANDLER_WRITE','HANDLER_READ_KEY','HANDLER_UPDATE');
26 VARIABLE_NAME VARIABLE_VALUE
27 HANDLER_DELETE 0
28 HANDLER_READ_KEY 0
29 HANDLER_UPDATE 0
30 HANDLER_WRITE 0
31 REPLACE INTO t1 (c1,c2,c3) VALUES (0,1,b'11');
32 SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME IN ('HANDLER_DELETE','HANDLER_WRITE','HANDLER_READ_KEY','HANDLER_UPDATE');
33 VARIABLE_NAME VARIABLE_VALUE
34 HANDLER_DELETE 1
35 HANDLER_READ_KEY 2
36 HANDLER_UPDATE 1
37 HANDLER_WRITE 2
38 SELECT * FROM t1;
39 c1 c2 c3
40 0 1 
41 DROP TABLE t1;
42 CREATE TABLE t1 (f1 INT NOT NULL PRIMARY KEY,
43 f2 INT, f3 INT, f4 INT,
44 UNIQUE INDEX i1(f2))ENGINE=InnoDB;
45 ALTER TABLE t1 ADD INDEX i3(f4);
46 ALTER TABLE t1 ADD UNIQUE INDEX i2(f3);
47 INSERT INTO t1 VALUES (0,0,0,0);
48 INSERT INTO t1 VALUES (1,1,1,1);
49 FLUSH STATUS;
50 SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME IN ('HANDLER_DELETE','HANDLER_WRITE','HANDLER_READ_KEY','HANDLER_UPDATE');
51 VARIABLE_NAME VARIABLE_VALUE
52 HANDLER_DELETE 0
53 HANDLER_READ_KEY 0
54 HANDLER_UPDATE 0
55 HANDLER_WRITE 0
56 REPLACE INTO t1 VALUES (0,0,1,1);
57 SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME IN ('HANDLER_DELETE','HANDLER_WRITE','HANDLER_READ_KEY','HANDLER_UPDATE');
58 VARIABLE_NAME VARIABLE_VALUE
59 HANDLER_DELETE 1
60 HANDLER_READ_KEY 2
61 HANDLER_UPDATE 1
62 HANDLER_WRITE 2
63 DROP TABLE t1;