Search Results
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. AUTHENTICATION_POLICY_ADMIN The authentication_policy system variable places certain constraints on how the authentication-related clauses of ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
Beginning with MySQL Workbench 8.0.17, the ANTLR4 grammar was updated to handle the language features of each supported MySQL server version from MySQL 5.6 to MySQL 8.0, including the following new language features in MySQL Server 8.0.17: CHECK ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "delta"}, "file": [{"uri": "oci://mybucket@mynamespace/data_files/"}]}'; check_constraints: Supported as of MySQL 8.4.0. Lakehouse ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
These additional privilege considerations also apply: The authentication_policy system variable places certain constraints on how the authentication-related clauses of ALTER USER statements may be used; for details, see the description of that ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
Constraints on Audit Log Filtering Functions Audit log filtering functions are subject to these constraints: To use any filtering function, the audit_log plugin must be enabled or an error occurs. Note For audit log filtering to work as described ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
A foreign key constraint on a stored generated column cannot use CASCADE, SET NULL, or SET DEFAULT as ON UPDATE referential actions, nor can it use SET NULL or SET DEFAULT as ON DELETE referential actions. A foreign key constraint on the base column ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
These additional privilege considerations also apply: The authentication_policy system variable places certain constraints on how the authentication-related clauses of CREATE USER statements may be used; for details, see the description of that ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
Does NDB Cluster support foreign keys? NDB Cluster provides support for foreign key constraints which is comparable to that found in the InnoDB storage engine; see Section 1.7.3.2, “FOREIGN KEY Constraints”, for more detailed information, as ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Multi-primary mode groups (members all configured with group_replication_single_primary_mode=OFF) do not support tables with multi-level foreign key dependencies, specifically tables that have defined CASCADING foreign key constraints. This is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction. The ...