[MDEV-32037] The select result is incorrect Created: 2023-08-29  Updated: 2023-08-30  Resolved: 2023-08-30

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.11.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: csfuzz Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: HTML File diffres     HTML File first execution     File init_tables.sql     HTML File second execution     File select_query.sql    

 Description   

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.

 Comments   
Comment by Alice Sherepa [ 2023-08-30 ]

The query does not have ORDER BY clause, so results are not sorted. So both results are correct, simply in different order.

Generated at Thu Feb 08 10:28:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.