I’d be surprised if a query of that shape is sufficient to reproduce the case. So the problem is with your schema. But your “schema” doesn’t look like something that would fit into a Calcite JSON model file.
If you can come up with a reproducible test case, you should log a jira case. > On Oct 13, 2022, at 1:13 PM, Rishabh Kedia <[email protected]> wrote: > > Hello, > > I have a simple query using "WITH" clause: > "WITH tempTable AS (SELECT * FROM PCOLLECTION WHERE > PCOLLECTION.`user_info`.`name` = 'User1') SELECT * FROM tempTable" > > and schema such as: > { > "doc":"More information on the user", > "name":"user_info", > "type":["null", "user_info"], > "default":null > } > > > This query was running properly with Calcite 1.20. But after upgrade to > Calcite 1.31, the above query is failing with the error: > "java.lang.AssertionError: fieldList must not be null, type = VARCHAR" > > I looked through the code but couldnt find a reasonable explanation. Any > idea what could be wrong? > > Thanks, > Rishabh Kedia
