skeema / skeema / 27163603012

92%

push

github

MariaDB 12.3 support

This commit marks MariaDB 12.3 as a supported DB flavor. MariaDB 12.3 is the
latest LTS server version series, which became generally available on May 28.

Three changes in MariaDB 12.3 are related to schema management, but only the
first two are supported in Skeema at this time:

* MDEV-37261: New column type XMLTYPE for storing XML data. Now fully
  supported in this commit. In terms of diff safety checks when modifying the
  type of an existing column, XMLTYPE behaves identically to LONGTEXT.

* MDEV-9826: PARTITION BY [LINEAR] KEY new ALGORITHM clause values. Fully
  supported already, via the same logic that handles MySQL's ALGORITHM clause
  in these partitioning types.

* MDEV-34391: SET PATH command allowing proc/func/package invocations to
  have a default search path of one or more other schemas, instead of the
  current one. This setting affects creation of procs, funcs, triggers, and
  views (but not events yet, see MDEV-39929) and is "remembered" at creation-
  time similar to sql_mode. However, the server does not currently expose it
  in SHOW CREATE nor information_schema, so there is no possible way for
  Skeema to properly introspect or diff it. (The same limitation actually
  also affects mariadb-dump; see MDEV-39930). If/when the MariaDB server
  provides the ability to query an object's creation-time PATH, a future
  version of Skeema may add support for this setting. But there are also
  some inherent complexities with the cross-schema-lookup nature of this
  feature impacting the single-schema-at-a-time workspace model currently
  used in Skeema v1.

1 of 1 new or added line in 1 file covered. (100.0%)

10962 of 11852 relevant lines covered (92.49%)

1.11 hits per line