Debian Codegraph @

mysql-test/suite/gcol/t/innodb_partition.test

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