Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Not A Problem
-
0.9.1-incubating
-
None
-
None
Description
The following query in JdbcTest.checkTableMacroInModel
select count(*) from table("adhoc"."View"(' (30)')) "a", table("adhoc"."View"('('||cast("a"."c" as char)||')')) b
Fails as follows:
java.lang.RuntimeException: exception while executing [explain plan for select count(*) from table("adhoc"."View"('(30)')) "a", table("adhoc"."View"('('||cast("a"."c" as char)||')')) b] at net.hydromatic.optiq.test.OptiqAssert$AssertQuery.returns(OptiqAssert.java:1051) at net.hydromatic.optiq.test.OptiqAssert$AssertQuery.explainMatches(OptiqAssert.java:1129) at net.hydromatic.optiq.test.OptiqAssert$AssertQuery.explainContains(OptiqAssert.java:1124) at net.hydromatic.optiq.test.JdbcTest.checkTableMacroInModel(JdbcTest.java:466) at net.hydromatic.optiq.test.JdbcTest.testTableFunctionInModel(JdbcTest.java:435) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) at org.junit.runners.ParentRunner.run(ParentRunner.java:309) at org.junit.runner.JUnitCore.run(JUnitCore.java:160) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:74) at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:211) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:67) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134) Caused by: java.lang.RuntimeException: With materializationsEnabled=false, limit=0 at net.hydromatic.optiq.test.OptiqAssert.assertQuery(OptiqAssert.java:419) at net.hydromatic.optiq.test.OptiqAssert$AssertQuery.returns(OptiqAssert.java:1047) ... 30 more Caused by: java.sql.SQLException: error while executing SQL "explain plan for select count(*) from table("adhoc"."View"('(30)')) "a", table("adhoc"."View"('('||cast("a"."c" as char)||')')) b": From line 1, column 105 to line 1, column 107: Unknown identifier 'a' at net.hydromatic.avatica.Helper.createException(Helper.java:39) at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:79) at net.hydromatic.optiq.test.OptiqAssert.assertQuery(OptiqAssert.java:394) ... 31 more Caused by: org.eigenbase.util.EigenbaseContextException: From line 1, column 105 to line 1, column 107: Unknown identifier 'a' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348) at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:674) at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:659) at org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3551) at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3961) at org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3885) at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:221) at org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1351) at org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1334) at org.eigenbase.sql.type.InferTypes$1.inferOperandTypes(InferTypes.java:51) at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1526) at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1532) at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1532) at org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1532) at org.eigenbase.sql.validate.ProcedureNamespace.validateImpl(ProcedureNamespace.java:49) at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84) at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747) at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736) at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2599) at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2584) at org.eigenbase.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:2621) at org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2593) at org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2802) at org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:59) at org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84) at org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747) at org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736) at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:207) at org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:710) at org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426) at org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:406) at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:212) at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:178) at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:420) at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:325) at net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:294) at net.hydromatic.optiq.jdbc.OptiqConnectionImpl.parseQuery(OptiqConnectionImpl.java:170) at net.hydromatic.optiq.jdbc.MetaImpl.prepare(MetaImpl.java:622) at net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76) ... 32 more Caused by: org.eigenbase.sql.validate.SqlValidatorException: Unknown identifier 'a' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:408) at org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348) at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457) ... 70 more