[MDEV-27072] Subquery using the ALL keyword on date columns produces a wrong result Created: 2021-11-17  Updated: 2022-03-09  Resolved: 2021-11-20

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.1.48, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7
Fix Version/s: 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6

Type: Bug Priority: Major
Reporter: Fabio Fioravanti Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux - Ubuntu 18.04


Issue Links:
Relates
relates to MDEV-27098 Subquery using the ALL keyword on TIM... Closed

 Description   

Subquery using the ALL keyword on date columns produces a wrong result.

How to reproduce

CREATE TABLE sq1 (d DATE);
INSERT INTO sq1 VALUES ('2021-11-17'), ('2021-10-17'),('2022-11-17'), ('2020-10-17');
SELECT * FROM sq1 WHERE d >= ALL (SELECT * FROM sq1);

Result

d
------------
2021-11-17
2022-11-17

Expected result

d
--------------
2022-11-17
Generated at Thu Feb 08 09:50:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.