[ https://issues.apache.org/jira/browse/CALCITE-1919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16110730#comment-16110730 ]
Lim Chee Hau commented on CALCITE-1919: --------------------------------------- I have created a PR here: https://github.com/apache/calcite/pull/505 > NPE when target in ReflectiveSchema has no package was defined > -------------------------------------------------------------- > > Key: CALCITE-1919 > URL: https://issues.apache.org/jira/browse/CALCITE-1919 > Project: Calcite > Issue Type: Bug > Reporter: Lim Chee Hau > Assignee: Julian Hyde > Priority: Minor > > When following this [foodmart > example|https://github.com/apache/calcite/blob/master/core/src/test/java/org/apache/calcite/examples/foodmart/java/JdbcExample.java], > I have created the Foodmart and Hr separately with no java package and > passing them to ReflectiveSchema, it threw NPE when executing executeQuery. > {code} > [error] (run-main-0) java.sql.SQLException: Error while executing SQL "select > * from "hr"."emps"": null > java.sql.SQLException: Error while executing SQL "select * from "hr"."emps"": > null > at org.apache.calcite.avatica.Helper.createException(Helper.java:56) > at org.apache.calcite.avatica.Helper.createException(Helper.java:41) > at > org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156) > at > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218) > at Main$.main(Main.scala:39) > at Main.main(Main.scala) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > Caused by: java.lang.NullPointerException > at org.apache.calcite.linq4j.tree.Types.className(Types.java:256) > at > org.apache.calcite.linq4j.tree.ExpressionWriter.append(ExpressionWriter.java:124) > at > org.apache.calcite.linq4j.tree.UnaryExpression.accept(UnaryExpression.java:48) > at > org.apache.calcite.linq4j.tree.ExpressionWriter.requireParentheses(ExpressionWriter.java:69) > at > org.apache.calcite.linq4j.tree.UnaryExpression.accept(UnaryExpression.java:47) > at > org.apache.calcite.linq4j.tree.MemberExpression.accept(MemberExpression.java:71) > at > org.apache.calcite.linq4j.tree.MethodCallExpression.accept(MethodCallExpression.java:105) > at > org.apache.calcite.linq4j.tree.GotoStatement.accept0(GotoStatement.java:84) > at org.apache.calcite.linq4j.tree.Statement.accept(Statement.java:32) > at > org.apache.calcite.linq4j.tree.BlockStatement.accept0(BlockStatement.java:75) > at > org.apache.calcite.linq4j.tree.ExpressionWriter.append(ExpressionWriter.java:129) > at > org.apache.calcite.linq4j.tree.MethodDeclaration.accept(MethodDeclaration.java:79) > at > org.apache.calcite.linq4j.tree.ExpressionWriter.write(ExpressionWriter.java:49) > at > org.apache.calcite.linq4j.tree.Expressions.toString(Expressions.java:55) > at > org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:93) > at > org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1257) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:331) > at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:228) > at > org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:784) > at > org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:639) > at > org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:609) > at > org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214) > at > org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603) > at > org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638) > at > org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149) > at > org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218) > at Main$.main(Main.scala:39) > at Main.main(Main.scala) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > [trace] Stack trace suppressed: run last compile:run for the full output. > java.lang.RuntimeException: Nonzero exit code: 1 > at scala.sys.package$.error(package.scala:27) > [trace] Stack trace suppressed: run last compile:run for the full output. > [error] (compile:run) Nonzero exit code: 1 > [error] Total time: 10 s, completed Aug 2, 2017 11:45:24 AM > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)