search

drawdb-io / drawdb

Free, simple, and intuitive online database diagram editor and SQL generator.
https://drawdb.app
GNU Affero General Public License v3.0
22.7k stars 1.58k forks source link

[BUG] PostgreSQL, Import from SQL TIMESTAMPTZ parsing fail #232

Closed Erim32 closed 1 month ago

Erim32 commented 2 months ago

Issue using "import form SQL" feature with PostgreSQL : TIMESTAMPTZ

How to reproduce

image

CREATE TABLE DEMO (
    test TIMESTAMPTZ NOT NULL
);

Fail

But if the datatype is VARCHAR:

CREATE TABLE DEMO (
    test VARCHAR NOT NULL
);

image

OK

1ilit commented 2 months ago

Yes, it was fixed in this PR https://github.com/taozhi8833998/node-sql-parser/pull/2063. It will be supported once v5.4.0 comes out