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

DELIMITER should work with all clients and official connectors

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      When we define stored procedures, functions, triggers or events, we have to use DELIMITER:

      DELIMITER $$
      CREATE PROCEDURE ...
      BEGIN
          ...
      END $$
      DELIMITER ;
      

      This is the only way to write an SQL file that can be run by the mysql client.

      But several database versioning tools break when they find DELIMITER. Some examples are Prisma and Postgrator.

      In my tests, those tools just work if you remove DELIMITER and always use ";" as a delimiter. They seem to always understand where instructions end.

      We need a way to write SQL files that work with any client. So please, either:

      • make the CLI work without DELIMITER
      • XOR make official connectors work with DELIMITER.

      Attachments

        Activity

          People

            Unassigned Unassigned
            f_razzoli Federico Razzoli
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.