Type: New Feature
Fix Version/s: Exasol 7.1.0
We have added a new scalar function, TYPEOF which returns the SQL data type of its argument.
- Returns a normalized version of the type. For example, if a column is defined using the data type alias INT, TYPEOF returns DECIMAL(18,0).
- The type of any SQL expression is constant and the same for each row. Therefore, TYPEOF(expr) returns the same result for all rows, independent of the actual values of expression.
- The return type of function TYPEOF is VARCHAR(40) UTF8.