Debian Codegraph @

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

raw
1 # Bug #28523025: INNODB: ASSERTION FAILURE:
2 # LOCK0LOCK.CC:1468:LOCK_REC_GET_REC_NOT_GAP(LOCK)
3 CREATE TABLE t0(a INT PRIMARY KEY);
4 CREATE VIEW v0 AS SELECT a FROM t0;
5 DROP TABLE t0;
6 CREATE TABLE t0(a int) REPLACE SELECT 0 AS a;
7 DROP TABLE t0;
8 DROP VIEW v0;
9 CREATE TABLE t0(a INT, b INT);
10 INSERT INTO t0 VALUES (1,1), (1,2), (2,2);
11 CREATE TABLE t1(a INT, b INT);
12 CREATE VIEW v0 AS SELECT b FROM t1;
13 DROP TABLE t1;
14 CREATE TABLE t1(
15 a INT PRIMARY KEY,
16 b INT
17 ) REPLACE SELECT a,b FROM t0 ORDER BY a,b;
18 SELECT * FROM t1;
19 a b
20 1 2
21 2 2
22 DROP TABLE t1;
23 DROP TABLE t0;
24 DROP VIEW v0;
25 CREATE TABLE t0(a INT, b INT);
26 INSERT INTO t0 VALUES (1,1), (1,2), (2,2);
27 CREATE TABLE t1(a INT, b INT);
28 CREATE VIEW v0 AS SELECT b FROM t1;
29 DROP TABLE t1;
30 CREATE TABLE t1(
31 a INT PRIMARY KEY,
32 b INT
33 ) IGNORE SELECT a,b FROM t0 ORDER BY a,b;
34 Warnings:
35 Warning 1062 Duplicate entry '1' for key 't1.PRIMARY'
36 SELECT * FROM t1;
37 a b
38 1 1
39 2 2
40 DROP TABLE t1;
41 DROP TABLE t0;
42 DROP VIEW v0;
43 CREATE TABLE t0(a INT, b INT);
44 INSERT INTO t0 VALUES (1,1), (1,2), (2,2);
45 CREATE TABLE t1(a INT, b INT);
46 CREATE VIEW v0 AS SELECT b FROM t1;
47 DROP TABLE t1;
48 CREATE TABLE t1(
49 a INT PRIMARY KEY,
50 b INT
51 ) SELECT a,b FROM t0 ORDER BY a,b;
52 ERROR 23000: Duplicate entry '1' for key 't1.PRIMARY'
53 DROP TABLE t0;
54 DROP VIEW v0;
55 CREATE TABLE t1(a INT NOT NULL PRIMARY KEY, b INT NOT NULL UNIQUE);
56 INSERT INTO t1 (a,b) VALUES
57 (1,10), (2,20), (3,30), (4,40), (5,50), (6,60), (8,80), (10,100);
58 BEGIN;
59 REPLACE INTO t1 (a,b) VALUES (2,13);
60 INSERT INTO t1 (a,b) VALUES (4,43) ON DUPLICATE KEY UPDATE b=43;
61 REPLACE INTO t1 (a,b) VALUES (7,60);
62 INSERT INTO t1 (a,b) VALUES (9,80) ON DUPLICATE KEY UPDATE a=9;
63 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
64 FROM performance_schema.data_locks
65 WHERE object_schema='test' AND object_name = 't1'
66 ORDER BY 1,2,3,4,5;
67 index_name lock_type lock_mode lock_status lock_data
68 NULL TABLE IX GRANTED NULL
69 b RECORD X GRANTED 100, 10
70 b RECORD X GRANTED 60, 6
71 b RECORD X GRANTED 80, 8
72 b RECORD X,GAP GRANTED 60, 7
73 b RECORD X,GAP GRANTED 80, 9
74 PRIMARY RECORD X,GAP GRANTED 10
75 PRIMARY RECORD X,GAP GRANTED 7
76 PRIMARY RECORD X,GAP GRANTED 8
77 PRIMARY RECORD X,GAP GRANTED 9
78 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
79 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
80 PRIMARY RECORD X,REC_NOT_GAP GRANTED 6
81 PRIMARY RECORD X,REC_NOT_GAP GRANTED 8
82 ROLLBACK;
83 CREATE TABLE t2(a INT NOT NULL PRIMARY KEY, b INT NOT NULL UNIQUE);
84 INSERT INTO t2 (a,b) VALUES
85 (1,10), (2,20), (3,30), (4,40), (5,50), (6,60), (8,80), (10,100);
86 CREATE TABLE tt (i INT) ENGINE = InnoDB;
87 CREATE TRIGGER t2_bi BEFORE INSERT ON t2
88 FOR EACH ROW
89 INSERT INTO tt SELECT a as i FROM t2 WHERE a=10000;
90 BEGIN;
91 REPLACE INTO t2 (a,b) VALUES (2,13);
92 INSERT INTO t2 (a,b) VALUES (4,43) ON DUPLICATE KEY UPDATE b=43;
93 REPLACE INTO t2 (a,b) VALUES (7,60);
94 INSERT INTO t2 (a,b) VALUES (9,80) ON DUPLICATE KEY UPDATE a=9;
95 SELECT index_name,lock_type,lock_mode,lock_status,lock_data
96 FROM performance_schema.data_locks
97 WHERE object_schema='test' AND object_name = 't2'
98 ORDER BY 1,2,3,4,5;
99 index_name lock_type lock_mode lock_status lock_data
100 NULL TABLE IS GRANTED NULL
101 NULL TABLE IX GRANTED NULL
102 b RECORD X GRANTED 100, 10
103 b RECORD X GRANTED 60, 6
104 b RECORD X GRANTED 80, 8
105 b RECORD X,GAP GRANTED 60, 7
106 b RECORD X,GAP GRANTED 80, 9
107 PRIMARY RECORD S GRANTED supremum pseudo-record
108 PRIMARY RECORD X,GAP GRANTED 10
109 PRIMARY RECORD X,GAP GRANTED 7
110 PRIMARY RECORD X,GAP GRANTED 8
111 PRIMARY RECORD X,GAP GRANTED 9
112 PRIMARY RECORD X,REC_NOT_GAP GRANTED 2
113 PRIMARY RECORD X,REC_NOT_GAP GRANTED 4
114 PRIMARY RECORD X,REC_NOT_GAP GRANTED 6
115 PRIMARY RECORD X,REC_NOT_GAP GRANTED 8
116 ROLLBACK;
117 DROP TRIGGER t2_bi;
118 DROP TABLE tt;
119 DROP TABLE t2;
120 DROP TABLE t1;