[jira] [Created] (IGNITE-13457) Calcite integration. Join returns partial resultset.

["Stanilovsky Evgeny (Jira)" <ji...@apache.org>]

Stanilovsky Evgeny created IGNITE-13457:
-------------------------------------------

             Summary: 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
         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)