Debian Codegraph @

mysql-test/suite/vcol/r/index.result

raw
1 #
2 # Test table with a key that consists of indirect virtual fields
3 #
4 CREATE TABLE t1 (a int, b int as (a+1) virtual, c int as (b+1) virtual, index(c)) engine=myisam;
5 insert into t1 (a) values (1),(2),(3);
6 update t1 set a=5 where a=3;
7 delete from t1 where a=1;
8 select * from t1;
9 a b c
10 2 3 4
11 5 6 7
12 select * from t1 where c=7;
13 a b c
14 5 6 7
15 check table t1;
16 Table Op Msg_type Msg_text
17 test.t1 check status OK
18 select * from t1;
19 a b c
20 2 3 4
21 5 6 7
22 drop table t1;
23 CREATE TABLE t1 (a int, b int as (a+1) virtual, c int as (b+1) virtual, index(c)) engine=innodb;
24 insert into t1 (a) values (1),(2),(3);
25 update t1 set a=5 where a=3;
26 delete from t1 where a=1;
27 select * from t1;
28 a b c
29 2 3 4
30 5 6 7
31 select * from t1 where c=7;
32 a b c
33 5 6 7
34 check table t1;
35 Table Op Msg_type Msg_text
36 test.t1 check status OK
37 select * from t1;
38 a b c
39 2 3 4
40 5 6 7
41 drop table t1;
42 #
43 # MDEV-15114
44 # ASAN heap-use-after-free in mem_heap_dup or
45 # dfield_data_is_binary_equal
46 #
47 CREATE TABLE t1 (
48 pk INT,
49 extra tinyint,
50 c TEXT,
51 vc LONGTEXT AS (c) VIRTUAL,
52 i INT,
53 PRIMARY KEY(pk),
54 UNIQUE(i),
55 INDEX(vc(64))
56 ) ENGINE=InnoDB;
57 INSERT INTO t1 (pk,extra, c, i) VALUES (1, 10, REPEAT('foo ',15000),0);
58 REPLACE INTO t1 (pk,extra, c,i) SELECT pk,extra+10, c,i FROM t1;
59 select pk, extra, left(c, 10), length(c), left(vc,10), length(vc), extra from t1;
60 pk extra left(c, 10) length(c) left(vc,10) length(vc) extra
61 1 20 foo foo fo 60000 foo foo fo 60000 20
62 DROP TABLE t1;
63 #
64 # Update of deleted row with binary logging enabled
65 #
66 SET BINLOG_FORMAT=row;
67 CREATE TABLE t1 (
68 pk INT,
69 c TEXT,
70 vc LONGTEXT AS (c) VIRTUAL,
71 i INT,
72 PRIMARY KEY(pk),
73 UNIQUE(i),
74 INDEX(vc(64))
75 ) ENGINE=InnoDB;
76 INSERT INTO t1 (pk,c,i) VALUES (1,REPEAT('foo ',15000),10);
77 INSERT INTO t1 (pk,c,i) VALUES (2,REPEAT('bar ',15000),11);
78 connect c1,localhost,root,,;
79 connection c1;
80 begin;
81 DELETE from t1 WHERE pk=1;
82 connection default;
83 update t1 set pk=1 where pk=2;
84 connection c1;
85 commit;
86 connection default;
87 select pk, left(c, 10), length(c), i from t1;
88 pk left(c, 10) length(c) i
89 1 bar bar ba 60000 11
90 drop table t1;
91 disconnect c1;
92 CREATE TABLE t1 (b BLOB, vb TEXT AS (b) PERSISTENT, KEY(vb(64))) ENGINE=InnoDB;
93 INSERT INTO t1 (b) VALUES ('foo');
94 connect con1,localhost,root,,test;
95 CREATE TABLE t2 LIKE t1;
96 connection default;
97 DELETE FROM t1;
98 connection con1;
99 disconnect con1;
100 connection default;
101 DROP TABLE t1, t2;