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

set table options per database

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Plugins
    • None

    Description

      One can specify default charset and collation as database options, for example:

      create database foo default character set = sjis;

      and then when creating a table, it'll take table's default charset and collation from the database.

      There's no logical reason why it should not be supported for other table options, but it doesn't. This task is about fixing it.

      Thoughts:

      • to support various engine-specific options (MDEV-16133) it must allow arbitrary key=value pairs, as the storage engine plugin might be unavailable when the database is created.
      • perhaps we could only allow arbitrary key=value pairs unless IGNORE_BAD_TABLE_OPTIONS mode is set.
      • should one be able to provide db-level defaults for all table options or only for HA_TOPTION_SYSVAR kind?
      • and if the answer to the previous question is yes, shouldn't all table options have a sysvar as a default? When would it make sense not to have a sysvar for a default?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.