[ https://issues.apache.org/jira/browse/PHOENIX-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16053723#comment-16053723 ]
Csaba Skrabak commented on PHOENIX-3893: ---------------------------------------- I have tried the failing query with the where clause on a Phoenix version 4.7. I didn't get any NullPointerException. With 4.10 code, the stack trace was like this: java.lang.NullPointerException at org.apache.phoenix.compile.JoinCompiler$JoinTableConstructor.resolveTable(JoinCompiler.java:181) at org.apache.phoenix.compile.JoinCompiler$JoinTableConstructor.visit(JoinCompiler.java:218) at org.apache.phoenix.compile.JoinCompiler$JoinTableConstructor.visit(JoinCompiler.java:175) at org.apache.phoenix.parse.DerivedTableNode.accept(DerivedTableNode.java:49) at org.apache.phoenix.compile.JoinCompiler$JoinTableConstructor.visit(JoinCompiler.java:195) at org.apache.phoenix.compile.JoinCompiler$JoinTableConstructor.visit(JoinCompiler.java:175) at org.apache.phoenix.parse.JoinTableNode.accept(JoinTableNode.java:81) at org.apache.phoenix.compile.JoinCompiler.compile(JoinCompiler.java:135) at org.apache.phoenix.compile.JoinCompiler.optimize(JoinCompiler.java:1164) at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:194) at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:420) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:394) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:280) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:270) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:269) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1479) > Using the TO_TIMESTAMP function in a WHERE statement causes an error. > --------------------------------------------------------------------- > > Key: PHOENIX-3893 > URL: https://issues.apache.org/jira/browse/PHOENIX-3893 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.10.0 > Reporter: seoungho park > > {code} > SELECT > "type", COUNT(DISTINCT "offset") > FROM "log" > LEFT OUTER JOIN (SELECT TO_TIMESTAMP('2017-05-29 02:53:00') AS "start") AS > "s" ON 1=1 > LEFT OUTER JOIN (SELECT TO_TIMESTAMP('2017-05-29 02:55:00') AS "end") AS "e" > ON 1=1 > WHERE "date" >= "start" AND "date" < "end" > GROUP BY "type" > {code} > -> It return the correct result > {code} > SELECT > "type", COUNT(DISTINCT "offset") > FROM "log" > WHERE "date" >= TO_TIMESTAMP('2017-05-29 02:53:00') AND "date" < > TO_TIMESTAMP('2017-05-29 02:55:00') > GROUP BY "type" > {code} > -> It return the java.lang.NullPointerException > The second query should return the same result as above, and why is this > issue happening? -- This message was sent by Atlassian JIRA (v6.4.14#64029)