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

Trevor Hartman updated CALCITE-449:
-----------------------------------
    Description: 
Query:
{noformat}
select count(*) as rowcount from "listings"."listings"
{noformat}

Stacktrace:
{noformat}
query(c.e.s.columnar.listings.sql.TryCalcite)  Time elapsed: 0.014 sec  <<< 
FAILURE!
 java.lang.AssertionError: Internal error: Error while applying rule 
ColumnarProjectRule, args 
[rel#27:ProjectRel.NONE.[](child=rel#26:Subset#0.ENUMERABLE.[],EXPR$0=ITEM($0, 
'listingId'),EXPR$1=ITEM($0, 'applicationId')), 
rel#24:ColumnarTableScan.ENUMERABLE.[](table=[listings, listings])]
        at org.eigenbase.util.Util.newInternal(Util.java:749)
        at 
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:245)
        at 
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:660)
        at net.hydromatic.optiq.tools.Programs$5.run(Programs.java:234)
        at 
net.hydromatic.optiq.tools.Programs$SequenceProgram.run(Programs.java:282)
        at net.hydromatic.optiq.prepare.Prepare.optimize(Prepare.java:119)
        at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:252)
        at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:164)
        at 
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:377)
        at 
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:285)
        at 
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:254)
        at 
net.hydromatic.optiq.jdbc.OptiqConnectionImpl.parseQuery(OptiqConnectionImpl.java:150)
        at net.hydromatic.optiq.jdbc.MetaImpl.prepare(MetaImpl.java:617)
        at 
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
        at c.e.s.columnar.listings.sql.TryCalcite.query(TryCalcite.scala:51)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
        at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
        at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
        at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
        at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
        at 
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
        at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
        at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
        at org.junit.runners.Suite.runChild(Suite.java:128)
        at org.junit.runners.Suite.runChild(Suite.java:24)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
        at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
        at org.junit.runner.JUnitCore.run(JUnitCore.java:136)
        at org.junit.runner.JUnitCore.run(JUnitCore.java:127)
        at 
org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:52)
        at 
org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:112)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at 
org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
        at 
org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
        at 
org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:172)
        at 
org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:78)
        at 
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:70)
 Caused by: java.lang.AssertionError: Internal error: Error occurred while 
applying rule ColumnarProjectRule
        at org.eigenbase.util.Util.newInternal(Util.java:749)
        at 
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:142)
        at 
org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:209)
        at 
c.e.s.columnar.query.sql.ColumnarProjectRule.onMatch(ColumnarProjectRule.scala:35)
        at 
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:222)
        ... 54 more
 Caused by: java.lang.AssertionError: Type mismatch:
 rel rowtype:
 RecordType((VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE 
"ISO-8859-1$en_US$primary" NOT NULL, ANY NOT NULL) MAP NOT NULL _MAP) NOT NULL
 equivRel rowtype:
 RecordType(ANY EXPR$0, ANY EXPR$1) NOT NULL
        at org.eigenbase.relopt.RelOptUtil.equal(RelOptUtil.java:1498)
        at 
org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:834)
        at 
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:865)
        at 
org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1761)
        at 
org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:130)
        ... 57 more
 {noformat}

  was:
Query:
select count(*) as rowcount from "listings"."listings"

Error:
|| Caused by: java.lang.AssertionError: Type mismatch:
|| rel rowtype:
|| RecordType((VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE 
"ISO-8859-1$en_US$primary" NOT NULL, ANY NOT NULL) MAP NOT NULL _MAP) NOT NULL
|| equivRel rowtype:
|| RecordType(INTEGER NOT NULL DUMMY) NOT NULL


