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

Calcite. Explain failed for subquery expression.

    XMLWordPrintableJSON

    Details

    • Ignite Flags:
      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: