[HIVE-27490] HPL/SQL says it support default value for parameters but not considering them when no value is passed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: hpl/sql
• Labels: pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 10/Jul/23 06:00
• Updated: 29/Mar/24 17:50
• Resolved: 01/Mar/24 04:54

Description

HPL/SQL says it support default value for parameters but not considering them when no value is passed.

CREATE OR replace PROCEDURE test123(a NUMBER DEFAULT -110)
AS
BEGIN
dbms_output.put_line (a);
end;

Oracle shows the default value-

SQL> call test123();
-110

Hive shows the variable name instead of the default value-

call test123();
INFO : a

Issue Links

• links to: GitHub Pull Request #5084