You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/03/06 01:57:20 UTC
[jira] [Commented] (PHOENIX-73) IN query with row value constructor
doesn't work correctly for column with DESC sort order
[ https://issues.apache.org/jira/browse/PHOENIX-73?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921793#comment-13921793 ]
Hudson commented on PHOENIX-73:
-------------------------------
FAILURE: Integrated in Apache Phoenix - Branch:4.0 #35 (See [https://builds.apache.org/job/Phoenix-4.0/35/])
PHOENIX-73 IN query with row value constructor doesn't work correctly for column with DESC sort order (JamesTaylor) (jamestaylor: rev 76274e765eed56282b98700a73afba8c20b38124)
* phoenix-core/src/main/java/org/apache/phoenix/expression/RowValueConstructorExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/iterate/ExplainTable.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/BaseExpression.java
* phoenix-core/src/test/java/org/apache/phoenix/end2end/SkipScanQueryTest.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereOptimizer.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/CoerceExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/InListExpression.java
PHOENIX-73 IN query with row value constructor doesn't work correctly for column with DESC sort order (JamesTaylor) (jamestaylor: rev ff9280e79d697757f92beb28d7bb4ecbd29c6947)
* phoenix-core/src/main/java/org/apache/phoenix/expression/InListExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereOptimizer.java
> IN query with row value constructor doesn't work correctly for column with DESC sort order
> ------------------------------------------------------------------------------------------
>
> Key: PHOENIX-73
> URL: https://issues.apache.org/jira/browse/PHOENIX-73
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 2.2.3, 3.0.0
> Reporter: Samarth
> Assignee: James Taylor
> Attachments: PHOENIX-73-2.diff, PHOENIX-73-3.diff, PHOENIX-73.diff
>
>
> Steps to reproduce:
> STEP 1
> CREATE TABLE T (
> COL1 CHAR(3),
> COL2 DATE,
> COL3 CHAR(3),
> COL4 INTEGER CONSTRAINT PK PRIMARY KEY (COL1, COL2 DESC, COL3)
> )
> Step 2:
> UPSERT INTO T (COL1, COL2, COL3) VALUES ('abc', to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S'), 'def');
> UPSERT INTO T (COL1, COL2, COL3) VALUES ('123', to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S'), '456');
> Step3:
> SELECT * FROM T WHERE COL1 = 'abc' AND COL2 = to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S') AND COL3 = 'def'
>
> - returns the expected row.
> Similarly,
> SELECT * FROM T WHERE COL1 = '123' AND COL2 = to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S') AND COL3 = '456'
> returns the expected row.
> However, the below query doesn't return any rows. It should have returned the above two rows.
> SELECT * FROM T WHERE (COL1, COL2, COL3) IN (('abc', to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S'), 'def'), ('123', to_date('2014-02-24 20:49:39.959', 'yyyy-MM-dd HH:mm:ss.S'), '456'))
> On removing DESC from the row key in CREATE TABLE statement, then the above query returns the two expected rows.
--
This message was sent by Atlassian JIRA
(v6.2#6252)