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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.7.0
    • 4.8.0
    • None
    • 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. PHOENIX-2961.patch
          5 kB
          James R. Taylor
        2. test1.sql
          0.8 kB
          Dhiraj Hegde
        3. test2.sql
          2 kB
          Dhiraj Hegde

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment