A success or OK response with a warning indicates that an anomaly has occurred or informs the user of the anomaly and its importance to interpreting the results.
Example: Returning Message about Nulls
Assume the current session is running in ANSI session mode.
If nulls are included in the data for column f1, then the following interactive query returns the successful response message with a warning about the nulls.
SELECT AVG(f1) FROM Inventory;
*** Query completed. One row found. One column returned. *** Warning: 2892 Null value eliminated in set function. *** Total elapsed time was 1 second. Average(f1) ----------- 14
This warning response is not generated if the session is running in Teradata session mode.