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

sql_mode = Oracle with MariaDB 10.3.4 and Store procedure

    XMLWordPrintable

    Details

      Description

      Hello I tried short example to try compatibility of Oracle with MariaDB but it's not work :

      sql_mode = Oracle

      create or replace function ean_13(P_Str In Varchar2) Return Varchar2 Is 
      l_Sum Number; 
      l_Multiple Number; 
      Begin For I in 1..12 Loop
       If mod(i,2) = 0 Then
       l_Multiple := 3;
       Else l_Multiple := 1;
       End If;
       l_Sum := Nvl(l_Sum, 0) + Substr(P_Str, i, 1) * l_Multiple; End Loop; 
      If Floor(l_Sum/10) - Mod(l_Sum, 10) = Substr(P_Str, 13) Then Return('TRUE');
      Else Return('FALSE'); 
      End If; 
      End; /
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                Aurelien_LEQUOY Aurélien LEQUOY
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: