1.10.0

Added

• Added supports for Python 3.9

Fixed

• Fixed parsing of columns with NULL/NOT NULL constraint.

1.9.0

Added

• Add supports Cloud Spanner data-type.
  • STRING
  • BYTES
• Add supports MySQL data-type.
  • BINARY
  • VARBINARY
• Add supports PostgreSQL data-type.
  • BYTEA

1.8.0

Added

• Add DdlParseColumn.character_set property.
• Add supports for parsing MySQL FOREIGN KEY options MATCH, ON DELETE and ON UPDATE

1.7.0

Added

• Add DdlParseColumn.default property.
• Add DdlParseColumn.auto_increment property.
• Add DdlParseColumn.encode property.
• Add DdlParseColumn.distkey property.
• Add DdlParseColumn.sortkey property.

Changed

• Enhancement parse of Redshift DDL.

Fixed

• Fix parse of column name with space character.
• Change Email Address.

1.6.1

Fixed

• Fix parse Redshift ENCODE attribute.

1.6.0

Added

• Add property.
  • DdlParseColumn.is_unsigned
  • DdlParseColumn.is_zerofill
• Add supports for numeric type attributes of MySQL.
  • UNSIGNED
  • ZEROFILL
• Add supports MySQL data-type.
  • TINYINT
  • SMALLINT
  • MEDIUMINT
  • DEC
  • FIXED

Fixed

• Miner fix.

1.5.0

Added

• Add supports for Python 3.8

Removed

• End of support for Python 3.4

Fixed

• Fix parse for column-constraint.
• Miner fix.

1.4.0

Added

• Add supports to BigQuery NUMERIC data type.

Data-type Conditions

BigQuery Data Type	Source Data Type	Precision	Scale	Database	Exapmle Source Data Type
INT64	(NUMERIC|NUMBER|DECIMAL)	< 19	= 0	-	NUMERIC(18)
FLOAT64	(NUMERIC|NUMBER|DECIMAL)	< 19	> 0	-	NUMERIC(18, 1)
NUMERIC	(NUMERIC|NUMBER|DECIMAL)	>= 19	-	-	NUMERIC(19)
NUMERIC	(NUMERIC|NUMBER|DECIMAL)	*	-	-	NUMBER(*, 0)
INT64	(NUMERIC|NUMBER|DECIMAL)	None	-	default	DECIMAL
NUMERIC	(NUMERIC|NUMBER|DECIMAL)	None	-	DdlParse.DATABASE.oracle DdlParse.DATABASE.postgresql	NUMBER NUMERIC

Fixed

• Fix parsing failure for include (*) format of Oracle NUMBER data type.

1.3.1

Fixed

• Fixed parsing failure for columns include dot at default values.

1.3.0

Added

• Add supports the parse of COMMENT statements.
• Add DdlParseColumn.comment property.
• Add DdlParseColumn.description property for the DdlParseColumn.comment property alias.
• Add supports column comments in BigQuery DDL.