Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-validation.html
Schema validation is performed by the server, which returns an error message if a document in a collection does not validate against the assigned JSON schema. If a document does not validate, the server generates an error and the operation fails.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/preface.html
Warranty Disclaimer The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. This is the X DevAPI User Guide for MySQL Shell in Python ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-savepoints.html
For example, consider the following statements with no explicit BEGIN, session.startTransaction() or similar call: session.setSavepoint('testsavepoint'); session.releaseSavepoint('testsavepoint'); If autocommit mode is enabled on the server, these ... X DevAPI supports savepoints, which enable you to set a named point within a transaction that you can revert ...
https://dev.mysql.com/doc/heatwave/en/heatwave-system-variables.html
If you encounter out of memory errors when running a query, try running the query with the MIN_MEM_CONSUMPTION strategy by setting by setting rapid_execution_strategy prior to executing the query: SET SESSION rapid_execution_strategy = ...Most MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.14.2, “Refresh Data Using Incremental Load”. MySQL 8.4.0 adds support for the following: An input_list JSON array replaces the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
Set to false to disable truncation and instead throw an error when a text segment that is too large for the embeeding model is found. In this case, the entire load fails and exits with an error. This section describes how to generate vector ...