Skip to content

Latest commit

 

History

History
264 lines (231 loc) · 32.4 KB

CHANGELOG.md

File metadata and controls

264 lines (231 loc) · 32.4 KB
Raw

Changelog

All notable changes to this project will be documented in this file. See commit-and-tag-version for commit guidelines.

0.3.0 (2024-04-18)

⚠ BREAKING CHANGES

  • The (ordered_columns) node in the create_index statement has been replaced with (index_fields), with (field) child nodes which can have column: (_), expression: (_) or function: (_) named child nodes.

Features

  • add binary and string datatypes for hive (2132493)
  • add default_timestamp option (6ba8901)
  • add filter to aggregate_functions (7a5ad78)
  • add insert overwrite from spark sql (65b6f18)
  • Add AST-fields for row terminated/escaped-by and lines terminated-by (d2f0f66)
  • add binary between expression (a8622bb)
  • add bit datatype (fb1895e)
  • add CAD database, Alter index, CAD USER/ROLE/GROUP (ce4cadc)
  • add CAD sequence, variant for alter index/database (56e6d6b)
  • Add checking for MISSING and UNEXPECTED in addition to ERROR in the test (9308ce9)
  • Add complex index fields to CREATE INDEX statements (97806c5)
  • Add create extension statement. (87c1401)
  • Add create trigger statement for postgres. (e0922d7)
  • add custom type handling (742b68f)
  • Add dollar quoted string. (c16e729)
  • add drop index statement (781d58d)
  • add explain, truncate and alter/drop/create schema (d4acced)
  • add float parsing (cd17cd0)
  • Add MariaDB/MySQL ADD|CHANGE|MODIFY ... FIRST|AFTER ... (393e0d3), closes #83
  • Add MariaDB/MySQL ALTER TABLE ... CHANGE ... (1124c51), closes #82
  • Add MariaDB/MySQL ALTER TABLE ... MODIFY ... (409be47), closes #89
  • Add missing (postgres) operators. (16f299b)
  • add more options to pg views (3cb1ee6)
  • Add more string litral formats (from postgres) and numbers foramts (cab76b7)
  • add mysql rename statement (0707eaa)
  • add natural join (d12b869)
  • add natural join (64c263d)
  • Add ONLY for ALTER TABLE statement. (1a2b0da)
  • add optional interval direction (66d5b2c)
  • add parenthesized select and cte select statements (b645f8c)
  • add parse floats (b6ea645)
  • add recursive cte (c0f7f31)
  • Add REFERENCES column constraint to CREATE TABLE statements (379f473)
  • Add set operation (select ... union select ...) for insert statements. (970b548)
  • Add storage parameters to table definition. (531d243)
  • add t-sql types (c8825be)
  • add unsigned int|integer (7a8c988)
  • add unsigned integer casts (d19d5fb)
  • add vacuum (bf8edb4)
  • adds merge into upsert statements (61760bb)
  • allow parenthesis around CTE (0f3f25e)
  • Change $._key_constraint to use $.ordered_columns instead of a simple list (2f8b9dd)
  • Change literal lexing to use regexp to reduce parser number of states. (269580d)
  • create function (2964438)
  • mariadb supports limit in group_concat (bb372ec)
  • nested common table expressions (9d66f30)
  • optimize athena tables (f3c3515)
  • optimize metadata on impala/hive (b620971)
  • Optional COLUMN in ALTER TABLE (a2533b2)
  • pg: add interval casting and selection (c7ff747)
  • pg: create columns as array and matrices (3877ef6)
  • postgresql expression subscripts (c54eff2)
  • sets: Dedicated node with optional parens for set operations (899321d)
  • Support negative integers as literals (756ffc2)
  • support NOT IN (1f61923)
  • support single quotes in string literals (3e8a84f)
  • Test ALTER TABLE with elided COLUMN keyword (bd25587)
  • tests: Add highlight tests (418c981)
  • tsql multiple add columns in alter statement (97fc151)

