v.20.11New Feature
errorCodeToName function and system.errors table enhancements for better error analysis
errorCodeToNamefunction - return variable name of the error (useful for analyzing query_log and similar).system.errorstable - shows how many times errors has been happened (respectssystem_events_show_zero_values). #16438 (Azat Khuzhin).
Why it matters
This feature helps users analyze errors more effectively by providing a human-readable error name from error codes and offering aggregated error statistics through the system.errors table. It simplifies debugging and monitoring of query failures and system issues.How to use it
Use theerrorCodeToName function in queries to convert error codes to their variable names. Query the system.errors table to see how many times each error has occurred. The error counts respect the system_events_show_zero_values setting to include or exclude zero-value entries.