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

10.0.4 - make release notes

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 10.0.4
    • None
    • None

    Description

      We should compile a list of new features that are released in 10.0.4

      (normally, the list can be auto-compiled, but in this case, we need to look at what has been merged from MySQL 5.6)

      Implemented for 10.0:
      MDEV-4438 - Spider storage engine
      MDEV-4568 - Port Percona response time distribution as audit plugin
      MDEV-4594 - CREATE SERVER crashes embedded
      MDEV-4702 - Reduce usage of LOCK_open

      Merged for 5.6:
      MDEV-330 - merge microsecond feature from mysql-5.6. MariaDB now can open
      tables created in MySQL-5.6 that have columns of types TIME(N), DATETIME(N) and TIMESATMP(N).
      Previously, an attempt to open such a table in MariaDB would return an error.
      MDEV-3838 - Standard SQL temporal literals are recognized by MySQL 5.6 but ignored by MariaDB 10.0
      MDEV-4058 - Merge the host_cache P_S table
      MDEV-4710 - Merge Performance Schema test cases from MySQL 5.6.10
      WL#5185 Remove deprecated 5.1 features

      (so far includes lists from svoj, bar, psergey, timour)

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4873 Tasks before 10.0.4-release

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            Found the following after the first iteration through release notes ("Changes" sections only, not "Bug fixes"):

            • Performance schema + new defaults;
            • InnoDB + Information Schema + new defaults;
            • Online ALTER for InnoDB + thread information for in-place operations;
            • EXHANGE PARTITION
            • Partition selection
            • Partition lock pruning (Bug #37252, Bug #11748732)
            • The maximum number of partitions for a user-partitioned table is increased from 1024 to 8192. (Bug #11755685)
            • The server now includes the thread ID in rows written to the slow query log
            • The mysql client program now has a --binary-mode option that helps when processing mysqlbinlog output that may contain BLOB values (Bug #33048, Bug #11747577)
            • For temporary tables created with the CREATE TEMPORARY TABLE statement, the privilege model has changed (Bug #27480, Bug #11746602)
            • MySQL now supports the GET DIAGNOSTICS statement. In addition several deficiencies in condition handler processing rules were corrected so that MySQL behavior is more like standard SQL (Bug #12951117, Bug #38806, Bug #11749343, Bug #55852, Bug #11763171, Bug #61392, Bug #12652873, Bug #11660, Bug #11745196)
            • Syntax for temporal literals now produces temporal values
            • MySQL now provides more information about the causes of errors that occur when clients connect to the server, as well as improved access to the host cache
            • Traditional EXPLAIN output has also changed so that empty columns contain NULL rather the empty string (? something definitely changed here)
            • For the WITH_SSL CMake option, no is no longer a permitted value or the default value. The default is now bundled.
            • The WITH_SSL option for CMake now accepts a path_name value that indicates the path name to the OpenSSL installation to use (Bug #61619, Bug #12762891)
            • new default values for max_connect_errors, open_files_limit
            elenst Elena Stepanova added a comment - Found the following after the first iteration through release notes ("Changes" sections only, not "Bug fixes"): Performance schema + new defaults; InnoDB + Information Schema + new defaults; Online ALTER for InnoDB + thread information for in-place operations; EXHANGE PARTITION Partition selection Partition lock pruning (Bug #37252, Bug #11748732) The maximum number of partitions for a user-partitioned table is increased from 1024 to 8192. (Bug #11755685) The server now includes the thread ID in rows written to the slow query log The mysql client program now has a --binary-mode option that helps when processing mysqlbinlog output that may contain BLOB values (Bug #33048, Bug #11747577) For temporary tables created with the CREATE TEMPORARY TABLE statement, the privilege model has changed (Bug #27480, Bug #11746602) MySQL now supports the GET DIAGNOSTICS statement. In addition several deficiencies in condition handler processing rules were corrected so that MySQL behavior is more like standard SQL (Bug #12951117, Bug #38806, Bug #11749343, Bug #55852, Bug #11763171, Bug #61392, Bug #12652873, Bug #11660, Bug #11745196) Syntax for temporal literals now produces temporal values MySQL now provides more information about the causes of errors that occur when clients connect to the server, as well as improved access to the host cache Traditional EXPLAIN output has also changed so that empty columns contain NULL rather the empty string (? something definitely changed here) For the WITH_SSL CMake option, no is no longer a permitted value or the default value. The default is now bundled. The WITH_SSL option for CMake now accepts a path_name value that indicates the path name to the OpenSSL installation to use (Bug #61619, Bug #12762891) new default values for max_connect_errors, open_files_limit
            elenst Elena Stepanova added a comment -

            I also think we should be clearer (or more verbose) about "merge microsecond feature from mysql-5.6". We already had microseconds before, so it sounds weird if we put it this way, we need to explain what exactly was merged.

            elenst Elena Stepanova added a comment - I also think we should be clearer (or more verbose) about "merge microsecond feature from mysql-5.6". We already had microseconds before, so it sounds weird if we put it this way, we need to explain what exactly was merged.
            bar Alexander Barkov added a comment -

            Elena, "merge microsecond feature from mysql-5.6" means that MariaDB now can open
            tables created in MySQL-5.6 that have columns of types TIME(N), DATETIME(N) and TIMESTMP(N).
            Previously, and attempts to open such a table in MariaDB would return an error.

            bar Alexander Barkov added a comment - Elena, "merge microsecond feature from mysql-5.6" means that MariaDB now can open tables created in MySQL-5.6 that have columns of types TIME(N), DATETIME(N) and TIMESTMP(N). Previously, and attempts to open such a table in MariaDB would return an error.

            People

              dbart Daniel Bartholomew
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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