Search Results
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. These privileges enable users to perform certain restricted multifactor authentication-related operations: A user who has the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 8.4 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. (Bug ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb_deferred_constraints: Specifies that constraint checks should be deferred (where these are supported).
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
You should use this option prior to inserting new rows into the database; otherwise, it is possible for a row to be inserted that later causes a unique constraint violation when trying to rebuild the indexes. The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
CHECK constraints cannot refer to columns that have the AUTO_INCREMENT attribute, nor can the AUTO_INCREMENT attribute be added to existing columns that are used in CHECK constraints. MySQL supports an extension for optionally specifying the ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
This constraint rules out mutually-recursive CTEs, where cte1 references cte2 and cte2 references cte1. These constraints come from the SQL standard, other than the MySQL-specific exclusions mentioned previously. A common table expression (CTE) is ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #33691659) InnoDB: An update operation attempted to update a virtual column while building an update node for a child table, but should not have done so since foreign key constraints cannot reference virtual columns. (Bug #115511, Bug ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-deferred-constraints: Specifies that constraint checks on unique indexes (where these are supported) should be deferred until commit time. ndb_deferred_constraints: Specifies that constraint checks should be deferred (where these are supported).
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
A loadable function contains code that becomes part of the running server, so when you write a loadable function, you are bound by any and all constraints that apply to writing server code. These constraints may change in future versions of the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-plugins.html
A server plugin contains code that becomes part of the running server, so when you write the plugin, you are bound by any and all constraints that otherwise apply to writing server code. These constraints may change in future versions of the server, ... To create a plugin library, you must provide the required descriptor information that indicates what plugins the library file contains, and write the interface functions for each ...