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

Details

    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

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-10862 Stored procedures: default values for parameters (optional parameters)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34323 Oracle compatibility project 3

          • Major - Major loss of function.
          • Open

          Activity

            bar Alexander Barkov added a comment -

            This issue is a duplicate for:

            MDEV-10862 Stored procedures: default values for parameters (optional parameters)

            bar Alexander Barkov added a comment - This issue is a duplicate for: MDEV-10862 Stored procedures: default values for parameters (optional parameters)

            People

              Unassigned Unassigned
              Faisal Faisal Saeed (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.