diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2023-03-27 18:50:49 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2023-03-27 21:27:27 +0200 |
| commit | c2b69163934016afa4bb3b274cddaacec92fcb61 (patch) | |
| tree | e626bb791fdfb7438e1bdd340da47970926c95b9 /scripts/sys_schema/views/p_s/statements_with_sorting.sql | |
| parent | d9808f79de992964ed802d27984c9031d72e7b9a (diff) | |
| download | mariadb-git-c2b69163934016afa4bb3b274cddaacec92fcb61.tar.gz | |
MDEV-19629 post-merge fixesbb-11.0-serg
* 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
Diffstat (limited to 'scripts/sys_schema/views/p_s/statements_with_sorting.sql')
| -rw-r--r-- | scripts/sys_schema/views/p_s/statements_with_sorting.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/sys_schema/views/p_s/statements_with_sorting.sql b/scripts/sys_schema/views/p_s/statements_with_sorting.sql index 0216a12ed4d..a26910a0749 100644 --- a/scripts/sys_schema/views/p_s/statements_with_sorting.sql +++ b/scripts/sys_schema/views/p_s/statements_with_sorting.sql @@ -58,7 +58,7 @@ VIEW statements_with_sorting ( SELECT sys.format_statement(DIGEST_TEXT) AS query, SCHEMA_NAME db, COUNT_STAR AS exec_count, - sys.format_time(SUM_TIMER_WAIT) AS total_latency, + format_pico_time(SUM_TIMER_WAIT) AS total_latency, SUM_SORT_MERGE_PASSES AS sort_merge_passes, ROUND(IFNULL(SUM_SORT_MERGE_PASSES / NULLIF(COUNT_STAR, 0), 0)) AS avg_sort_merges, SUM_SORT_SCAN AS sorts_using_scans, |