CREATE SCRIPT: TIMESTAMP(3) and improved syntax error messages

Details

Detail name Value
Changelog Number 19032
Type Improvement
Status Resolved
Fix Versions Exasol 8.25.0
Resolution Date 2024-02-15

Background

In Changelog 15378 we added the SQL syntax TIMESTAMP(3).

Improvement

  • The CREATE SCRIPT statement now also allows using the syntax TIMESTAMP(3) for parameters and return types in addition to the alias TIMESTAMP which already worked.
  • Invalid CREATE SCRIPT statements containing a syntax error now return better error messages. In particular the wording “syntax error” is now included. This affects all CREATE SCRIPT statements and is not limited to the TIMESTAMP data type, but it does not affect syntax errors within the script text included in the CREATE SCRIPT statement.

Changed behavior

Changed wording for many syntax error messages in the CREATE SCRIPT statement (no change for errors within the script text itself).