Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
For boolean mode searches, index hints with FOR ORDER BY or FOR GROUP BY are silently ignored. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
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 first N bytes of the two values are compared, where N is the number of bytes ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
--no-login-paths Command-Line Format --no-login-paths Type Boolean Default Value false Skips reading options from the login path file. --no-defaults Command-Line Format --no-defaults Type Boolean Default Value false Do not read any option files.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
in_start_fresh BOOLEAN: Whether to reset all Performance Schema data before tracing. in_auto_setup BOOLEAN: Whether to disable all other threads and enable all instruments and consumers. Dumps all Performance Schema data for an instrumented thread ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
This span type has the following attributes: Name: Control trace_enabled: Boolean. logs_enabled: Boolean details: Session Span Issued when a client session ends, recording data relevant to that session from initial connection to close of session.
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3812; Symbol: ER_NON_BOOLEAN_EXPR_FOR_CHECK_CONSTRAINT; SQLSTATE: HY000 Message: An expression of non-boolean type specified to a check constraint '%s'. Error number: MY-010087; Symbol: ER_FT_BOOL_SYNTAX_INVALID; SQLSTATE: HY000 ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
is_null is a pointer to a boolean scalar, not a boolean scalar, to provide flexibility in how you specify NULL values: If your data values are always NULL, use MYSQL_TYPE_NULL as the buffer_type value when you bind the column. Prepared statements ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-opentelemetry.html
The OPT_OPENTELEMETRY option also accepts a Boolean value in which false corresponds to OTEL_DISABLED. false is the only accepted Boolean value for this option; setting it to true has no meaning and emits an error. For applications that use the ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
This section describe a number of features of Connector/J's support for replication-aware deployments. Such Connection objects report they are read-only, and isSourceConnection() returns false for them. The Connection tests for available source ...