[IMPALA-8056] Impala accepts plus in front of string value

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.12.0
• Component/s: Frontend
• Labels: compatibility incompatibility
• Target Version: Product Backlog
• Epic Color: ghx-label-1
• Assignee: Unassigned
• Reporter: Andrejs Dubovskis
• Created: 08/Jan/19 13:46
• Updated: 08/Mar/19 17:02

Description

Impala accepts plus in front of string value and reject minus.

See the output for the corresponding queries:

Server version: impalad version 2.12.0-cdh5.15.0 RELEASE (build 23f574543323301846b41fa5433690df32efe085)

Query: select "a",+"b"
Query submitted at: 2019-01-08 14:42:55 (Coordinator: http://catdn009:25000)
Query progress can be monitored at: http://catdn009:25000/query_plan?query_id=2640632c29c812c7:905a9fcd00000000
a b
Fetched 1 row(s) in 0.01s

Query: select "a",-"b"
Query submitted at: 2019-01-08 14:42:55 (Coordinator: http://catdn009:25000)
ERROR: AnalysisException: Arithmetic operation requires numeric operands: -1 * 'b'

Could not execute command: select "a",-"b"