Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2455

Partial results for a query when PHOENIX-2194 is applied

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.7.0
    • Component/s: None
    • Labels:
      None

      Description

      Hi James Taylor,

      can you please look into the below test case, why it is failing after applying PHOENIX-2194

      drop table test;
      CREATE TABLE IF NOT EXISTS Test
       (col1 VARCHAR,  
       col2 VARCHAR,  
       col3 VARCHAR,  
       col4 UNSIGNED_LONG NOT NULL,   
       CONSTRAINT pk  
       PRIMARY KEY (col1,col2,col3,col4));
      
      upsert into test values('a','b','',1);
      upsert into test values('e.f','b','',1);
      upsert into test values('f.g','b','',1);
      upsert into test values('g.h','b','',1);
      upsert into test values('f','b','',1);
      upsert into test values('h.e','b','',1);
      
      
      SELECT  col1, col2, col3, col4 FROM test WHERE (col1 IN ('a','e','f','g','h')) AND col2 = 'b' AND col4 >= 0 AND col4 < 2 ;
      
      

      expected(AND getting without PHOENIX-2194);-

      COL1 COL2 COL3 COL4
      a b   1
      f b   1

      Getting with PHOENIX-2194(Which is partial).

      COL1 COL2 COL3 COL4
      a b   1

        Attachments

        1. PHOENIX-2455_UT.patch
          2 kB
          Ankit Singhal
        2. PHOENIX-2455.patch
          14 kB
          James R. Taylor

          Issue Links

            Activity

              People

              • Assignee:
                jamestaylor James R. Taylor
                Reporter:
                ankit.singhal Ankit Singhal
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: