Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
In this mode, a SELECT statement returns an error if it cannot be offloaded. row *************************** id: 1 select_type: SIMPLE table: flightschedule partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 9828 ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
The following shows what happens if parsing errors, formatting errors, or empty columns are found in a file during data loading, for each possible value of Strict mode: Default: The situation is handled according to the MySQL server's SQL mode ...
https://dev.mysql.com/doc/refman/8.4/en/gis-linestring-property-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-fault.html
In the following situations, Group Replication detects an error in distributed recovery, automatically switches over to a new donor, and retries the state transfer: Connection error - There is an authentication issue or another problem with making ... Group Replication's distributed recovery process has a number of built-in measures to ensure fault tolerance in the event of any problems during the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
MySQL checks the row size when the INSTANT algorithm adds a column, and throws the following error if the addition exceeds the limit. ERROR 4092 (HY000): Column can't be added with ALGORITHM=INSTANT as after this max possible row size crosses max ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
If any of the rows to be inserted by a given INSERT statement do not match one of the partitions listed, the INSERT statement fails with the error Found a row not matching the given partition set. If strict SQL mode is enabled, an INSERT statement ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
Possible causes include but are not limited to file system errors. If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. --force, -f Command-Line Format ...