summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/parts/t/partition_alter_maria.test
blob: e0b9256391d4fd24c5644d7f0f2ca7ea1952d51d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
#
# MDEV-13937 Aria engine: Internal Error 160 after partition handling 
#
source include/have_partition.inc;
create table t1 (
  pk bigint not null auto_increment,
  dt datetime default null,
  unique (pk, dt)
) engine=aria row_format=dynamic
  partition by range  columns(dt) (
    partition `p20171231` values less than ('2017-12-31'),
    partition `p20181231` values less than ('2018-12-31')
);
insert into t1 values (1,'2017-09-28 15:12:00');
select * from t1;
alter table t1 drop partition p20181231;
select * from t1;
drop table t1;

#
# MDEV-13982 Server crashes in in ha_partition::engine_name
#
create table t1 (a int) engine=Aria transactional=1 partition by hash(a) partitions 2;
show create table t1;
drop table t1;

--let $engine=Aria
--source inc/part_alter_values.inc