You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Nicholas Whitehead (JIRA)" <ji...@apache.org> on 2015/07/27 21:09:06 UTC

[jira] [Created] (PHOENIX-2151) Two different UDFs called on same column return values from first UDF only

Nicholas Whitehead created PHOENIX-2151:
-------------------------------------------

             Summary: Two different UDFs called on same column return values from first UDF only
                 Key: PHOENIX-2151
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2151
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.4.0
         Environment: Phoenix 4.4.0
HBase 0.98_13
Java 7
Ubuntu 14.04.1 X64
            Reporter: Nicholas Whitehead
            Priority: Critical


I have defined two different UDFs, say FOO(varchar) and BAR(varchar).
If I execute a query such as:

SELECT PK, FOO(NAME), BAR(NAME) FROM USERS, I get:

===================================================
       PK              |              FOO                  |                BAR
===================================================
37546               |       <Fooed Value>         |      <Fooed Value>

If I reverse the order, I only get the Barred value (i.e. it ignores the 2nd and subsequent UDF operators)

SELECT PK, BAR(NAME), FOO(NAME) FROM USERS, I get:

===================================================
       PK              |              BAR                  |                FOO
===================================================
37546               |       <Bared Value>         |      <Bared Value>

Reproduced in plain command JDBC and Squirrel SQL.

Packaged reproduction pending.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)