1CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
2INSERT t1 VALUES (1);
3LOCK TABLE t1 WRITE;
4REPAIR TABLE t1;
5Table	Op	Msg_type	Msg_text
6test.t1	repair	status	OK
7SELECT * FROM INFORMATION_SCHEMA.TABLES;
8SELECT * FROM t1;
9i
101
11UNLOCK TABLES;
12DROP TABLE t1;
13CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
14INSERT t1 VALUES (1);
15LOCK TABLE t1 WRITE;
16OPTIMIZE TABLE t1;
17Table	Op	Msg_type	Msg_text
18test.t1	optimize	status	OK
19SELECT * FROM INFORMATION_SCHEMA.TABLES;
20SELECT * FROM t1;
21i
221
23UNLOCK TABLES;
24DROP TABLE t1;
25#
26# MDEV-23824 SIGSEGV in end_io_cache on REPAIR LOCAL TABLE for Aria table
27#
28CREATE TABLE t1 (i INT) ENGINE=Aria;
29INSERT INTO t1 VALUES (1);
30SET max_session_mem_used=50000;
31REPAIR LOCAL TABLE t1 USE_FRM;
32REPAIR LOCAL TABLE t1;
33DROP TABLE t1;
34