Dayakar M created HIVE-27488:
--------------------------------
Summary: HPL/SQL Quote literals not behaving as expected
Key: HIVE-27488
URL: https://issues.apache.org/jira/browse/HIVE-27488
Project: Hive
Issue Type: Bug
Components: hpl/sql
Reporter: Dayakar M
Assignee: Dayakar M
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;
{noformat}
Oracle Output:
a'a
'a
a'
{noformat}
{noformat}
Hive Output
INFO : a'a
INFO : 'a
INFO : a{noformat}
Hive does not match the Oracle results for trim('a'''). Please check
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
