Debian Codegraph @

mysql-test/suite/gcol/r/innodb_partition.result

raw
1 #
2 # Bug#22444530 - GCOLS + PARTITIONED TABLE, CRASH IN
3 #
4 set sql_mode='';
5 create table t (
6 a int not null,
7 b int generated always as (1) virtual,
8 c int generated always as (1) virtual,
9 key (c)
10 ) engine=innodb partition by key (a) partitions 2;
11 insert into t(a) values(1);
12 select b from t group by c;
13 b
14 1
15 drop table t;
16 create table t (
17 a int not null,
18 b blob generated always as ("a") virtual,
19 c int generated always as (1) virtual,
20 key (c)
21 ) engine=innodb partition by key (a) partitions 2;
22 insert into t(a) values(1);
23 select b from t group by c;
24 b
25 a
26 drop table t;