You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/24 04:21:39 UTC

[jira] [Updated] (PHOENIX-1546) Calling getParameterMetaData on prepared statement where TO_NUMBER is used throws NPE

     [ https://issues.apache.org/jira/browse/PHOENIX-1546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-1546:
----------------------------------
    Fix Version/s: 4.8.0

> Calling getParameterMetaData on prepared statement where TO_NUMBER is used throws NPE
> -------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1546
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1546
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Gabriel Reid
>             Fix For: 4.8.0
>
>
> There are some issues calling {{PhoenixPreparedStatement.getParameterMetaData}} on a prepared statement that uses function calls on its input parameters. 
> For example, the following test code:
> {code}
> PreparedStatement stmt = conn.prepareStatement(
>                 "UPSERT INTO " + ATABLE + " (organization_id, entity_id, a_integer) " +
>                         "VALUES (?,?,TO_NUMBER(?))");
>         ParameterMetaData parameterMetaData = stmt.getParameterMetaData();
> {code}
> results in the following stack trace:
> {code}
> java.lang.NullPointerException
> 	at org.apache.phoenix.parse.ToNumberParseNode.create(ToNumberParseNode.java:49)
> 	at org.apache.phoenix.parse.ToNumberParseNode.create(ToNumberParseNode.java:35)
> 	at org.apache.phoenix.compile.ExpressionCompiler.visitLeave(ExpressionCompiler.java:309)
> 	at org.apache.phoenix.compile.ExpressionCompiler.visitLeave(ExpressionCompiler.java:132)
> 	at org.apache.phoenix.parse.FunctionParseNode.accept(FunctionParseNode.java:83)
> 	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:726)
> 	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:479)
> 	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:470)
> 	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.getParameterMetaData(PhoenixPreparedStatement.java:248)
> {code}



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