[HIVE-27488] Incorrect escaping of quotes in HPL/SQL literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-beta-1
• Component/s: hpl/sql
• Labels: pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 10/Jul/23 05:48
• Updated: 15/Aug/23 06:33
• Resolved: 19/Jul/23 14:38

Description

HPL/SQL Quote literals not behaving as expected when compared to Oracle's PL/SQL.

 

DECLARE
begin
dbms_output.put_line(trim('a''a'));
dbms_output.put_line(trim('''a'));
dbms_output.put_line(trim('a'''));
end;

 

Oracle Output:
a'a
'a
a'

 

Hive Output
INFO : a'a
INFO : 'a
INFO : a

Hive does not match the Oracle results for trim('a'''). Please check

 

Issue Links

• links to: GitHub Pull Request #4476