[ https://issues.apache.org/jira/browse/PHOENIX-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14720379#comment-14720379 ]
Thomas D'Silva commented on PHOENIX-2206: ----------------------------------------- +1 > 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 > 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)