fakesnow icon indicating copy to clipboard operation
fakesnow copied to clipboard

Issue: FROM table() raises unexpected error

Open greenmtnboy opened this issue 9 months ago • 1 comments

SELECT
   "zeta"
FROM
   table(flatten(ARRAY_CONSTRUCT(1, 2, 3, 4))) as unnest_wrapper ( unnest1, unnest2, unnest3, unnest4, "zeta")

raises a "Parser Error: syntax error at or near "TABLE", but appears to run properly in snowflake.

Wanted to first confirm it's actually an issue, then happy to take look at a fix.

greenmtnboy avatar Mar 20 '25 11:03 greenmtnboy

Thanks for raising this, and yes if it runs in snowflake and not fakesnow its an issue.

tekumara avatar Mar 20 '25 23:03 tekumara