Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-inbound-replication-limitations.html
Using a root@localhost or administrator user in the DEFINER clause of CREATE PROCEDURE and CREATE FUNCTION statements is not supported. Instead, create a dedicated user with the privileges required to run the statements, and then edit the statements ... Limitations 8.8 Limitations Inbound replication in MySQL HeatWave on AWS does not support some of the configurations that are possible for MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
This option applies only to prepared statements, callable statements or updatable result sets. This option applies only to prepared statements, callable statements or updatable result sets. connectionTimeZone Configures the connection time zone ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value random Since Version 5.0.6 loadBalanceAutoCommitStatementRegex When load-balancing is enabled for auto-commit statements (via 'loadBalanceAutoCommitStatementThreshold'), the statement counter will only increment when the SQL matches ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. In SHOW statement results, user names and host names are quoted using backticks (`). To ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
If you prefer to run the update statements only for the MySQL Enterprise Audit tables, see the following discussion. This is necessary because the INSTALL PLUGIN statement in the script is not replicated. On each replica node, extract the INSTALL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. Contents of files referenced by ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in the same column of the results of these operations would be in different character sets. If you want the ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the statement. The options MySQL has when ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...