Skip to content

Wrong report of syntax error if FORMAT clause is used #8455

Open
@aafemt

Description

@aafemt

Following query reports correct error (except "source column" part):

SQL> select cast('1-1-1 1:1:1.1' as abc) from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -607
-Invalid command
-Specified domain or source column ABC does not exist

Following error is incorrect:

SQL> select cast('1-1-1 1:1:1.1' as abc format 'yyyy-mm-dd hh24:mi:ss.ff4') from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 36
-format

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions