[MDEV-27072] Subquery using the ALL keyword on date columns produces a wrong result - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.48, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6
Component/s: Data Manipulation - Subquery
Labels:
None
Environment:
Linux - Ubuntu 18.04

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

Attachments

Issue Links

relates to

MDEV-27098 Subquery using the ALL keyword on TIME columns produces a wrong result

Closed

Activity

Ascending order - Click to sort in descending order

Fabio Fioravanti created issue - 2021-11-17 18:35

Fabio Fioravanti made changes - 2021-11-17 18:36

Field	Original Value	New Value
Description	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}}	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

Fabio Fioravanti made changes - 2021-11-17 18:37

Description

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

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

Fabio Fioravanti made changes - 2021-11-17 18:38

Description

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

*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

Fabio Fioravanti made changes - 2021-11-17 18:38

Description

* 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

Fabio Fioravanti made changes - 2021-11-17 18:38

Description

* 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

*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

Fabio Fioravanti made changes - 2021-11-17 18:40

Description

*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

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

Fabio Fioravanti made changes - 2021-11-17 18:40

Summary

Subqueries using the ALL keyword on date columns produces wrong result

Subquery using the ALL keyword on date columns produces wrong result

Fabio Fioravanti made changes - 2021-11-17 18:40

Summary

Subquery using the ALL keyword on date columns produces wrong result

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

Alice Sherepa made changes - 2021-11-18 09:07

Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]
Affects Version/s		10.7 [ 24805 ]

Alice Sherepa made changes - 2021-11-18 09:08

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]

Alice Sherepa made changes - 2021-11-18 09:08

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2021-11-18 09:08

Assignee

Igor Babaev [ igor ]

Elena Stepanova made changes - 2021-11-19 23:41

Assignee

Igor Babaev [ igor ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2021-11-20 12:27

Fix Version/s		10.2.42 [ 26803 ]
Fix Version/s		10.4.23 [ 26807 ]
Fix Version/s		10.5.14 [ 26809 ]
Fix Version/s		10.6.6 [ 26811 ]
Fix Version/s		10.7.2 [ 26813 ]
Fix Version/s		10.4.24 [ 26808 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Confirmed [ 10101 ]	Closed [ 6 ]

Alexander Barkov made changes - 2021-11-20 18:40

Link

This issue relates to ~~MDEV-27098~~ [ ~~MDEV-27098~~ ]

Alexander Barkov made changes - 2021-11-20 18:40

Fix Version/s		10.2.43 [ 26804 ]
Fix Version/s		10.3.34 [ 26806 ]
Fix Version/s		10.5.15 [ 26810 ]
Fix Version/s		10.6.7 [ 26812 ]
Fix Version/s		10.7.3 [ 26814 ]
Fix Version/s	10.2.42 [ 26803 ]
Fix Version/s	10.4.23 [ 26807 ]
Fix Version/s	10.5.14 [ 26809 ]
Fix Version/s	10.6.6 [ 26811 ]
Fix Version/s	10.7.2 [ 26813 ]

Sergei Golubchik made changes - 2021-12-06 21:54

Workflow

MariaDB v3 [ 127695 ]

MariaDB v4 [ 159855 ]

Sergei Golubchik made changes - 2021-12-11 09:22

Fix Version/s		10.2.42 [ 26803 ]
Fix Version/s	10.2.43 [ 26804 ]

Sergei Golubchik made changes - 2021-12-11 09:23

Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.3.33 [ 26805 ]
Fix Version/s		10.4.23 [ 26807 ]
Fix Version/s		10.5.14 [ 26809 ]
Fix Version/s	10.3.34 [ 26806 ]
Fix Version/s	10.4.24 [ 26808 ]
Fix Version/s	10.5.15 [ 26810 ]
Fix Version/s	10.6.7 [ 26812 ]
Fix Version/s	10.7.3 [ 26814 ]

Ralf Gebhardt made changes - 2022-03-09 19:59

Fix Version/s		10.6.6 [ 26811 ]
Fix Version/s	10.6 [ 24028 ]

People

Assignee:: Alexander Barkov

Reporter:: Fabio Fioravanti

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-11-17 18:35

Updated:: 2022-03-09 19:59

Resolved:: 2021-11-20 12:27

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration