wren-engine icon indicating copy to clipboard operation
wren-engine copied to clipboard

Use same model name in with cte

Open brandboat opened this issue 1 year ago • 0 comments

https://github.com/Canner/canner-metric-layer/pull/192#discussion_r1148859939

The following query currently has an issue because we generate another name called "Book" with CTE (Common Table Expression), which duplicates the name used in the query.

WITH Book AS (SELECT * FROM Book) SELECT name FROM Book

brandboat avatar Mar 27 '23 08:03 brandboat