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

SQL: Intersect with subquery returns no results

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8
    • Component/s: sql
    • Labels:
      None

      Description

      Whole entry intersect works:

      select _T0._key, _T0._val from "".Person as _T0 intersect (select _T1._key, _T1._val from "person_cache".Person as _T1)
      

      but subquery intersect does not:

      select _T0._key from "".Person as _T0 intersect (select _T1._foo from "role_cache".Role as _T1)
      

      This is CacheLinqTest.TestIntersect in "Ignite Platform .NET" suite. Works in master, does not work in ignite-1.8 after DML merge.

      Models:

      CREATE MEMORY TABLE "".PERSON(
          _KEY INT NOT NULL,
          _VAL OTHER,
          AGE1 INT,
          NAME VARCHAR,
          ADDRESS OTHER,
          ZIP INT,
          STREET VARCHAR,
          ADDR_ALIASTEST INT,
          ORGANIZATIONID INT,
          BIRTHDAY TIMESTAMP,
          PERSON_ALIASTEST INT
      )
      
      CREATE MEMORY TABLE "role_cache".ROLE(
          _KEY OTHER NOT NULL,
          _VAL OTHER,
          _FOO INT,
          _BAR BIGINT,
          NAME VARCHAR,
          DATE TIMESTAMP
      )
      
      CREATE MEMORY TABLE "person_cache".PERSON(
          _KEY INT NOT NULL,
          _VAL OTHER,
          AGE1 INT,
          NAME VARCHAR,
          ADDRESS OTHER,
          ZIP INT,
          STREET VARCHAR,
          ALIASTEST INT,
          ORGANIZATIONID INT,
          BIRTHDAY TIMESTAMP
      )
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                al.psc Alexander Paschenko
                Reporter:
                ptupitsyn Pavel Tupitsyn
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: