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

SQL: Except returns incorrect results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 1.8
    • 1.8
    • sql
    • None

    Description

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

      Returns all keys even though some are present in both tables.

      This is CacheLinqTest.TestExcept 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

              al.psc Alexander Paschenko
              ptupitsyn Pavel Tupitsyn
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: