v0.6.0

Implemented enhancements:

• Compile error: parse.go:248:77: undefined sqlparser.SCHEMAS #826
• Reduce amount of implemented code on Expressions #772
• Support for regexp_matches #756
• Request: SLEEP function #647
• Parallelize index creation #346
• TPC-H: unsupported feature: HAVING #56
• sql: implement count distinct #785
• server: kill queries on connection closed #769
• sql/analyzer: refactor pushdown rule #752
• sql/analyzer: refactor resolve_natural_joins rule #750
• replace all gopkg.in imports and use only go mods #736
• sql: implement EXPLODE and generators #720
• sql/analyzer: refactor and fix bugs in qualify_columns rule #706
• Support SHOW SCHEMAS (upgrade vitess to v1.6.0) #696
• Add build, tag for oniguruma, remove for mysql_go_regex, update README #660

Fixed bugs:

• Races detected on running gitbase during the test #828
• Failing test for connection handler in Linux #821
• LIKE fails when new lines are present #814
• ORDER BY does not fail on non-existent columns #813
• resolveDatabase is not working if database is changed using USE #810
• Not support types of char and datetime #807
• Long processing queries don't stop if the connection is dead/killed until the timeout triggers #800
• sleep function cannot be cancelled #797
• Connection problems and possible fix #796
• Error on CASE statements when result is not bool #787
• Error on Travis testing jdk 10 #782
• NULL is not printed in the resulting table #779
• No root span created for a query #778
• Handle strings on EvaluateCondition #770
• ARRAY_LENGTH is not handling null values well #766
• [Panic] - on HAVING query #764
• JSON_EXTRACT returns strings quoted #761
• unable to cast <nil> of type <nil> to float64 #759
• Panic on query using EXPLODE #755
• LEFT JOIN and RIGHT JOIN are returning more than a single row per left/right row #742
• Cannot return NULL in a CASE branch #740
• Cannot parse "show create table a.b" #733
• gitbase dies for query with WHERE NOT <not boolean value> #726
• JSON_EXTRACT cannot cast JSON string #709
• Nested SUBSTRING fails with INVALID_ARGUMENT error #705
• Incorrect type name for int64 in create table #702
• Make sure dates and times are within the supported range #698
• unable to cast "<repository name>" of type string to int64 #691
• Index generation is slower than previous implementation #676
• ORDER BY with aggregations fails with a missleading error #675
• Problems dropping outdated index #674
• Bug: Mis-formatted error diagnostics for incorrect function use #665
• Using fqn in SHOW CREATE TABLE errors #662
• Indexes on language func does not work with aliased cols #639
• KILL fails with err message "closed network connection" #635
• commits does not have column commit_author_when #630
• Incorrect projected fields #619
• Support DISTINCT and multiple expressions on aggregation functions #162
• sql: fix SQL method for arrays of JSON #790
• sql: use custom boolean coercion logic in condition evaluation #768
• function: correctly transform up explode nodes #757
• sql: correctly handle nulls in SQL type conversion #753
• sql/analyzer: back-propagate expression names after adding convert #739
• Upgrade vitess to v1.7.0 #732
• Make boolean expression compatible with MySQL #731
• Make PROCESSLIST and KILL compatible with MySQL #722
• sql/analyzer: convert_dates should not change column name #721
• server: guard sessions access in mutex #713
• sql/analyzer: run convert_dates rule after prune_columns #703
• sql/analyzer: alias projected columns wrapped in converts #701
• Try to order by function #692
• sql/analyzer: only check aliases to qualify in the topmost project #690
• Make mapping per partition #681
• server: correctly set binary charset on blob fields #673
• Fix validation rule to detect tuples in projections or groupbys #672
• Close iterators #655
• Check projection aliases when assigned to index. #640

Closed issues:

• Add sql/expression/literal\_test.go #776
• FR: Select single fields from substring search or split results #747
• Add FIRST/LAST aggregations #718
• Add SUBSTRING_INDEX #716
• Add LENGTH function (for strings) #715
• LEFT OUTER JOIN support #707
• vet tool #686
• [FEATURE] Suggest similar table/column names when one is not found in a query #684
• Upgrade pilosa to v1.3.0 #679
• document environment variables in here, not just gitbase #668
• Add Greatest, Least #664
• DATE_SUB and DATE_ADD functions #663
• Add support for DATE function #653
• Add support for SHOW SCHEMAS #652
• count is int32 #642
• Feature request: don't die on panic #625
• Suppress build warning for oniguruma #623
• yearweek function #616
• Replace and test BoltDB by github.com/etcd-io/bbolt #614
• Use in-memory join when one of the tables is small enough #577
• Add TO_BASE64, FROM_BASE64 #549

Merged pull requests:

