Egor,
What's the Calcite version are you using?
I tried your code in 1.30.0 and 1.31.0, they both work fine.
Egor Ryashin 于2022年8月17日周三 22:40写道:
> Hi all,
>
> I’m trying to figure out why this conversion fails:
>
> WITH `A` AS (SELECT `TABLE_NAME`
> FROM `main`.`TABLES`), `B` AS (SELECT 'k' AS
Thomas D'Silva created CALCITE-5240:
---
Summary: Enhance MaterializedViewRule so that it applies to rollup
view for queries that contain a predicate on the rollup column
Key: CALCITE-5240
URL: https://issues.apach
Hi all,
I’m trying to figure out why this conversion fails:
WITH `A` AS (SELECT `TABLE_NAME`
FROM `main`.`TABLES`), `B` AS (SELECT 'k' AS `K`) (SELECT *
FROM `A`
INNER JOIN `B` ON `A`.`TABLE_NAME` = `B`.`K`)
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index 1 out of
bounds fo
Sorry, it was a bad wording.
The question was specifically about identifiers that *starts* with a dollar
sign, such as "$jk".
On Tue, Aug 16, 2022 at 9:53 PM Julian Hyde wrote:
> Probably a documentation mistake. Many databases allow ‘$’ and ‘#’ in
> identifiers. For example the following work o