[
https://issues.apache.org/jira/browse/HIVE-27488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis resolved HIVE-27488.
----------------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Fixed in
[https://github.com/apache/hive/commit/7139d42e8d8c75ff0700274b81f4ddf3e90b905c.]
Thanks for the PR [~Dayakar] and [~aturoczy] for the review!
> 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
> Fix For: 4.0.0
>
>
> 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)
