[ https://issues.apache.org/jira/browse/CALCITE-3228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16899634#comment-16899634 ]
Amit Chavan commented on CALCITE-3228: -------------------------------------- [~Chunwei Lei] [~jinxing6...@126.com] I am attaching the UT that has test cases to reproduce the errors.[^TestCalcite.java] > Error while applying rule ProjectScanRule: interpreter > ------------------------------------------------------ > > Key: CALCITE-3228 > URL: https://issues.apache.org/jira/browse/CALCITE-3228 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: Chunwei Lei > Priority: Critical > Fix For: 1.21.0 > > Attachments: CALCITE-3228.patch > > > The following test can reproduce the issue. > > {code:java} > // FrameworksTest.java > @Test public void testMinMax() throws Exception { > Table table = new TableImpl(); > final SchemaPlus rootSchema = Frameworks.createRootSchema(true); > SchemaPlus schema = rootSchema.add("x", new AbstractSchema()); > schema.add("MYTABLE", table); > List<RelTraitDef> traitDefs = new ArrayList<>(); > traitDefs.add(ConventionTraitDef.INSTANCE); > traitDefs.add(RelDistributionTraitDef.INSTANCE); > SqlParser.Config parserConfig = > SqlParser.configBuilder(SqlParser.Config.DEFAULT) > .setCaseSensitive(false) > .build(); > final FrameworkConfig config = Frameworks.newConfigBuilder() > .parserConfig(parserConfig) > .defaultSchema(schema) > .traitDefs(traitDefs) > // define the rules you want to apply > .ruleSets( > RuleSets.ofList(AbstractConverter.ExpandConversionRule.INSTANCE, > ProjectTableScanRule.INSTANCE)) > .programs(Programs.ofRules(Programs.RULE_SET)) > .build(); > executeQuery(config, " select min(id) as mi, max(id) as ma from mytable where > id=1 group by id", > CalciteSystemProperty.DEBUG.value()); > } > {code} > -- This message was sent by Atlassian JIRA (v7.6.14#76016)