[CALCITE-6024] A more efficient implementation of SqlOperatorTable, backed by an immutable multi-map keyed by upper-case operator name

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 22/Sep/23 20:49
• Updated: 10/Nov/23 11:34
• Resolved: 28/Oct/23 00:11

Description

ListSqlOperatorTable is inefficient if it contains a large number of operators. It currently examines the operators one by one. ReflectiveSqlOperatorTable (and its subclass, SqlStdOperatorTable) builds a map of operators by name (actually two maps, one case-sensitive and one case-insensitive).

ListSqlOperatorTable should do the same, at least in its immutable form.

Issue Links

• relates to: CALCITE-5153 Create an immutable version of ListSqlOperatorTable
• links to: Dev branch
• links to: GitHub Pull Request #3483