[
https://issues.apache.org/jira/browse/PHOENIX-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14721884#comment-14721884
]
Hudson commented on PHOENIX-2206:
---------------------------------
SUCCESS: Integrated in Phoenix-master #884 (See
[https://builds.apache.org/job/Phoenix-master/884/])
PHOENIX-2206 Math function called with PK column ignores WHERE clause (jtaylor:
rev da37b9dacd071ad6afc044602cbef56c21d62033)
* phoenix-core/src/test/java/org/apache/phoenix/compile/WhereOptimizerTest.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ExpFunctionEnd2EndIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereOptimizer.java
> Math function called with PK column ignores WHERE clause
> --------------------------------------------------------
>
> Key: PHOENIX-2206
> URL: https://issues.apache.org/jira/browse/PHOENIX-2206
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.5.0
> Reporter: ckran
> Assignee: James Taylor
> Priority: Minor
> Labels: exp, filter
> Fix For: 4.6.0, 4.5.2
>
> Attachments: PHOENIX-2206.patch, PHOENIX-2206_v2.patch
>
>
> A WHERE condition that uses a scalar function such as EXP is ignored and all
> rows are returned.
> create table test (id integer primary key) ;
> upsert into test values (1) ;
> upsert into test values (2) ;
> upsert into test values (3) ;
> upsert into test values (4) ;
> upsert into test values (5) ;
> select ID, exp(ID) from test where exp(ID) < 10 ;
> Result is:
> 1 2.718281828459045
> 2 7.38905609893065
> 3 20.085536923187668
> 4 54.598150033144236
> 5 148.4131591025766
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
