[CALCITE-925] Match materialized views when predicates contain strings and ranges

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Amogh Margoor
• Created: 19/Oct/15 04:55
• Updated: 27/Feb/24 22:24
• Resolved: 22/Oct/15 00:48

Description

This is in continuation of CALCITE-786 where queries are optimized using materialized views. Earlier we were not supporting predicates that were specifying ranges over a variable, for e.g., x < 90 and x > 30. No we would be able to optimize even when such predicates are used either in query or to specify a view.

Also adding support for strings for the same optimization.