Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-27488

Incorrect escaping of quotes in HPL/SQL literals

    XMLWordPrintableJSON

Details

    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

       

      Attachments

        Issue Links

          Activity

            People

              Dayakar Dayakar M
              Dayakar Dayakar M
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: