1# We should not run this test with embedded as we are using
2# max_session_mem_used, which causes things to fail/not fail randomly
3# as memory usage is different compared to normal server.
4
5--source include/not_embedded.inc
6
7#
8# MDEV-11539 test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S
9#
10CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
11INSERT t1 VALUES (1);
12LOCK TABLE t1 WRITE;
13REPAIR TABLE t1;
14--disable_result_log
15SELECT * FROM INFORMATION_SCHEMA.TABLES;
16--enable_result_log
17SELECT * FROM t1;
18UNLOCK TABLES;
19DROP TABLE t1;
20
21CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
22INSERT t1 VALUES (1);
23LOCK TABLE t1 WRITE;
24OPTIMIZE TABLE t1;
25--disable_result_log
26SELECT * FROM INFORMATION_SCHEMA.TABLES;
27--enable_result_log
28SELECT * FROM t1;
29UNLOCK TABLES;
30DROP TABLE t1;
31
32--echo #
33--echo # MDEV-23824 SIGSEGV in end_io_cache on REPAIR LOCAL TABLE for Aria table
34--echo #
35
36CREATE TABLE t1 (i INT) ENGINE=Aria;
37INSERT INTO t1 VALUES (1);
38SET max_session_mem_used=50000;
39--disable_result_log
40REPAIR LOCAL TABLE t1 USE_FRM;
41REPAIR LOCAL TABLE t1;
42--enable_result_log
43DROP TABLE t1;
44