[MDEV-29408] Calculation error in recent version of MariaDB test with 10.8-10.9-10.10 Created: 2022-08-29  Updated: 2022-10-18  Resolved: 2022-10-18

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.8.4, 10.9.2, 10.10.1, 10.6, 10.7, 10.8, 10.9
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: BENLAGHA Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows 11, Windows Server 2019

Attachments: File database exemple.sql     File sql exemple.sql     JPEG File test with mariadb 10.10.1.jpg     JPEG File test with mariadb 10.4.18.jpg    
Issue Links:
Duplicate
duplicates MDEV-27745 order by with incremented variable be... Closed

 Description   

Hello,

We found a calculation error in the recent version of MariaDB the problem does not arise in version 10.4.18

 Comments   
Comment by BENLAGHA [ 2022-10-14 ]

any verification?!!!!

Comment by Alice Sherepa [ 2022-10-14 ]

Sorry for the long time without response.
I repeated on MariaDB 10.6-10.10 and this is the case, that is described here - MDEV-27745.
query plan on 10.6+:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
 
1	PRIMARY	<derived2>	ALL	NULL	NULL	NULL	NULL	23	100.00	Using temporary; Using filesort
 
2	DERIVED	t1	ALL	NULL	NULL	NULL	NULL	1	100.00	Using where
 
3	UNCACHEABLE UNION	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE
 
4	UNION	t3	ALL	mov,d1,codetier	NULL	NULL	NULL	14	80.07	Using where
 
5	UNION	t2	ALL	d1,etat,codetier	NULL	NULL	NULL	14	80.07	Using where
 
NULL	UNION RESULT	<union2,3,4,5>	ALL	NULL	NULL	NULL	NULL	NULL	NULL

query plan before 10.6:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
 
1	PRIMARY	<derived2>	ALL	NULL	NULL	NULL	NULL	27	100.00	Using filesort
 
2	DERIVED	t1	ALL	NULL	NULL	NULL	NULL	1	100.00	Using where
 
3	UNCACHEABLE UNION	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE
 
4	UNION	t3	ALL	mov,d1,codetier	NULL	NULL	NULL	13	100.00	Using where
 
5	UNION	t2	ALL	d1,etat,codetier	NULL	NULL	NULL	13	100.00	Using where
 
NULL	UNION RESULT	<union2,3,4,5>	ALL	NULL	NULL	NULL	NULL	NULL	NULL

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