TIMESTAMP(6) was an alias for TIMESTAMP(3)

Detail name	Value
Changelog Number	13712
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0
Fix Versions	Exasol 8.32.0
Resolution Date	2024-11-08

Description

TIMESTAMP(6) datatype used to be an alias for datatype TIMESTAMP(3).

Workaround

There is no workaround because previous database versions had no TIMESTAMP(6) data type.

Fix

There is now a proper TIMESTAMP(6) data type. Please notice, that the behavior of pre-existing usage of TIMESTAMP(6) is affected depending on when it was interpreted: Columns created in a previous database version as TIMESTAMP(6), i.e., TIMESTAMP(3), keep their type unchanged as TIMESTAMP(3). Same for script parameter/return types. But any usage of TIMESTAMP(6) within a script/view text will now actually be interpreted as TIMESTAMP(6) instead of TIMESTAMP(3).

Changed behavior

TIMESTAMP(6) is no longer an alias for TIMESTAMP(3).