mariadb/scripts/sys_schema/procedures
Sergei Golubchik 62decb5e8b MDEV-12459 post-review fixes
* IS_USER_TEMP_TABLE() was misleading, name didn't match the code
* list of temp tables was rescanned number_of_databases times
* some temporary tables were not shown (from nonexistent databases)
* some temporary tables were shown more than once (e.g. after self-joins)
* sys.table_exists() - avoid querying I_S twice
* fix handling of temporary MERGE tables - it's pointless to fully open
  them, they're not in thd->temporary_tables, so they simply fail to
  open and are skipped. Relax the assertion instead.
2023-08-11 19:36:22 +02:00
..
create_synonym_db.sql MDEV-28343: sys.create_synonym_db fails with ER_VIEW_SELECT_TMPTABLE when schema contains temporary tables 2023-08-11 19:36:21 +02:00
diagnostics.sql MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
execute_prepared_stmt.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
optimizer_switch.sql Added sys.optimizer_switch_on() and sys.optimizer_switch_off() 2023-02-10 12:58:50 +02:00
ps_setup_disable_background_threads.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_disable_consumer.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_disable_instrument.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_disable_thread.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_enable_background_threads.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_enable_consumer.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_enable_instrument.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_enable_thread.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_reload_saved.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_reset_to_default.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_reset_to_default_57.sql Remove trailing space 2021-10-21 17:20:24 +02:00
ps_setup_reset_to_default_57_after.sql MDEV-9077 add sys_schema from https://github.com/mysql/mysql-sys 2021-03-18 08:02:29 +01:00
ps_setup_reset_to_default_57_before.sql MDEV-9077 add sys_schema from https://github.com/mysql/mysql-sys 2021-03-18 08:02:29 +01:00
ps_setup_save.sql MDEV-28344:sys.ps_setup_save and dependent procedures fail with ER_ILLEGAL_HA_CREATE_OPTION 2022-04-27 03:02:37 -07:00
ps_setup_show_disabled.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_show_disabled_consumers.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_show_disabled_instruments.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_show_enabled.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_show_enabled_consumers.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_setup_show_enabled_instruments.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_statement_avg_latency_histogram.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
ps_trace_statement_digest.sql MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
ps_trace_thread.sql MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
ps_trace_thread_57.sql MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
ps_truncate_all_tables.sql MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for views 2021-03-18 08:02:49 +01:00
statement_performance_analyzer.sql MDEV-19629 post-merge fixes 2023-03-27 21:27:27 +02:00
table_exists.sql MDEV-12459 post-review fixes 2023-08-11 19:36:22 +02:00