[CALCITE-4552] Interpreter should close resources held by its Nodes on close

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.27.0
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 25/Mar/21 01:11
• Updated: 03/Jun/21 22:32
• Resolved: 28/Mar/21 04:16

Description

When closing Interpreter, close resources held by its Nodes.

Currently, if a node is based on a JdbcTableScan, and the Interpreter's results have not been read to completion, the statement will still be open, and the JDBC connection will not be returned to the pool. This can cause a hang, waiting for a connection, if you allocate and deallocate lots of Interpreter instances.