sql-metadata icon indicating copy to clipboard operation
sql-metadata copied to clipboard

When "FROM" multiple tables, the result will be different if the order is different?

Open roychen11232357 opened this issue 3 years ago • 0 comments

Hi there, I have 2 sqls:

SELECT aa FROM 
(SELECT bb FROM bbb  group by bb) as a, `omg`
Key Value(s)
Table names bbb
Column names aa bb omg
Subqueries names a
SELECT aa FROM 
`omg`, (SELECT bb FROM bbb  group by bb) as a
Key Value(s)
Table names omg bbb
Column names aa bb
Column aliases a

I thought the parsing results of the above two sqls would be the same, but they are actually different.

Anyone have any ideas, not sure if this is a issue?

roychen11232357 avatar Aug 05 '22 05:08 roychen11232357