v0.20.0-rc3

Breaking changes

• Now relative paths are used as repository_id instead of folder name

Bugfixes

• rule: fix squash rule with convert_dates
• cmd/server/commands: use relative path as id instead of last part (#816)
• handle backslashes correctly

New features

• function: implement is_vendor function (#830)

v0.20.0-rc2

Bugfixes

• vendor: upgrade go-mysql-server

v0.20.0-rc1

Known issues

• After updating Vitess MySQL server, we are having some problems connecting from JDBC MariaDB drivers (#807) (vitessio/vitess#4603)

Breaking changes

• COUNT expression is returning now int64 instead of int32
• uast_extract function now returns a JSON for pos instead of a custom format

Bugfixes

• sql/plan: make sure outdated indexes can be dropped
• sql/analyzer: correctly qualify aliases with the same name as col
• Fix validation rule to detect tuples in projections or groupbys (src-d/go-mysql-server#672)
• sql/analyzer: only check aliases to qualify in the topmost project (src-d/go-mysql-server#690)
• Fix special case for aggregation in ORDER BY
• Try to order by function (src-d/go-mysql-server#692)
• Don't skip repositories for remotes table with more than 1 URL #789
• server: correctly set binary charset on blob fields
• sql/parse: allow qualified table names on SHOW CREATE TABLE
• plan: types in lowercase on SHOW CREATE TABLE
• Skip a directory if gitbase has no permission to read it #738
• Close iterators correctly to avoid too many open files error #772
• Check projection aliases when assigned to index src-d/go-mysql-server#639
• Add charset to fields to avoid invalid column types when using JDBC clients src-d/go-mysql-server#637
• Fix prune columns for describe queries src-d/go-mysql-server#634
• Allow all expressions in grouping, resolve order by expressions src-d/go-mysql-server#633
• KILL query always takes processlist_id src-d/go-mysql-server#636
• Recover panic for partitions src-d/go-mysql-server#626

New features

• Suggest table/column/indexes names on missing errors
• sql: HAVING clause
• Support SHOW SCHEMAS (upgrade vitess to v1.6.0) (src-d/go-mysql-server#696)
• function: LOC function implementation (#798)
• sql/expression: new DATE function
• sql: add support for intervals, DATE_SUB and DATE_ADD
• sql: from_base64 and to_base64 functions
• sql: add SLEEP function
• COUNT expression now returns an int64 number instead of int32 src-d/go-mysql-server#642
• Dockerfile: include zero-config MySQL client #737
• uast_extract function now returns a JSON for pos instead of a custom format #715

Documentation

• Now all relevant go-mysql-server documentation is directly accessible from gitbase docs instead of pointing to external links.
• Docs: document in-memory joins in optimization docs #742

Performance improvements

• Make mapping per partition on Index creation, improving performance (src-d/go-mysql-server#681).
• sql/index/pilosa: parallelize index creation
• Perf: improve the way we check if refs are not pointing to commits #780
• Plan: compute all inner joins in memory if they fit src-d/go-mysql-server#577
• Perf: Avoid call to Checksum if there are no indexes src-d/go-mysql-server#631

v0.20.0-beta4

Known issues

• After updating Vitess MySQL server, we are having some problems connecting from JDBC MariaDB drivers (#807) (vitessio/vitess#4603)

Bugfixes

• sql/plan: make sure outdated indexes can be dropped
• sql/analyzer: correctly qualify aliases with the same name as col
• Fix validation rule to detect tuples in projections or groupbys (src-d/go-mysql-server#672)
• sql/analyzer: only check aliases to qualify in the topmost project (src-d/go-mysql-server#690)
• Fix special case for aggregation in ORDER BY
• Try to order by function (src-d/go-mysql-server#692)

New features

• Suggest table/column/indexes names on missing errors
• sql: HAVING clause
• Support SHOW SCHEMAS (upgrade vitess to v1.6.0) (src-d/go-mysql-server#696)
• function: LOC function implementation (#798)

Performance improvements

• Make mapping per partition on Index creation, improving performance (src-d/go-mysql-server#681).

v0.20.0-beta3

Known issues

• Index creation is abnormally slow. We are working to improve that.

Bugfixes

• Don't skip repositories for remotes table with more than 1 URL #789
• server: correctly set binary charset on blob fields
• sql/parse: allow qualified table names on SHOW CREATE TABLE
• plan: types in lowercase on SHOW CREATE TABLE

New features

• sql/expression: new DATE function
• sql: add support for intervals, DATE_SUB and DATE_ADD
• sql: from_base64 and to_base64 functions
• sql: add SLEEP function

Documentation

• Now all relevant go-mysql-server documentation is directly accessible from gitbase docs instead of pointing to external links.

Performance improvements

• sql/index/pilosa: parallelize index creation

v0.20.0-beta2

Bugfixing

• Set correct version: #786

v0.20.0-beta1

Breaking changes

• COUNT expression is returning now int64 instead of int32
• uast_extract function now returns a JSON for pos instead of a custom format

Bugfixes

• Skip a directory if gitbase has no permission to read it #738
• Close iterators correctly to avoid too many open files error #772
• Check projection aliases when assigned to index src-d/go-mysql-server#639
• Add charset to fields to avoid invalid column types when using JDBC clients src-d/go-mysql-server#637
• Fix prune columns for describe queries src-d/go-mysql-server#634
• Allow all expressions in grouping, resolve order by expressions src-d/go-mysql-server#633
• KILL query always takes processlist_id src-d/go-mysql-server#636
• Recover panic for partitions src-d/go-mysql-server#626

New features

• COUNT expression now returns an int64 number instead of int32 src-d/go-mysql-server#642
• Dockerfile: include zero-config MySQL client #737
• uast_extract function now returns a JSON for pos instead of a custom format #715

Documentation

• Docs: document in-memory joins in optimization docs #742

Performance improvements

• Perf: improve the way we check if refs are not pointing to commits #780
• Plan: compute all inner joins in memory if they fit src-d/go-mysql-server#577
• Perf: Avoid call to Checksum if there are no indexes src-d/go-mysql-server#631

v0.19.0

Breaking changes

• The way commits are iterated now changed. The new functionality is similar to git log --all command. It is ~3 times faster, but we are ignoring orphan commits (as git does).
• 0.18.0 indexes are not compatible with this new version.

Bugfixes

• Fix KILL QUERY command
• Regression bug: Panic on go-git cache #711
• Fix checksum on indexes src-d/go-mysql-server#612
• SHOW WARNINGS doesn't clean warnings from one query to another src-d/go-mysql-server#600
• REGEXP invalid patterns doesn't break now src-d/go-mysql-server#606
• Improved function parameter errors src-d/go-mysql-server#591
• Problem combining some OR filters with AND filters in non-squashed tables.
• Solved a problem causing subqueries to cancel the main query.

New features

• Update Bblfsh and Enry dependencies #707
• cli: add --log-level option
• Adds a new optional feature behind EXPERIMENTAL_IN_MEMORY_JOIN environment variable to activate in-memory inner joins, which are faster but less memory efficient.
• Index checksum. If the index does not match the previous checksum, they're not used. That is, if the repositories changed. NOTE: indexes created prior to this version will not work.
• e2e tests against built binary.

Documentation

• Add security section

Performance improvements

• Perf: Traverse commit history instead of reading the packfile

v0.19.0-rc2

Bugfixing

• Fix KILL QUERY command

v0.19.0-rc1

Bugfixing

• Regression bug: Panic on go-git cache #711

New features

• Update Bblfsh and Enry dependencies #707

Documentation

• Add security section