[
https://issues.apache.org/jira/browse/HIVE-27488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17742304#comment-17742304
]
Dayakar M commented on HIVE-27488:
----------------------------------
[~zabetak] here issue is not related to trim function, its related to
_*dbms_output.put_line()*_ function belongs to HPL/SQL. As per
[hplsql|http://www.hplsql.org/dbms-output] documentation, it is compatible with
Oracle's PL/SQL so it should work the same way how Oracle works. Even here the
changes are done in the hplsql module code only, its specific to HPL/SQL
feature.
> 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
> 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)
