Search Results
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1094; Symbol: HW_ER_UNSUPPORTED_NONPRIMITIVE_GBY_MODIFIER_WITH_DISTINCT_IN_ITEM Message: %s in combination with [%s], in [%s], is not supported. Description: The support for this combination of different functionalities is absent in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. schema_name (VARCHAR(255)): specifies the schema to run the given SQL statements. If the schema is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Importing a table that does not explicitly define a row format results in a schema mismatch error if the innodb_default_row_format setting on the source server differs from the setting on the destination server. The row format of a table determines ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. Message ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
Note Do not use the external_tables option as of MySQL 8.4.0. The Auto Parallel Load external_tables option is a JSON array that includes one or more db_object items. It allows you to set the details for schemas and tables to load. Syntax Examples ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
Solution A: Your query contains an unsupported predicate, function, operator, or has encountered some other limitation. Solution B: Query execution time is less than the query cost threshold. MySQL HeatWave is designed for fast execution of large ...