[CALCITE-3397] AssertionError for interpreter multiset

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.22.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Wang Yanlin
• Created: 10/Oct/19 09:35
• Updated: 06/Mar/20 04:36
• Resolved: 11/Oct/19 04:10

Description

when interpretering sql 

select multiset['a', 'b', 'c']

got,

java.lang.AssertionError: interpreter: no implementation for class org.apache.calcite.rel.core.Collect

	at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visit(Interpreter.java:460)
	at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(Nodes.java:43)
	at org.apache.calcite.rel.BiRel.childrenAccept(BiRel.java:46)
	at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visit(Interpreter.java:447)
	at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(Nodes.java:43)
	at org.apache.calcite.rel.SingleRel.childrenAccept(SingleRel.java:72)
	at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visit(Interpreter.java:447)
	at org.apache.calcite.interpreter.Nodes$CoreCompiler.visit(Nodes.java:43)
	at org.apache.calcite.interpreter.Interpreter$CompilerImpl.visitRoot(Interpreter.java:405)
	at org.apache.calcite.interpreter.Interpreter.<init>(Interpreter.java:88)
	at org.apache.calcite.test.InterpreterTest.testInterpretMultiset(InterpreterTest.java:127)

Reproduce this with test case in InterpreterTest

@Test public void testInterpretMultiset() throws Exception {
    final String sql = "select multiset['a', 'b', 'c']";
    SqlNode parse = planner.parse(sql);
    SqlNode validate = planner.validate(parse);
    RelNode convert = planner.rel(validate).project();

    final Interpreter interpreter = new Interpreter(dataContext, convert);
    assertRows(interpreter, "[[a, b, c]]");
  }

Issue Links

• links to: GitHub Pull Request #1494