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