Data Type DOUBLE PRECISION is inconsistently displayed as DOUBLE

Detail name	Value
Changelog Number	14622
Type	Bug
Status	Open
Affected Versions	EXASOL 6.0.0, Exasol 6.1.0, Exasol 7.0.0, Exasol 7.1.0

Background

In line with our documentation as well as the SQL Standard, the name of this data type is DOUBLE PRECISION.

DOUBLE on the other hand is just an alias in Exasol.

Description

Some operations display the type DOUBLE instead of the correct DOUBLE PRECISION.

Preparation:

create schema test;
create table t(d double precision);
insert into t values 1.0;

Examples showing the incorrect name DOUBLE:

describe t;
-- D	DOUBLE	TRUE	FALSE	FALSE

select column_type, column_type_id from exa_dba_columns where column_table='T';
-- DOUBLE	8

select typeof(d) from t;
-- DOUBLE

Examples showing the correct name DOUBLE PRECISION:

select type_name from exa_sql_types where type_id=8;
-- DOUBLE PRECISION

Fix

All operations display the correct name DOUBLE PRECISION.
This affects System tables, DESCRIBE, and TYPEOF-function showing DOUBLE PRECISION for the data type where they previously showed DOUBLE.

Changed behavior