[
https://issues.apache.org/jira/browse/PHOENIX-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15337619#comment-15337619
]
James Taylor commented on PHOENIX-2961:
---------------------------------------
[[email protected]] - can you take a look at the unit test I added based
on your scripts and see if I've missed anything
(org.apache.phoenix.end2end.HashJoinMoreIT.testBug2961 in this commit:
https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commitdiff;h=f62fc177a422ff46a14161603c3f87a6a25815d5;hp=b806645335975c8b10346eece5821a8565335504)?
Always best to send a patch with a new or updated unit test that demonstrates
the issue.
> select on a composite primary key fails when DESC is set in the table
> ---------------------------------------------------------------------
>
> Key: PHOENIX-2961
> URL: https://issues.apache.org/jira/browse/PHOENIX-2961
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Environment: linux ubuntu 14.0.4.4
> phoenix-4.7.0-HBase-0.98-client
> HBase Version 0.98.19
> Reporter: Dhiraj Hegde
> Assignee: James Taylor
> Labels: SFDC
> Fix For: 4.8.0
>
> Attachments: PHOENIX-2961.patch, test1.sql, test2.sql
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
