[CALCITE-3056] Elasticsearch adapter. Invalid result with cast function on raw queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Component/s: elasticsearch-adapter
• Labels: pull-request-available
• Assignee: Andrei Sereda
• Reporter: Andrei Sereda
• Created: 08/May/19 23:24
• Updated: 24/Jun/19 15:02
• Resolved: 09/May/19 00:43

Description

Raw elastic queries (not based on views) return incorrect result when cast function is used.

-- does not work without view (returns null)
select max(cast(_MAP['foo'] as integer)) from elastic

-- query based on view works
create view elasticview as select cast(_MAP['foo'] as integer) as foo from elastic; 
-- works
select max(foo) from elasticview 

This seems a little counterintuitive, since casting is not pushed to elastic, but consistent with existing view functionality.

Issue Links

• links to: GitHub Pull Request #1201