[CALCITE-3228] Error while applying rule ProjectScanRule: interpreter

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Chunwei Lei
• Created: 03/Aug/19 23:52
• Updated: 10/Sep/19 21:37
• Resolved: 23/Aug/19 02:03

Description

The following test can reproduce the issue.

 

// 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());
 }

 

This is from https://lists.apache.org/thread.html/67cb614ddd123a9092fdf37ace279eb563838b045a5554ad0005f030@%3Cdev.calcite.apache.org%3E

 

Issue Links

• links to: GitHub Pull Request #1355