1# Test of large pages (or at least the fallback to conventional allocation)
2
3# Windows needs SeLockMemoryPrivilege
4--source include/not_windows.inc
5--source include/have_innodb.inc
6
7call mtr.add_suppression("\\[Warning\\] (mysqld|mariadbd): Couldn't allocate [0-9]+ bytes \\((Large/HugeTLB memory|MEMLOCK) page size [0-9]+\\).*");
8
9create table t1 (
10  a int not null auto_increment,
11  b char(16) not null,
12  primary key (a),
13  key (b)
14);
15
16create table t2(
17  a int not null auto_increment,
18  b char(16) not null,
19  primary key (a),
20  key (b)
21);
22
23insert into t1(b) values
24  ('test0'),
25  ('test1'),
26  ('test2'),
27  ('test3'),
28  ('test4'),
29  ('test5'),
30  ('test6'),
31  ('test7');
32
33insert into t2(b) select b from t1;
34insert into t1(b) select b from t2;
35
36select * from t1 join t2 using (b) ORDER BY t1.a, t2.a;
37
38drop table t1, t2;
39