Re: Beam SQL Alias issue while using With Clause

2023-01-27 Thread Talat Uyarer via user
Hi Andrew, Yes This aligned also with my debugging. In My Kenn's reply you can see a sql test which I wrote in Calcite. Somehow Calcite does not have this issue with the 1.28 version. !use post !set outputformat mysql #Test aliases with with clause WITH tempTable(id, v) AS (select "hr"."emps"."e

Re: Beam SQL Alias issue while using With Clause

2023-01-27 Thread Andrew Pilloud via user
Hi Talat, I did get your test case running and added some logging to RexProgramBuilder.mergePrograms. There is only one merge that occurs during the test and it has an output type of RecordType(JavaType(int) ID, JavaType(class java.lang.String) V). This does seem like the correct output name but i

Re: Beam SQL Alias issue while using With Clause

2023-01-27 Thread Andrew Pilloud via user
Also this is at very least a Beam bug. You can file a Beam issue if you want, otherwise I will when I get back. Andrew On Fri, Jan 27, 2023 at 11:27 AM Andrew Pilloud wrote: > Hi Talat, > > I did get your test case running and added some logging to > RexProgramBuilder.mergePrograms. There is on