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

DELIMITER not working in mysqld init-file

    XMLWordPrintable

Details

    Description

      mysqld.init

      DELIMITER //
      select 1//
      DELIMITER ;
      

      When I run

      mysqld --init-file="/tmp/mysqld.init"
      

      I get a syntax error but the same init file doesn't give any error while run as

      mysql < /tmp/mysqld.init
      

      Here is an exact issue of mysql https://bugs.mysql.com/bug.php?id=17843

      +---------------------------------+------------------------------------------+
      | Variable_name                   | Value                                    |
      +---------------------------------+------------------------------------------+
      | innodb_version                  | 10.3.12                                  |
      | protocol_version                | 10                                       |
      | slave_type_conversions          |                                          |
      | system_versioning_alter_history | ERROR                                    |
      | system_versioning_asof          | DEFAULT                                  |
      | version                         | 10.3.12-MariaDB-log                      |
      | version_comment                 | MariaDB Server                           |
      | version_compile_machine         | x86_64                                   |
      | version_compile_os              | Linux                                    |
      | version_malloc_library          | system                                   |
      | version_source_revision         | faf206a848684bc0f87c93a2b47a55063bbccc6c |
      | version_ssl_library             | OpenSSL 1.1.1a  20 Nov 2018              |
      | wsrep_patch_version             | wsrep_25.23                              |
      +---------------------------------+------------------------------------------+
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dbjpanda Dibyajyoti Panda
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.