[#MDEV-20330] Combination of "," (comma), cross join and left join fails to parse (regression since 10.1.40)

[MDEV-20330] Combination of "," (comma), cross join and left join fails to parse (regression since 10.1.40) Created: 2019-08-12 Updated: 2021-11-26 Resolved: 2019-08-20
Status:	Closed
Project:	MariaDB Server
Component/s:	Parser
Affects Version/s:	10.2.26, 5.5.65, 10.1.41, 10.3.17, 10.4.7
Fix Version/s:	10.2.27, 5.5.66, 10.1.42, 10.3.18, 10.4.8

Type:

Bug

Priority:

Critical

Reporter:

Bob Weinand

Assignee:

Igor Babaev

Resolution:

Fixed

Votes:

Labels:

regression

Environment:

Ubuntu

Issue Links:

Blocks
Duplicate
duplicates	~~MDEV-20265~~	Unknown column in field list	Closed
Problem/Incident
is caused by	~~MDEV-19421~~	Basic 3-way join queries are not parsed	Closed

Description

SELECT a.a FROM (SELECT 1 AS a) a, (SELECT 2 AS b) b CROSS JOIN (SELECT 3 AS c) c LEFT JOIN (SELECT 4 AS d) d ON 1

MariaDB 10.1.41 complains with:
#1054 - Unknown column 'a.a' in 'field list'

This was working perfectly with version 10.1.40.

Comments

Comment by Elena Stepanova [ 2019-08-12 ]

Introduced by 8540fa83bb34df6a3d489a4e85c77692f36e3e26.

Comment by Igor Babaev [ 2019-08-20 ]

This bug was fixed by the patch for ~~MDEV-20265~~.

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