My Oracle Support Banner

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 later
HeatWave 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.