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

              bar Alexander Barkov
              Aurelien_LEQUOY Aurélien LEQUOY
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.