Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
Run the HEATWAVE_LOAD command with the characteristics of the input_list in normal mode to automatically create the external table and load data into the table. See Load Structured Data Using Lakehouse Auto Parallel Load for more information about ... You can use Auto Parallel Load to set up the automatic creation of an external table along with the loading of data from files in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually with is_strict_mode set to false. Tip If you need to manually create a table ... MySQL HeatWave Lakehouse has the following limitations for Parquet ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
To use the mode argument, the mode value must be defined explicitly. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() Bit functions ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
You can run the following routines as needed with no changes: ML_TRAIN ML_MODEL_LOAD ML_EXPLAIN ML_PREDICT_TABLE ML_EXPLAIN_TABLE ML_SCORE If you run ML_PREDICT_ROW or ML_EXPLAIN_ROW on data loaded from Object Storage, you cannot use a FROM clause.
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26-u2.html
Functionality Added or Changed The following function support was added: YEARWEEK(date), YEARWEEK(date,mode) The mode argument for the two-argument form of the WEEK() function: WEEK(date[,mode]) MAKEDATE() “Zero” handling for dates such as ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For cases of truncation, to cause an error to occur (rather ... The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-like.html
This means that if the current SQL mode is different from the mode in effect when the original table was created, the table definition might be considered invalid for the new mode and cause the statement to fail. LIKE to create an empty table based ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. How AUTO_INCREMENT behaves depending on the NO_AUTO_VALUE_ON_ZERO SQL mode: Section 7.1.11, “Server SQL Modes”.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...