[I] Calcite engine do not return expected results in some cases [ignite]

["bgaraude (via GitHub)" <gi...@apache.org>]

bgaraude opened a new issue, #11941:
URL: https://github.com/apache/ignite/issues/11941

   I've tried to migrate from H2 to Calcite as SqlEngine on ignite 2.17.0
   
   Some queries we do (either through jdbc or SqlFieldQuery) are returning empty result set when using Calcite.
   
   This seem to happen when there are joins on key fields, and a where clause on the joined entity key field. It also seem to happen when the key types on the FROM and JOIN entity do not have the same field number.
   
   You can find a small reproducer on this gist:
   https://gist.github.com/bgaraude/db96718b24eae56e764452163be67018
   
   As you can see in the above gist, when the where clause is B.id = ?, it returns nothing. But rewriting the where clause as "B.id = concat(?)" or "B.id like ?", then it works (the bound parameter is the string "a" in the example).
   
   Is this a known issue? Am I doing something wrong?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@ignite.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org