• Fixed null errors during value comparisons #831
• Fixed a few typos for the DELETE implementation #830
• plan: fix race conditions in Exchange node #829
• plan: return types in lowercase in SHOW CREATE TABLE #827
• Implemented REPLACE #825
• Also check sockets bind to tcp6 and fail on all closed sockets #824
• Add CHAR and DATETIME types support #823
• Added LIKE test with newlines #820
• Bump ava version #819
• analyzer: do not erase sort node when pushing it down #818
• Convert LIKE patterns to specific Go regexes #817
• Fixed INSERT bugs, added UINT64 support, and added tests #816
• Add dolt to README #815
• Removed pilosa-dependent files from Windows compilation #812
• build(deps): bump mixin-deep from 1.3.1 to 1.3.2 in /_integratio… #811
• Fix for non linux OS build #808
• Check for dead sockets before timeout and enforce timeouts #806
• Fix typos and make style consistent #804
• sql: implement memory management system for caches #802
• Make Sleep check for cancelled context every second #798
• use goproxy #795
• function: implement regexp_matches #794
• sql/analyzer: fix order by resolution for all nodes #793
• README.md -> fix build status link #792
• build(deps): bump lodash from 4.17.11 to 4.17.14 in /_integration/javascript #791
• build(deps): bump lodash.merge from 4.6.1 to 4.6.2 in /_integration/javascript #789
• sql/expression: correctly evaluate conditions in CASE #788
• Update functionregistry.go #786
• Zachmu/bug fixes to contribute #784
• sql: fix how nulls are sent to clients #783
• server: start root trace span on context creation #781
• sql/analyzer: fix having resolution #780
• Varchar type #775
• Limit / offset bug fixes #774
• sql: implement new API for node transformation #773
• Add test to EvaluateCondition function #771
• function: make array_length not fail with literal null #767
• function: correctly transform up explode nodes #765
• build(deps): bump esm from 3.0.84 to 3.2.25 in /_integration/javascript #763
• docs: add JSON_EXTRACT quoted string gotcha to docs #762
• sql/expression: handle null values in arithmetic expressions #760
• sql/parse: error for unsupported distinct on aggregations #754
• sql: implement FIRST and LAST aggregation functions #749
• Implement JSON_UNQUOTE #748
• build(deps): bump js-yaml from 3.12.0 to 3.13.1 in /_integration/javascript #746
• Replace fork go-vitess by original vitess. #745
• Add metrics (engine, analyzer, regex, pilosa) based on go-kit interface. #744
• sql/plan: make LEFT and RIGHT join work as expected #743
• sql/expression: allow null literals in case branches #741
• Upgrade vitess to v1.8.0 #738
• Fix parsing of quoted identifiers in SHOW CREATE TABLE queries #737
• sql/analyzer: do not wrap aggregations with convert, just their arguments #730
• sql/expression: allow arithmetic operations with dates/times #729
• sql/analyzer: case insensitive checks for group by rules #728
• sql/expression/function: implement char_length and length functions #724
• Implement SUBSTRING_INDEX UDF #723
• sql/analyzer: refactor and simplify resolve_columns rule #714
• sql: implement LEFT and RIGHT join #712
• Make ARRAY_LENGTH working with JSON arrays #711
• sql: do not marshal strings containing JSON as a string in convert #710
• sql/analyzer: do not use plan.Inspect to find available tables #708
• sql: use correct MySQL display name for types #704
• add greatest and least #700
• sql/analyzer: wrap all time and date expressions with convert #699
• pilosa: set max map count to 0 to avoid index issues on windows #697
• update readme #695
• sql: implement HAVING clause #689
• Some vet tools fixes #688
• vendor: upgrade pilosa #687
• Suggest similar table/column/indexes names on missing errors #685
• Fix jaeger-lib dependency #683
• sql/expression: relaxed json_extract #682
• sql/analyzer: correctly qualify aliases with the same name as col #680
• function: remove print from YearWeek UDF #678
• sql/plan: make sure outdated indexes can be dropped #677
• sql/expression: new dayofmonth function (alias of day) #671
• docs: nicer format for functions and vars in docs, add markers #670
• docs: add session and environment variables to README #669
• sql: add support for intervals, DATE_SUB and DATE_ADD #667
• Pass function name to the registry #666
• sql/parse: allow qualified table names on SHOW CREATE TABLE #661
• plan: types in lowecase on SHOW CREATE TABLE #656
• sql/expression: new date function #654
• docs: document the architecture of the project #651
• Added from_base64 and to_base64 #650
• Added MySQL SLEEP function #649
• Fix test error after two PR merges. #648
• sql/index/pilosa: parallelize index creation #644
• Make count int64 function #643
• plan: compute all inner joins in memory if they fit #638
• Add charset to fields #637
• KILL query always takes processlist_id #636
• fix prune columns for describe queries #634
• allow all expressions in grouping, resolve orderby expressions #633
• go.etcd.io/bbolt v1.3.2 #632
• Perf: Avoid call to Checksum if there are no indexes. #631
• YEARWEEK UDF function #628
• Switch to src-d/go-oniguruma #627
• recover panic for partitions #626