search

xnuinside / simple-ddl-parser

Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. & table properties, types, domains, etc.
MIT License
179 stars 40 forks source link

Oracle create table with time zone doesn't work #181

Closed ancc closed 3 months ago

ancc commented 1 year ago

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 commented 1 year ago

@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 commented 5 months ago

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 commented 3 months ago

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.