diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-04 18:00:34 +0000 |
commit | 3f619478f796eddbba6e39502fe941b285dd97b1 (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/main/large_pages.test | |
parent | Initial commit. (diff) | |
download | mariadb-upstream.tar.xz mariadb-upstream.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/main/large_pages.test')
-rw-r--r-- | mysql-test/main/large_pages.test | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/main/large_pages.test b/mysql-test/main/large_pages.test new file mode 100644 index 00000000..136273a2 --- /dev/null +++ b/mysql-test/main/large_pages.test @@ -0,0 +1,38 @@ +# Test of large pages (or at least the fallback to conventional allocation) + +# Windows needs SeLockMemoryPrivilege +--source include/not_windows.inc +--source include/have_innodb.inc + +call mtr.add_suppression("\\[Warning\\] (mysqld|mariadbd): Couldn't allocate [0-9]+ bytes \\((Large/HugeTLB memory|MEMLOCK) page size [0-9]+\\).*"); + +create table t1 ( + a int not null auto_increment, + b char(16) not null, + primary key (a), + key (b) +); + +create table t2( + a int not null auto_increment, + b char(16) not null, + primary key (a), + key (b) +); + +insert into t1(b) values + ('test0'), + ('test1'), + ('test2'), + ('test3'), + ('test4'), + ('test5'), + ('test6'), + ('test7'); + +insert into t2(b) select b from t1; +insert into t1(b) select b from t2; + +select * from t1 join t2 using (b) ORDER BY t1.a, t2.a; + +drop table t1, t2; |