Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-details.html
Needs Attention: This status is displayed for the following reasons: The Channel is not replicating due to an error. Possible values are: Raise an error Allow Generate primary key: Allows replicating a CREATE TABLE or ALTER TABLE transaction with no ... Channel Details 8.7.1 Channel Details The Channel Details page contains the following tabs: Table 8-3 Tabs on the Channel Details Page Name Description Details Channel ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-troubleshooting-query-privatelink.html
Note:The error messages might read differently, as MySQL HeatWave on AWS gets updated. Table 6-1 Query PrivateLink: Common Issues and Resolutions Deployment Step Error Summary Steps to Resolve Create Query PrivateLink CreatePrivateLink: 1 Validation ... Troubleshooting a Query PrivateLink 6.1.5 Troubleshooting a Query PrivateLink Table 6-1 lists some common issues and their resolutions when setting up a Query PrivateLink, and Troubleshooting Connectivity in your AWS Account Using the AWS Reachability Analyzer for a Query PrivateLink gives further help for ...
https://dev.mysql.com/doc/connector-j/en/connector-j-schema-validation.html
This is done by specifying a JSON Schema during Collection creation or modification; schema validation is then performed by the server at a document creation or update, and an error is returned if the document does not validate against the assigned ... When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
By default, an error occurs if you try to modify a user that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each named user that does not exist, rather than an error. Operations performed by a restricted ...
https://dev.mysql.com/doc/refman/8.4/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...In other cases, when a collation description is generally correct but contains some unknown tags, the collation is initialized and is available for ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. You have to change some ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-enum.html
An error occurs for values that do not satisfy these conditions: An ENUM value must be one of those listed in the column definition, or the internal numeric equivalent thereof. The value cannot be the error value (that is, 0 or the empty string).
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. The basic philosophy is that MySQL Server tries to produce an error for anything that ... MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
IF NOT EXISTS has the same meaning for CREATE EVENT as for CREATE TABLE: If an event named event_name already exists in the same schema, no action is taken, and no error results. CREATE EVENT statements which are themselves invalid—for whatever ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
If the routine name is the same as the name of a built-in SQL function, a syntax error occurs unless you use a space between the name and the following parenthesis when defining the routine or invoking it later. IF NOT EXISTS prevents an error from ...By default, a stored routine is associated with the default ...