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

select on a composite primary key fails when DESC is set in the table

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.7.0
    • Fix Version/s: 4.8.0
    • Labels:
    • Environment:

      linux ubuntu 14.0.4.4
      phoenix-4.7.0-HBase-0.98-client
      HBase Version 0.98.19

      Description

      I created a table with a primary key composed of 4 fields. The table specifies DESC for one of those fields (please see the test script provided). When the table is queried using any combination of 3 of the primary key fields, it selects rows correctly. However, when all 4 fields are specified, no rows are selected. Here is the sql script that reproduces this issue:

      ----------------------------------------------------------------

      CREATE TABLE IF NOT EXISTS tests1 (
      ACCOUNT_ID VARCHAR NOT NULL,
      BUCKET_ID VARCHAR NOT NULL,
      OBJECT_ID VARCHAR NOT NULL,
      OBJECT_VERSION VARCHAR NOT NULL,
      LOC VARCHAR,
      CONSTRAINT PK PRIMARY KEY (ACCOUNT_ID, BUCKET_ID, OBJECT_ID, OBJECT_VERSION DESC));

      UPSERT INTO tests1 (ACCOUNT_ID, BUCKET_ID, OBJECT_ID, OBJECT_VERSION, LOC) VALUES ('acct1', 'bucket1', 'obj1', '1111', 'loc1');

      select ACCOUNT_ID, BUCKET_ID, OBJECT_VERSION from tests1 WHERE ACCOUNT_ID = 'acct1' and BUCKET_ID = 'bucket1' and OBJECT_VERSION = '1111';

      select ACCOUNT_ID, BUCKET_ID, OBJECT_VERSION from tests1 WHERE ACCOUNT_ID = 'acct1' and BUCKET_ID = 'bucket1' and OBJECT_ID = 'obj1';

      select ACCOUNT_ID, BUCKET_ID, OBJECT_VERSION from tests1 WHERE ACCOUNT_ID = 'acct1' and BUCKET_ID = 'bucket1' and OBJECT_VERSION = '1111' and OBJECT_ID = 'obj1';

      ----------------------------------------------

      The first two select statements selects the row that was inserted, whereas the third one fails to select any rows.

        Attachments

        1. test2.sql
          2 kB
          Dhiraj Hegde
        2. test1.sql
          0.8 kB
          Dhiraj Hegde
        3. PHOENIX-2961.patch
          5 kB
          James Taylor

          Activity

            People

            • Assignee:
              jamestaylor James Taylor
              Reporter:
              dhegde@salesforce.com Dhiraj Hegde
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: