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

HPL/SQL says it support default value for parameters but not considering them when no value is passed

    XMLWordPrintableJSON

Details

    Description

      HPL/SQL says it support default value for parameters but not considering them when no value is passed.

      CREATE OR replace PROCEDURE test123(a NUMBER DEFAULT -110)
      AS
      BEGIN
      dbms_output.put_line (a);
      end;

      Oracle shows the default value-

      SQL> call test123();
      -110

      Hive shows the variable name instead of the default value-

      call test123();
      INFO : a

      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: