Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32521 SQL Server compatibility
  3. MDEV-32522

sql_mode=MSSQL: Transact-SQL dialect for CREATE PROCEDURE

    XMLWordPrintable

Details

    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • 11.6
    • Stored routines
    • None

    Description

      Let's implement a Transact-SQL procedural language parser for sql_mode=MSSQL, so users migrating from SQL Server to MariaDB do not have to rewrite their stored procedures.

      CREATE PROCEDURE grammar

      CREATE [ OR ALTER ] { PROC | PROCEDURE }
      		 
          [schema_name.] procedure_name [ ; number ]
      		 
          [ { @parameter_name [ type_schema_name. ] data_type }
      		 
              [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY]
      		 
          ] [ ,...n ]
      		 
      [ WITH <procedure_option> [ ,...n ] ]
      		 
      [ FOR REPLICATION ]
      		 
      AS { [ BEGIN ] sql_statement [;] [ ...n ] [ END ] }
      		 
      [;]
      		 
       
      		 
      <procedure_option> ::=
      		 
          [ ENCRYPTION ]
      		 
          [ RECOMPILE ]
      		 
          [ EXECUTE AS Clause ]

      Attachments

        Activity

          People

            Unassigned Unassigned
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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