Bug Fixes

  • _set_value choice (17b3f10)
  • check option as extra keyword nodes (for better highlighting) (8528a09)
  • generated always should accept expressions (1695b30)
  • add comment (2e48958)
  • add cte to create tab/view/mat_view (bfe1823)
  • Add missing option 'no maxvalue' and 'no minvalue' to CREATE SEQUENCE. (bec206c)
  • add unique constraint (closes #249) (0e6c5f8)
  • alias _qualified_field into assignment (e7f1c4a)
  • Alter table with unique constraint with postgres syntaxe work and keep the (23cca53)
  • alter/create sequence with no cache (bcd61d6)
  • assignment change from identifier to field (713ff4d)
  • case when with between statement (bdf5dd0)
  • Change string lexer to have two token dollar_quoted_string_start_tag and (646c3ab)
  • Change the dollar string lexer to produce 3 token dollar_quoted_string_start_tag, dollar_quoted_string_end_tag and (39215fd)
  • ci: pin node-gyp to v10 (0aaf90a)
  • column: better anonymous node for columns (727df9f)
  • Correct CREATE TYPE to accept also a schema as identifier. (c223823)
  • correct test condition (cde7200)
  • Correct tests. (9e17b93)
  • correct window clause placement (c67da1b)
  • distinct and order by in invocation (fae579b)
  • ensure scanner.c is included in npm package (ec6bb68)
  • impala partitioning variation (eed38f2)
  • kludge around statement delimiters for now (30668da)
  • Lift ALTER TABLE combination restriction (only Postgres) (be20ed0), closes /github.com/DerekStride/tree-sitter-sql/issues/82#issuecomment-1416227381
  • Make timestamp type a parametric type. (2f5d0cd)
  • Missing identifier as value of a SET statement. (1e3f464)
  • Modify custom type to accept a schema prefix. (f75b8ea)
  • Move the expect tests to fail from functions.txt into errors.txt. (9cc4850)
  • parses parens in create table statement (b3af454)
  • partially quoted expression (dea9b69)
  • pg array function (6df5ec8)
  • remove duplicated keyword (8d80c7b)
  • Remove identifier alias from cast builtin function (e4e43ba)
  • Remove identifier alias from count builtin function (eac9da2)
  • remove typo in npm publish workflow (a1cf63b)
  • replace lua-match with match in highlights.scm (e69a1e6)
  • Replace identifier with literal for hive storage location and cache pool (4216ecf)
  • scanner: do not allow whitespaces in dollar quote tag (11d47fe)
  • segfault in scanner.c (515d346)
  • set create table precedence to avert conflicts between (a1a7275)
  • subquery unions & invalid tests (0f02bbd)
  • support qualified all_fields (bb7d8c4)
  • test: avoid use of newline character (fe2dd42)
  • The scannar can now scan tag name with any (expected '$') ASCII char instead of only letters. (dbe4c04)
  • Update gh-pages.yml (1bd7855)
  • use keyword_language in grammar (07e6245)

0.2.0 (2023-12-15)

⚠ BREAKING CHANGES

  • The (ordered_columns) node in the create_index statement has been replaced with (index_fields), with (field) child nodes which can have column: (_), expression: (_) or function: (_) named child nodes.

Features

  • Add complex index fields to CREATE INDEX statements (97806c5)
  • postgresql expression subscripts (c54eff2)

Bug Fixes

  • ci: pin node-gyp to v10 (0aaf90a)
  • ensure scanner.c is included in npm package (ec6bb68)
  • The scannar can now scan tag name with any (expected '$') ASCII char instead of only letters. (dbe4c04)

0.1.1 (2023-11-22)

Features

  • Add REFERENCES column constraint to CREATE TABLE statements (379f473)

Bug Fixes

  • remove typo in npm publish workflow (a1cf63b)

0.1.0 (2023-11-14)

Features

  • add binary and string datatypes for hive (2132493)
  • add default_timestamp option (6ba8901)
  • add filter to aggregate_functions (7a5ad78)
  • add insert overwrite from spark sql (65b6f18)
  • Add AST-fields for row terminated/escaped-by and lines terminated-by (d2f0f66)
  • add binary between expression (a8622bb)
  • add bit datatype (fb1895e)
  • add CAD database, Alter index, CAD USER/ROLE/GROUP (ce4cadc)
  • add CAD sequence, variant for alter index/database (56e6d6b)
  • Add checking for MISSING and UNEXPECTED in addition to ERROR in the test (9308ce9)
  • Add create extension statement. (87c1401)
  • Add create trigger statement for postgres. (e0922d7)
  • add custom type handling (742b68f)
  • Add dollar quoted string. (c16e729)
  • add drop index statement (781d58d)
  • add explain, truncate and alter/drop/create schema (d4acced)
  • add float parsing (cd17cd0)
  • Add MariaDB/MySQL ADD|CHANGE|MODIFY ... FIRST|AFTER ... (393e0d3), closes #83
  • Add MariaDB/MySQL ALTER TABLE ... CHANGE ... (1124c51), closes #82
  • Add MariaDB/MySQL ALTER TABLE ... MODIFY ... (409be47), closes #89
  • Add missing (postgres) operators. (16f299b)
  • add more options to pg views (3cb1ee6)
  • Add more string litral formats (from postgres) and numbers foramts (cab76b7)
  • add mysql rename statement (0707eaa)
  • add natural join (d12b869)
  • add natural join (64c263d)
  • Add ONLY for ALTER TABLE statement. (1a2b0da)
  • add optional interval direction (66d5b2c)
  • add parenthesized select and cte select statements (b645f8c)
  • add parse floats (b6ea645)
  • add recursive cte (c0f7f31)
  • Add set operation (select ... union select ...) for insert statements. (970b548)
  • Add storage parameters to table definition. (531d243)
  • add t-sql types (c8825be)
  • add unsigned int|integer (7a8c988)
  • add unsigned integer casts (d19d5fb)
  • add vacuum (bf8edb4)
  • adds merge into upsert statements (61760bb)
  • allow parenthesis around CTE (0f3f25e)
  • Change $._key_constraint to use $.ordered_columns instead of a simple list (2f8b9dd)
  • Change literal lexing to use regexp to reduce parser number of states. (269580d)
  • create function (2964438)
  • mariadb supports limit in group_concat (bb372ec)
  • nested common table expressions (9d66f30)
  • optimize athena tables (f3c3515)
  • optimize metadata on impala/hive (b620971)
  • Optional COLUMN in ALTER TABLE (a2533b2)
  • pg: add interval casting and selection (c7ff747)
  • pg: create columns as array and matrices (3877ef6)
  • sets: Dedicated node with optional parens for set operations (899321d)
  • Support negative integers as literals (756ffc2)
  • support NOT IN (1f61923)
  • support single quotes in string literals (3e8a84f)
  • Test ALTER TABLE with elided COLUMN keyword (bd25587)
  • tests: Add highlight tests (418c981)
  • tsql multiple add columns in alter statement (97fc151)

Bug Fixes

  • _set_value choice (17b3f10)
  • check option as extra keyword nodes (for better highlighting) (8528a09)
  • generated always should accept expressions (1695b30)
  • add comment (2e48958)
  • add cte to create tab/view/mat_view (bfe1823)
  • Add missing option 'no maxvalue' and 'no minvalue' to CREATE SEQUENCE. (bec206c)
  • alias _qualified_field into assignment (e7f1c4a)
  • Alter table with unique constraint with postgres syntaxe work and keep the (23cca53)
  • alter/create sequence with no cache (bcd61d6)
  • assignment change from identifier to field (713ff4d)
  • case when with between statement (bdf5dd0)
  • Change string lexer to have two token dollar_quoted_string_start_tag and (646c3ab)
  • Change the dollar string lexer to produce 3 token dollar_quoted_string_start_tag, dollar_quoted_string_end_tag and (39215fd)
  • column: better anonymous node for columns (727df9f)
  • Correct CREATE TYPE to accept also a schema as identifier. (c223823)
  • correct test condition (cde7200)
  • Correct tests. (9e17b93)
  • correct window clause placement (c67da1b)
  • distinct and order by in invocation (fae579b)
  • impala partitioning variation (eed38f2)
  • kludge around statement delimiters for now (30668da)
  • Lift ALTER TABLE combination restriction (only Postgres) (be20ed0), closes /github.com/DerekStride/tree-sitter-sql/issues/82#issuecomment-1416227381
  • Make timestamp type a parametric type. (2f5d0cd)
  • Missing identifier as value of a SET statement. (1e3f464)
  • Modify custom type to accept a schema prefix. (f75b8ea)
  • Move the expect tests to fail from functions.txt into errors.txt. (9cc4850)
  • parses parens in create table statement (b3af454)
  • partially quoted expression (dea9b69)
  • pg array function (6df5ec8)
  • remove duplicated keyword (8d80c7b)
  • Remove identifier alias from cast builtin function (e4e43ba)
  • Remove identifier alias from count builtin function (eac9da2)
  • replace lua-match with match in highlights.scm (e69a1e6)
  • Replace identifier with literal for hive storage location and cache pool (4216ecf)
  • set create table precedence to avert conflicts between (a1a7275)
  • subquery unions & invalid tests (0f02bbd)
  • support qualified all_fields (bb7d8c4)
  • use keyword_language in grammar (07e6245)