Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-20238

sql_mode="oracle" does not support "DEFAULT" parameters for functions/procedures

    XMLWordPrintable

    Details

    • Type: Technical task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Following is an example where users can define a DEFAULT parameter which makes it as optional, the user can then call the procedure or the function without passing any value for the default parameters.

      SET SQL_MODE=ORACLE;
       
      DELIMITER //
      create or replace
          procedure default_values(
              p_parm1 varchar2,
              p_parm2 varchar2 default 'AAA',
              p_parm3 varchar2 default 'BBB' ) as
      begin
          select param1, param2, param3;
      end default_values//
       
      DELIMITER ;
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Faisal Faisal Saeed
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: