Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19915

sql_mode=ORACLE: call procedure with "=>"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.6
    • Fix Version/s: 10.4
    • Component/s: PL/SQL
    • Labels:
      None
    • Environment:
      Windows

      Description

      In the ORACLE-Mode there is a problem to call function and procedure with "=>"
      Generate the samples

      use test;
      SET SESSION sql_mode='ORACLE,EMPTY_STRING_IS_NULL';
       
      delimiter //
      create or replace procedure test_proc(p1 varchar2, p2 varchar2, p3 varchar2) as
       
      v1 varchar2(100);
       
      begin
        v1:=p1;
      end;
      //
       
      delimiter ;
      

      When I call this with

      call test_proc('xxx','yy','zz');  
      

      Then the code will be run correctly.

      but, when I call this with "=>" then I get an error.

      call test_proc(p1=>'xxx', p2=>'aa', p3=>'yy');
      ERROR 1054 (42S22): Unknown column 'p1' in 'field list'
       
      call test_proc('xxx', p2=> 'aa', p3 => 'yy');
      ERROR 1054 (42S22): Unknown column 'p2' in 'field list'
       
      call test_proc('xxx', p3=> 'aa', p2 => 'yy');
      ERROR 1054 (42S22): Unknown column 'p3' in 'field list'
      

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            wodrsoftware Wolfgang Draxler
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration