Query Offload Fails On HeatWave Due To "Incorrect {DATA_TYPE} Value"
(Doc ID 2948056.1)
Last updated on JULY 22, 2024
Applies to:
MySQL Database Service - Version N/A and laterHeatWave on AWS - Version N/A and later
Information in this document applies to any platform.
Symptoms
When the query is complex, the query can fail due to an error like below:
The data type, "datetime" in this case, can be other data type such as DECIMAL. The details of the query above can be found in the manual: https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |