Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
However, later reads from the table might report warnings or errors for the column if values are out of range. If an out-of-range or any other error occurs, the statement fails. If expression evaluation causes truncation or provides incorrect input ... ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log plugin must be enabled or an error occurs. In addition, the audit tables must exist or an error ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
If you attempt to set audit_log_exclude_accounts, an error occurs unless audit_log_include_accounts is NULL. audit_log_connection_policy: Logging policy for connection events audit_log_statement_policy: Logging policy for statement events Each ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Trying to switch the replication format in any of these cases (or attempting to set the current replication format) results in an error. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
However, the server does not send the public key to the client, and the client provided no public key, so it cannot encrypt the password and the connection fails: ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. For those cases where trailing pad characters are stripped or comparisons ignore them, if a ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
If both sides have the same coercibility, then: If both sides are Unicode, or both sides are not Unicode, it is an error. For example, the following statement does not return an error: SELECT CONCAT(utf8mb4_column, latin1_column) FROM t1; It returns ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-installation.html
In such cases, attempting to restart the server with plugin-load-add=mysql_clone.so raises the error [ERROR] [MY-013238] [Server] Error installing plugin 'clone': Cannot install during upgrade. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS ... This section describes how to install and configure the clone ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for ...
https://dev.mysql.com/doc/refman/8.4/en/components.html
MySQL distributions include several components that implement server extensions: Components for configuring error logging. See Section 7.4.2, “The Error Log”, and Section 7.5.3, “Error Log Components”. For example, the log_filter_dragnet ...