imodel-native icon indicating copy to clipboard operation
imodel-native copied to clipboard

ECSQL does not support using VALUES(...),(...) in CTE's

Open JonasDov opened this issue 1 year ago • 0 comments

Steps to reproduce

Running the following:

WITH TestCte(x) AS (VALUES('a'), ('b')) SELECT * FROM TestCte

Results in parse error.

However, when using VALUES(...),(...) not inside CTE, it works. For example:

SELECT * FROM (values('a'),('b'))

Is parsed to SELECT [K0] FROM (SELECT 'a' [K0] UNION ALL SELECT 'b').

JonasDov avatar Oct 22 '24 08:10 JonasDov