Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
bulk_loader.data_memory_size Command-Line Format --bulk_loader.data_memory_size=# System Variable bulk_loader.data_memory_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1073741824 Minimum Value 67108864 Maximum ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The execute_prepared_stmt_from_app_async routine creates an asynchronous task associated with a specific application user. Application-level asynchronous task lets you filter and track tasks for individual application users using an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
document_id: name of the optional integer column containing the document IDs. As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector search. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-error-messages.html
Error number: ML003073; SQLSTATE: HY000 Message: topk must be an integer value between 1 and length of the table, inclusively (1 <= topk <= 20). Example: ERROR HY000: ML003073: topk must be an integer value between 1 and length of the table, ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). Numeric evaluation occurs otherwise, with argument value conversion to ...
https://dev.mysql.com/doc/refman/8.4/en/arithmetic-functions.html
Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
audit_log_filter_id System Variable audit_log_filter_id Scope Global, Session Dynamic No SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 The session value of this variable indicates the internally ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY); -> '2008-02-02' mysql> SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY); -> '2008-02-02' When invoked with the days form of the second argument, MySQL treats it as an integer number of days to be ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
Otherwise, the result is an integer type (with one exception): If all integer types are all signed or all unsigned, the result is the same sign and the precision is the highest of all specified integer types (that is, TINYINT, SMALLINT, MEDIUMINT, ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
Cells in arrays are represented by [N], where N is a non-negative integer. BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE NULL For JSON values of the same precedence, the comparison rules are type specific: BLOB The ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...