[
https://issues.apache.org/jira/browse/IGNITE-13457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich reassigned IGNITE-13457:
------------------------------------------
Assignee: Stanilovsky Evgeny
> Calcite integration. Join returns partial resultset.
> ----------------------------------------------------
>
> Key: IGNITE-13457
> URL: https://issues.apache.org/jira/browse/IGNITE-13457
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.8.1
> Reporter: Stanilovsky Evgeny
> Assignee: Stanilovsky Evgeny
> Priority: Major
> Attachments: BenchmarkCalcite.java
>
>
> Check example attached, shortly, two simple caches :
> {noformat}
> /** */
> public static class MyClass {
> /** */
> @QuerySqlField
> public String name;
> /** */
> @QuerySqlField
> @AffinityKeyMapped
> public Integer amount;
> ...
> }
> /** */
> public static class MyClass2 {
> /** */
> @QuerySqlField
> public String name;
> /** */
> @QuerySqlField
> @AffinityKeyMapped
> public Integer amount2;
> ....
> }
> IgniteCache<Integer, MyClass> cache1 = ignite.getOrCreateCache(new
> CacheConfiguration<Integer, MyClass>()
> .setName("tbl1")
> .setSqlSchema("PUBLIC")
> .setQueryEntities(F.asList(new QueryEntity(Integer.class,
> MyClass.class).setTableName("TBL1")))
> .setBackups(1)
> );
> IgniteCache<Integer, MyClass2> cache2 = ignite.getOrCreateCache(new
> CacheConfiguration<Integer, MyClass2>()
> .setName("tbl2")
> .setSqlSchema("PUBLIC")
> .setQueryEntities(F.asList(new QueryEntity(Integer.class,
> MyClass2.class).setTableName("TBL2")))
> .setBackups(1)
> );
> {noformat}
> and further request : *select * from TBL1 t1 LEFT JOIN TBL2 t2 ON t1.amount =
> t2.amount2* returns : 9216 results with calcite engine and correctly 10000
> with H2.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