> INT DUMMY when selecting count(*) on _MAP row type
> --------------------------------------------------
>
>                 Key: CALCITE-449
>                 URL: https://issues.apache.org/jira/browse/CALCITE-449
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 0.9.0-incubating
>            Reporter: Trevor Hartman
>            Assignee: Julian Hyde
>            Priority: Minor
>
> Query:
> {noformat}
> select count(*) as rowcount from "listings"."listings"
> {noformat}
> Stacktrace:
> {noformat}
> query(c.e.s.columnar.listings.sql.TryCalcite)  Time elapsed: 0.014 sec  <<< 
> FAILURE!
>  java.lang.AssertionError: Internal error: Error while applying rule 
> ColumnarProjectRule, args 
> [rel#27:ProjectRel.NONE.[](child=rel#26:Subset#0.ENUMERABLE.[],EXPR$0=ITEM($0,
>  'listingId'),EXPR$1=ITEM($0, 'applicationId')), 
> rel#24:ColumnarTableScan.ENUMERABLE.[](table=[listings, listings])]
>       at org.eigenbase.util.Util.newInternal(Util.java:749)
>       at 
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:245)
>       at 
> org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:660)
>       at net.hydromatic.optiq.tools.Programs$5.run(Programs.java:234)
>       at 
> net.hydromatic.optiq.tools.Programs$SequenceProgram.run(Programs.java:282)
>       at net.hydromatic.optiq.prepare.Prepare.optimize(Prepare.java:119)
>       at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:252)
>       at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:164)
>       at 
> net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:377)
>       at 
> net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:285)
>       at 
> net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:254)
>       at 
> net.hydromatic.optiq.jdbc.OptiqConnectionImpl.parseQuery(OptiqConnectionImpl.java:150)
>       at net.hydromatic.optiq.jdbc.MetaImpl.prepare(MetaImpl.java:617)
>       at 
> net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
>       at c.e.s.columnar.listings.sql.TryCalcite.query(TryCalcite.scala:51)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>       at java.lang.reflect.Method.invoke(Method.java:606)
>       at 
> org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
>       at 
> org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
>       at 
> org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
>       at 
> org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
>       at 
> org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
>       at 
> org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
>       at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
>       at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
>       at 
> org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
>       at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
>       at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
>       at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
>       at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
>       at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
>       at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
>       at org.junit.runners.Suite.runChild(Suite.java:128)
>       at org.junit.runners.Suite.runChild(Suite.java:24)
>       at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
>       at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
>       at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
>       at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
>       at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
>       at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
>       at org.junit.runner.JUnitCore.run(JUnitCore.java:157)
>       at org.junit.runner.JUnitCore.run(JUnitCore.java:136)
>       at org.junit.runner.JUnitCore.run(JUnitCore.java:127)
>       at 
> org.apache.maven.surefire.junitcore.JUnitCoreWrapper.execute(JUnitCoreWrapper.java:52)
>       at 
> org.apache.maven.surefire.junitcore.JUnitCoreProvider.invoke(JUnitCoreProvider.java:112)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>       at java.lang.reflect.Method.invoke(Method.java:606)
>       at 
> org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
>       at 
> org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
>       at 
> org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:172)
>       at 
> org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:78)
>       at 
> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:70)
>  Caused by: java.lang.AssertionError: Internal error: Error occurred while 
> applying rule ColumnarProjectRule
>       at org.eigenbase.util.Util.newInternal(Util.java:749)
>       at 
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:142)
>       at 
> org.eigenbase.relopt.RelOptRuleCall.transformTo(RelOptRuleCall.java:209)
>       at 
> c.e.s.columnar.query.sql.ColumnarProjectRule.onMatch(ColumnarProjectRule.scala:35)
>       at 
> org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:222)
>       ... 54 more
>  Caused by: java.lang.AssertionError: Type mismatch:
>  rel rowtype:
>  RecordType((VARCHAR(1) CHARACTER SET "ISO-8859-1" COLLATE 
> "ISO-8859-1$en_US$primary" NOT NULL, ANY NOT NULL) MAP NOT NULL _MAP) NOT NULL
>  equivRel rowtype:
>  RecordType(ANY EXPR$0, ANY EXPR$1) NOT NULL
>       at org.eigenbase.relopt.RelOptUtil.equal(RelOptUtil.java:1498)
>       at 
> org.eigenbase.relopt.volcano.VolcanoPlanner.register(VolcanoPlanner.java:834)
>       at 
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:865)
>       at 
> org.eigenbase.relopt.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1761)
>       at 
> org.eigenbase.relopt.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:130)
>       ... 57 more
>  {noformat}



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

Reply via email to