[IGNITE-13457] Calcite integration. Join returns partial resultset.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.8.1
• Component/s: sql
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 17/Sep/20 13:13
• Updated: 21/Sep/20 08:10
• Resolved: 21/Sep/20 06:07

Description

Check example attached, shortly, two simple caches :

    /** */
    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)
        );

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.

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine