[
https://issues.apache.org/jira/browse/PHOENIX-2137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14681554#comment-14681554
]
Hudson commented on PHOENIX-2137:
---------------------------------
SUCCESS: Integrated in Phoenix-master #871 (See
[https://builds.apache.org/job/Phoenix-master/871/])
PHOENIX-2137 Range query on DECIMAL DESC sometimes incorrect (jtaylor: rev
5330c0794e143014f5bd67114e3fc87c53015789)
*
phoenix-core/src/test/java/org/apache/phoenix/expression/SortOrderExpressionTest.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/WhereOptimizerTest.java
*
phoenix-core/src/main/java/org/apache/phoenix/execute/DescVarLengthFastByteComparisons.java
* phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/filter/SkipScanFilter.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java
* phoenix-core/src/main/java/org/apache/phoenix/query/KeyRange.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/types/PDataType.java
* phoenix-core/src/main/java/org/apache/phoenix/util/SchemaUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/ScanRanges.java
*
phoenix-core/src/test/java/org/apache/phoenix/execute/DescVarLengthFastByteComparisonsTest.java
> Range query on DECIMAL DESC sometimes incorrect
> -----------------------------------------------
>
> Key: PHOENIX-2137
> URL: https://issues.apache.org/jira/browse/PHOENIX-2137
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: James Taylor
> Attachments: PHOENIX-2137.patch, PHOENIX-2137_v2.patch,
> PHOENIX-2137_wip.patch
>
>
> The following scenario is not working correctly:
> {code}
> create table t (k1 bigint not null, k2 decimal, constraint pk primary key
> (k1,k2 desc));
> upsert into t values(1,1.01);
> upsert into t values(2,1.001);
> select * from t where k2>1.0; -- No rows, but should be both rows
> select * from t where k1 in (1,2) and k2>1.0; -- Same problem
> {code}
> The following queries do return the correct results:
> {code}
> select * from t where k2>1.0001;
> select * from t where k1 in (1,2) and k2>1.0001;
> {code}
> Note also that without the DESC declaration of k2, everything works fine.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
