Multiple CTEs with the same name can cause incorrect results

[fulghum]

CTEs with the same name, in different scopes can cause incorrect query results.

Consider the following statement with two CTEs at different scopes, both named cte:

WITH cte(id) AS (
	SELECT 0 from dual
)
SELECT cte.id  
FROM cte
where cte.id in (
	WITH cte(id)
	AS (
		SELECT 42 from dual
	)
	select id from cte
);

MySQL returns:

Empty set (0.01 sec)

Dolt returns:

+----+
| id |
+----+
| 42 |
+----+
1 row in set (0.00 sec)

Dolt doesn't seem to correctly distinguish between the two CTEs with the same name.

Changing the name of the second CTE, as in the statement below, causes Dolt to return the same result as MySQL:

WITH cte(id) AS (
	SELECT 0 from dual
)
SELECT cte.id  
FROM cte
where cte.id in (
	WITH cte2(id)
	AS (
		SELECT 42 from dual
	)
	select id from cte2
);

[jycor]

fix is merged to main