16.20 - Warning Response - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

A success or OK response with a warning indicates either that an anomaly has occurred or informs the user about the anomaly and indicates how it can be important to the interpretation of the results returned.

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.