Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14713

Calcite. Explain failed for subquery expression.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • None
    • None
    • sql
    • Docs Required, Release Notes Required

    Description

      Failure test:

         @Test
          public void test0() throws Exception {
              IgniteCache<Integer, Integer> cache = grid(0).getOrCreateCache(
                  new CacheConfiguration<Integer, Integer>("test")
                      .setBackups(1)
                      .setIndexedTypes(Integer.class, Integer.class)
              );
      
              for (int i = 0; i < 100; i++)
                  cache.put(i, i);
      
              awaitPartitionMapExchange();
      
              // Correlated INNER join.
              checkQuery("explain plan for SELECT t._val FROM \"test\".Integer t WHERE t._val < 5 AND " +
                  "t._key in (SELECT x FROM table(system_range(t._val, t._val))) ")
                  .check();
      }
      

      Attachments

        Issue Links

          Activity

            People

              ivandasch Ivan Daschinsky
              zstan Evgeny Stanilovsky
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: