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
175 stars 40 forks source link

VISIBLE keyword causes parser error #243

Closed timothy-r closed 3 months ago

timothy-r commented 4 months ago

Describe the bug Reading an SQL DDL that uses the VISIBLE keyword causes an error and the entire table definition is not read

To Reproduce Steps to reproduce the behavior:

  1. Write an SQL create table statement with an index that uses the VISIBLE keyword
  2. Read the SQL with the ddl parser
  3. See the error generated

Expected behavior DDL parser should read SQL DDL statements with the VISIBLE keyword

xnuinside commented 4 months ago

@timothy-r hello, thanks for opening the issue, can you send an example of SQL with this keyword?

xnuinside commented 3 months ago

released in version 1.1.0, added in PR: https://github.com/xnuinside/simple-ddl-parser/pull/246/files if will be needed anything else - feel fre to re-open this issue or create new one