Skip to content

Tags: xnuinside/simple-ddl-parser

Tags

v1.5.1

Toggle v1.5.1's commit message
**v1.5.1**

1. Added support for INDEX statement in column definition - #253

v1.5.0

Toggle v1.5.0's commit message
**v1.5.0**

1. Now, `unique` set up to column only if it was only one column in unique constraint/index. Issue - #255
2. Fixed issue when UNIQUE KEY was identified as primary key - #253

v1.4.0

Toggle v1.4.0's commit message
**v1.4.0**

1. Indexes without schema causes issues in BigQuery dialect - fixed.

1. Added new output keywords in table definition - `temp` & `is_global`. Added support for create global temporary table - #182

v1.3.0

Toggle v1.3.0's commit message
**v1.3.0**

PostgreSQL:
1.  Timezone was moved out from type definition to keyword 'with_time_zone' it can be True (if with time zone) or False (if without)
BigQuery:
1. Previously Range in RANGE_BUCKETS was parsed as a columns, now this behaviour is changed and
range placed in own keyword - 'range' (can be array or str).
Also for all ``*_TRUNC PARTITIONS` like DATETIME_TRUNC, TIMESTAMP_TRUNC, etc, second argument moved to arg 'trunc_by'

PostgreSQL:
1. Added support for PostgreSQL with / without time zone - #250

BigQuery:
1. Added support for GENERATE_ARRAY in RANGE_BUCKETS #183

v1.2.1

Toggle v1.2.1's commit message
**v1.2.1**

MySQL:
1. Fixed issue relative to auto_increment that caused empty output if auto_increment defined in table properties -
#206

MySQL:
1. auto_increment added as property to mysql output

Oracle:
1. Added support for  constraint name in column definition - #203
2. Added support for GENERATED (ALWAYS | (BY DEFAULT [ON NULL])) AS IDENTITY in column definition

PostgreSQL:
1. Added support for CAST statement in column GENERATE ALWAYS expression - #198

v1.1.0

Toggle v1.1.0's commit message
**v1.1.0**

MySQL:
1. Added support for INDEX statement inside table definition
2. Added support for MySQL INVISIBLE/VISIBLE statement - #243

Snowflake:
1. Added support for cluster by statement before columns definition - #234

v1.0.4

Toggle v1.0.4's commit message
**v1.0.4**

1. Support functions with schema prefix in `DEFAULT` and `CHECK` statements. #240
1. Fix for REFERENCES NOT NULL - #239
2. Fix for snowflake stage name location format bug fix - #241

v1.0.3

Toggle v1.0.3's commit message
**v1.0.3**

1. Fixed bug with `CREATE OR REPLACE SCHEMA`.
2. Added support of create empty tables without columns CREATE TABLE tablename (); (valid syntax in SQL)

1. Fixed bug with snowflake `stage_` fileformat option value equal a single string as `FIELD_OPTIONALLY_ENCLOSED_BY = '\"'`, `FIELD_DELIMITER = '|'`
2. improve snowflake fileformat key equals value into dict. type.

v1.0.2

Toggle v1.0.2's commit message
**v1.0.2**

1. Fixed bug with places first table property value in 'authorization' key. Now it is used real property name.
2. Fixed typo on Databricks dialect
3. improved equals symbols support within COMMENT statement.
4. turn regexp into functions

1. UNSIGNED property after int parsed validly now

1. Snowflake TAG now available on SCHEMA definitions.

v1.0.1

Toggle v1.0.1's commit message
**v1.0.1**

1. When using `normalize_names=True` do not remove `[]` from types like `decimal(21)[]`.
2. When using `normalize_names=True` ensure that `"complex"."type"` style names convert to `complex.type`.