Skip to content

[Bug]: TrinoSQL returns an error if TIMESTAMP(P) WITH TIME ZONE is used #393

@mhamern

Description

@mhamern

Version

v4.0.2

Which SQL?

Trino

SQL content

SELECT CAST(DATE '2024-01-30' AS TIMESTAMP(6) WITH TIME ZONE)

JavaScript/TypeScript code

import { TrinoSQL } from 'dt-sql-parser';
const parser = new TrinoSQL();
const query = `SELECT CAST(DATE '2024-01-30' AS TIMESTAMP(6) WITH TIME ZONE)`;
const errors = parser.validate(query);
console.log(errors);

What happened?

The error is thrown only if timestamp is used with the precision parameter, for example SELECT CAST(DATE '2024-01-30' AS TIMESTAMP WITH TIME ZONE) is parsed correctly

Relevant log output

missing ')' at 'WITH'

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions