Oracle create table with time zone doesn't work

[ancc]

Following create table statement is not recognized by the parser, which is valid statement for Oracle database.

from simple_ddl_parser import DDLParser
DDLParser("create table test (test_time timestamp(3) with time zone);").run()

result is empty list.

python version 3.9.5 simple-ddl-parser==0.29.1

[xnuinside]

@ancc , hm, https://github.com/xnuinside/simple-ddl-parser/blob/3d0ab28c1d41b02b03abff9b3a161d8d275cb014/tests/test_alter_statements.py#L1446 without worked )) weird, I will check why it does not produce output. Thanks for reporting the issue!

[wsmoak]

I have the same problem with sql dumped from a Postgres schema used by a Django app. The result is an empty list.

the_column timestamp with time zone

[xnuinside]

It was fixed in similar issue relative to PostgreSQL https://github.com/xnuinside/simple-ddl-parser/issues/250. Fix was released in version 1.3.1.