Re: [DISCUSS] WithItem query parentheses

Thanks Julian for your nice guidance, I logged this bug onto CALCITE-5185 , and I will go to any lengths to fix it soon. Julian Hyde 于2022年6月7日周二 22:28写道： > Yes. The parentheses are required for correctness. Please log a bug. > > While you’re

Re: [DISCUSS] WithItem query parentheses

Yes. The parentheses are required for correctness. Please log a bug. While you’re there, it would be nice if there were a line break after each CTE. (Including if there are multiple CTEs.) Maybe the fix can address that too. Julian > On Jun 7, 2022, at 05:19, Yanjing Wang wrote: > > Hi co

[DISCUSS] WithItem query parentheses

Hi community, the test follows @Test void testWithUnion2() { // Per the standard WITH ... SELECT ... UNION is valid even without parens. final String sql = "with emp2 as (select * from emp union all select * from emp)\n" + "select * from emp2\n" + "union\n" + "sel