sql-metadata
sql-metadata copied to clipboard
When "FROM" multiple tables, the result will be different if the order is different?
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?