[jira] [Created] (CALCITE-5310) JSON_OBJECT in scalar sub-query throws AssertionError

Benchao Li created CALCITE-5310: --- Summary: JSON_OBJECT in scalar sub-query throws AssertionError Key: CALCITE-5310 URL: https://issues.apache.org/jira/browse/CALCITE-5310 Project: Calcite

Re: Infix cast precedence

Thanks for checking, Itiel. The only other thing to check is whether “-1” is parsed as a single numeric literal or as unary “-“ applied to the numeric literal “1”. I don’t recall what Calcite does. > On Oct 5, 2022, at 3:43 AM, Itiel Sadeh wrote: > > From the following operator precedence

Re: JSON Array as table using ScannableTable

Hi Calcite Devs, I am able to query(basic query = "select * from tableFromJsonArr") JSON array as a table, But RelDataType is fixed in this scenario, but I am looking for dynamic RelDataType, which works for all kinds of JsonArray (JSON Array of books/employee or anything etc). I will post if I

[jira] [Created] (CALCITE-5309) Accept cursors as inputs of table functions

Bertil Chapuis created CALCITE-5309: --- Summary: Accept cursors as inputs of table functions Key: CALCITE-5309 URL: https://issues.apache.org/jira/browse/CALCITE-5309 Project: Calcite Issue

Re: Infix cast precedence

>From the following operator precedence table: https://www.postgresql.org/docs/14/sql-syntax-lexical.html#SQL-PRECEDENCE , it looks like Calcite is consistent with Postgresql. Thanks for the response. On Wed, Oct 5, 2022 at 6:52 AM Julian Hyde wrote: > Infix cast comes from Postgres. Can