imodel-native
imodel-native copied to clipboard
ECSQL does not support using VALUES(...),(...) in CTE's
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').