[
https://issues.apache.org/jira/browse/HIVE-27488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated HIVE-27488:
---------------------------------------
Summary: Incorrect escaping of quotes in HPL/SQL literals (was: HPL/SQL
Quote literals not behaving as expected)
> Incorrect escaping of quotes in HPL/SQL literals
> ------------------------------------------------
>
> 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
> Priority: Major
> Labels: pull-request-available
>
> 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)
