delta/mariadb-git.git/scripts/sys_schema, branch 11.1

MDEV-30205 Move /usr/share/mysql to /usr/share/mariadb

2023-04-10T21:59:02+00:00

These are mainly internal files so is a low impact change.

The few scripts/mysql*sql where renames to mariadb_* prefix
on the name.

mysql-test renamed to mariadb-test in the final packages

MDEV-19629 post-merge fixes

2023-03-27T19:27:27+00:00

* it isn't "pfs" function, don't call it Item_func_pfs,
  don't use item_pfsfunc.*
* tests don't depend on performance schema, put in the main suite
* inherit from Item_str_ascii_func
* use connection collation, not utf8mb3_general_ci
* set result length in fix_length_and_dec
* do not set maybe_null
* use my_snprintf() where possible
* don't set m_value.ptr on every invocation
* update sys schema to use the format_pico_time()
* len must be size_t (compilation error on Windows)
* the correct function name for double->double is fabs()
* drop volatile hack

Added sys.optimizer_switch_on() and sys.optimizer_switch_off()

2023-02-10T10:58:50+00:00

These are helpful tools to quickly see what optimizer switch options
are on or off.  The different options are displayed alphabetically

MDEV-29625 Some clients/scripts refer to old slow log variables

2022-10-04T10:28:04+00:00

MDEV-28632 Change default of explicit_defaults_for_timestamp to ON

2022-08-10T13:03:22+00:00

Merge branch '10.6' into 10.7

2022-05-18T08:34:38+00:00

MDEV-28342: sys.create_synonym_db fails when a temporary table masks a base table

2022-05-12T15:28:13+00:00

- This commit rely on MDEV-28391
- When temporary table shadows the base table, error is raised (it can be changed if needed),
  since the procedure is relying on creating the views and view cannot be created from the temporary table.

- Reviewed by:

Merge branch '10.6' into 10.7

2022-05-11T09:25:33+00:00

MDEV-28391: table_exists procedure fails when arguments contain escaped backticks as an quoted identifiers

2022-05-04T13:31:55+00:00

- When arguments to the procedure contain quote in the name, procedure fails with parsing error.
  The reason was because additional quoting is done when testing TEMPORARY table with the same name.
- Reviewed by:

MDEV-28344:sys.ps_setup_save and dependent procedures fail with ER_ILLEGAL_HA_CREATE_OPTION

2022-04-27T10:02:37+00:00

- The problem:
==============
- Commit f7216fa63d69448c3de1532a1dd197d0f28faefd created the check function for
  default temporary storage engine and in case the SE doesn't support temporary tables
  the error `ER_ILLEGAL_HA_CREATE_OPTION` is raised.
  Before that commit in such cases temporary tables were created by silently substituting
  default SE (RocksDB, Connect, PerfSchema) with MyISAM.
- The test `pr_diagnostics.test` was modified in that commit with raising the error,
  since I didn't check the root cause of test itself.

- The solution:
===============
- This commit update the root case: procedure `ps_setup_save()` that uses temporary
  tables created from performance schema tables definition using `LIKE`, what is not supported.
  The suggested fix is to use InnoDB table by using `AS SELECT`.
- Note that test `pr_diagnostics` will raise this error for `medium/full` third argument,
  but not for `current` value of third argument.
- Additionally this patch updates the test case of commit f7216fa, by adding missing relation
  between temporary tables and Performance schema in `perfschema.misc` test.

- Reviewed by: