Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
This is true even for strings that are preceded by an introducer that indicates a different character set, as discussed in Section 12.3.6, “Character String Literal Character Set and Collation”. The \% and \_ sequences are used to search for ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. | ...The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
WITH followed by WITH at the same level is not permitted, so this is illegal: WITH cte1 AS (...) WITH cte2 AS (...) SELECT ... This is illegal: WITH cte1 AS (...), cte1 AS (...) SELECT ... This constraint rules out mutually-recursive CTEs, where ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
This is potentially the fastest way for mysqlbackup to create incremental backups. If this value has been set explicitly but page tracking cannot be used, the backup fails with an error. Some restrictions apply when this option is employed; see ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-single-file-options.html
If this is not specified, operating system-specific search methods are used to locate libobk.so (UNIX) or orasbt.dll (Windows). This option specifies the destination path for the entry selected from the backup image by --src-entry. You use them in ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
If a table containing full-text search (FTS) index is backed up using transportable tablespace (TTS), after it is restored, the FTS index will be corrupted. Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-certs.html
A cluster process uses the certificate from the process as specified by the ndb_mgm --ndb-tls-search-path option. create certs [--ca|--keys] [--added] cluster_name The command creates all certificate authorities (CAs), keys, and certificate files ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
See Case Sensitivity in String Searches for more information about case-sensitivity issues in MySQL Cluster Manager. In such cases, you must use a special process specification syntax; see Setting TCP Connection Attributes, for information about how ...Attributes can be set on either the process level or instance ...