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

--create-tmp-table-binlog-formats='' startup option silently ignored if incorrect

    XMLWordPrintable

Details

    Description

      When we use, for example, --sql_mode='abc' as a startup option to {{mariadbd]} we will get a failure:

      CS 12.3.2 868ab472e6b097967b7e6338b1b0a07ee92ca249 (Debug, Clang 21.1.3-20250923) Build 28/03/2026

      2026-03-28 13:59:17 0 [ERROR] /test/MD280326-mariadb-12.3.2-linux-x86_64-dbg/bin/mariadbd: Error while setting value 'abc' to 'sql_mode'
      

      However, if we use the invalid --create-tmp-table-binlog-formats='' as a startup option, we get no failure, and the default remains:

      CS 12.3.2 868ab472e6b097967b7e6338b1b0a07ee92ca249 (Debug, Clang 21.1.3-20250923) Build 28/03/2026

      12.3.2-dbg>SELECT @@GLOBAL.create_tmp_table_binlog_formats;
      +------------------------------------------+
      | @@GLOBAL.create_tmp_table_binlog_formats |
      +------------------------------------------+
      | STATEMENT                                |
      +------------------------------------------+
      1 row in set (0.000 sec)
       
      12.3.2-dbg>SELECT @@SESSION.create_tmp_table_binlog_formats;
      +-------------------------------------------+
      | @@SESSION.create_tmp_table_binlog_formats |
      +-------------------------------------------+
      | STATEMENT                                 |
      +-------------------------------------------+
      1 row in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              Roel Roel Van de Paar
              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.