The select result is incorrect

Reproduce step:

docker run --restart=always --name mariadb -p 3318:3306 -e MYSQL_ROOT_PASSWORD=123456 -d quay.io/mariadb-foundation/mariadb-devel:latest-lts

And then in mariadb,

create database test;

use test;

source init_tables.sql;

first execution run the SQL query in select_query.sql

second execution run

SET Global range_alloc_block_size = 4096;SET Session join_buffer_size = 128;SET Session max_error_count = 65535;

and the SQL query in select_query.sql

You will find that the results of the two runs are completely different.