[HIVE-24315] Improve validation and error handling in HPL/SQL

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: hpl/sql
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Attila Magyar
• Reporter: Attila Magyar
• Created: 27/Oct/20 16:24
• Updated: 24/Mar/21 13:47
• Resolved: 24/Mar/21 13:47

Description

There are some known issues that need to be fixed. For example it seems that arity of a function is not checked when calling it, and same is true for parameter types. Calling an undefined function is evaluated to null and sometimes it seems that incorrect syntax is silently ignored. 

In cases like this a helpful error message would be expected, thought we should also consider how PL/SQL works and maintain compatibility.

Issue Links

• links to: GitHub Pull Request #2059