tag:github.com,2008:https://github.com/src-d/gitbase/releasesRelease notes from gitbase2019-10-23T11:49:54Ztag:github.com,2008:Repository/68594286/v0.24.0-rc32019-10-23T11:54:54Zv0.24.0-rc3<h3>Fixed</h3>
<ul>
<li>Only optimize sorted DISTINCT if the first column on the order by is on the distinct schema. (<a href="https://github.com/src-d/gitbase/issues/976" data-hovercard-type="issue" data-hovercard-url="/src-d/gitbase/issues/976/hovercard">#976</a>)</li>
<li>Avoid possible panics in LOC by using a safe cache accessor.</li>
<li>sql: Add length to VARCHAR and CHAR MySQLTypeName strings in <code>SHOW CREATE TABLE</code> output.</li>
</ul>
<h3>Added</h3>
<ul>
<li>Added BLAME function.</li>
<li>Better error messages for index failures.</li>
<li>Implemented subquery expressions.</li>
<li>Added support for 24-bit integers (MySQL's MEDIUMINT)</li>
</ul>
<h3>Changed</h3>
<ul>
<li>Use the minimum integer size as necessary when parsing literals.</li>
</ul>erizocosmicotag:github.com,2008:Repository/68594286/v0.24.0-rc22019-10-02T16:26:04Zv0.24.0-rc2<h2>Fixed</h2>
<ul>
<li>plan: return types in lowercase in SHOW CREATE TABLE (<a href="https://github.com/src-d/go-mysql-server/pull/827" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/827/hovercard">#827</a>)</li>
<li>analyzer: do not erase sort node when pushing it down (<a href="https://github.com/src-d/go-mysql-server/pull/818" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/818/hovercard">#818</a>)</li>
<li>Fixed null errors during value comparisons (<a href="https://github.com/src-d/go-mysql-server/pull/831" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/831/hovercard">#831</a>)</li>
<li>plan: fix race conditions in Exchange node</li>
<li>Add CHAR and DATETIME types support (<a href="https://github.com/src-d/go-mysql-server/pull/823" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/823/hovercard">#823</a>)</li>
<li>Also check sockets bind to tcp6 and fail on all closed sockets (<a href="https://github.com/src-d/go-mysql-server/pull/824" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/824/hovercard">#824</a>)</li>
</ul>
<h2>Changed</h2>
<ul>
<li>Added LIKE test with newlines (<a href="https://github.com/src-d/go-mysql-server/pull/820" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/820/hovercard">#820</a>)</li>
<li>Convert LIKE patterns to specific Go regexes (<a href="https://github.com/src-d/go-mysql-server/pull/817" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/817/hovercard">#817</a>)</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.24.0-rc12019-09-19T10:27:42Zv0.24.0-rc1<h3>Added</h3>
<ul>
<li>function: use new caches from go-mysql-server (<a href="https://github.com/src-d/gitbase/pull/957" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/957/hovercard">#957</a>)</li>
</ul>
<h3>Changed</h3>
<ul>
<li><code>go-borges</code> library was updated to <code>0.1.3</code>:
<ul>
<li>support metadata reloading <a href="https://github.com/src-d/go-borges/pull/84" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-borges/pull/84/hovercard">issue</a></li>
<li>speedup loading legacy sivas with lots of references <a href="https://github.com/src-d/go-borges/pull/87" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-borges/pull/87/hovercard">issue</a></li>
<li>fix bug that misplaced location metadata <a href="https://github.com/src-d/go-borges/pull/88" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-borges/pull/88/hovercard">issue</a></li>
</ul>
</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.24.0-beta32019-08-21T14:53:22Zv0.24.0-beta3<h3>Added</h3>
<ul>
<li><code>uast_imports</code> function to gather import paths from an UAST.</li>
<li>sql: implement memory management system for caches (<a href="https://github.com/src-d/go-mysql-server/pull/802" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/802/hovercard">#802</a>)</li>
<li>function: implement regexp_matches (<a href="https://github.com/src-d/go-mysql-server/pull/794" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/794/hovercard">#794</a>)</li>
</ul>
<h3>Fixed</h3>
<ul>
<li>Added a checker that will detect dead sockets before the timeout (Linux only)</li>
<li>Make Sleep check for cancelled context every second (<a href="https://github.com/src-d/go-mysql-server/pull/798" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/798/hovercard">#798</a>)</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.24.0-beta22019-07-31T13:29:01Zv0.24.0-beta2<h3>Changed</h3>
<ul>
<li>When it's added the <code>-v</code> verbose flag, gitbase will use <code>debug</code> as logging level, ignoring any other passed (<a href="https://github.com/src-d/gitbase/pull/935" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/935/hovercard">#935</a>)</li>
</ul>
<h3>Fixed</h3>
<ul>
<li>If using docker image, and <code>info</code> logging level, it will be now used instead of <code>debug</code> (<a href="https://github.com/src-d/gitbase/pull/935" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/935/hovercard">#935</a>)</li>
<li>sql/analyzer: fix order by resolution for all nodes (<a href="https://github.com/src-d/gitbase/pull/793" data-hovercard-type="issue" data-hovercard-url="/src-d/gitbase/issues/793/hovercard">#793</a>)</li>
<li>sql: fix SQL method for arrays of JSON (<a href="https://github.com/src-d/gitbase/pull/790">#790</a>)</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.24.0-beta12019-07-09T08:02:34Zv0.24.0-beta1<h3>Added</h3>
<ul>
<li>Varchar type.</li>
<li>FIRST and LAST aggregations.</li>
<li>Count distinct aggregation.</li>
</ul>
<h3>Changed</h3>
<ul>
<li>Errors now report the repository causing the error, if possible.</li>
<li>Switch some types of known or maximum length (mostly hashes and emails)<br>
to VarChar with a size.</li>
<li>Traces now have a root span.</li>
<li>New API for node transformations.</li>
</ul>
<h3>Fixed</h3>
<ul>
<li>Fixed the behaviour of limit and offset.</li>
<li>Resolution of HAVING nodes.</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.23.12019-07-08T08:38:41Zv0.23.1<h3>Fixed</h3>
<ul>
<li>Fix the results of files table by not using git log.</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.23.02019-07-17T15:12:27Zv0.23.0<h3>Added</h3>
<ul>
<li>Support for siva files generated with borges, again. (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="462008015" data-permission-text="Title is private" data-url="https://github.com/src-d/gitbase/issues/911" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/911/hovercard" href="https://github.com/src-d/gitbase/pull/911">#911</a>)</li>
</ul>
<p>Reading siva files generated with src-d/borges (as those found in PGA), require running gitbase with the following command line arguments: <code>--format siva --non-rooted</code></p>ajnavarrotag:github.com,2008:Repository/68594286/v0.22.02019-07-03T10:22:08Zv0.22.0<h3>Added</h3>
<ul>
<li>Now gitbase uses <a href="https://github.com/src-d/go-borges">go-borges</a> to access repositories
<ul>
<li>The type of files in each directory has to be specified (<a href="https://github.com/src-d/gitbase/pull/867" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/867/hovercard">#867</a>)</li>
<li>Supports new rooted repository format and separates references and objects from each repo (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="423341955" data-permission-text="Title is private" data-url="https://github.com/src-d/borges/issues/389" data-hovercard-type="issue" data-hovercard-url="/src-d/borges/issues/389/hovercard" href="https://github.com/src-d/borges/issues/389">src-d/borges#389</a>)</li>
</ul>
</li>
</ul>
<h3>Changed</h3>
<ul>
<li>Changed cli to be able to specify different formats (<a href="https://github.com/src-d/gitbase/issues/866" data-hovercard-type="issue" data-hovercard-url="/src-d/gitbase/issues/866/hovercard">#866</a>)</li>
</ul>
<h3>Fixed</h3>
<ul>
<li>function: correctly transform up explode nodes (<a href="https://github.com/src-d/go-mysql-server/pull/757" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/757/hovercard">#757</a>)</li>
<li>git libraries bare or non bare format is automatically detected (<a href="https://github.com/src-d/gitbase/pull/897" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/897/hovercard">#897</a>)</li>
<li>Fix bug that created multiple object cache with incorrect size (<a href="https://github.com/src-d/gitbase/pull/898" data-hovercard-type="pull_request" data-hovercard-url="/src-d/gitbase/pull/898/hovercard">#898</a>)</li>
<li>sql/expression: handle null values in arithmetic expressions (<a href="https://github.com/src-d/go-mysql-server/pull/760" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/760/hovercard">#760</a>)</li>
<li>Panic on query using EXPLODE (<a href="https://github.com/src-d/go-mysql-server/issues/755" data-hovercard-type="issue" data-hovercard-url="/src-d/go-mysql-server/issues/755/hovercard">#755</a>)</li>
<li>Fixed error iterating over non ready repositories (<a href="https://github.com/src-d/go-borges/pull/54" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-borges/pull/54/hovercard">src-d/go-borges#54</a>)</li>
<li>Error saying value could not be converted to bool.</li>
<li>function: make array_length not fail with literal null (<a href="https://github.com/src-d/go-mysql-server/pull/767" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/767/hovercard">#767</a>)</li>
<li>server: kill queries on connection closed ((<a href="https://github.com/src-d/go-mysql-server/pull/769" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/769/hovercard">#769</a>))</li>
</ul>ajnavarrotag:github.com,2008:Repository/68594286/v0.22.0-rc22019-06-24T18:07:11Zv0.22.0-rc2<h3>Fixed</h3>
<ul>
<li>Panic on query using EXPLODE (<a href="https://github.com/src-d/go-mysql-server/issues/755" data-hovercard-type="issue" data-hovercard-url="/src-d/go-mysql-server/issues/755/hovercard">#755</a>)</li>
<li>Fixed error iterating over non ready repositories (<a href="https://github.com/src-d/go-borges/pull/54" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-borges/pull/54/hovercard">src-d/go-borges#54</a>)</li>
<li>Error saying value could not be converted to bool.</li>
<li>function: make array_length not fail with literal null (<a href="https://github.com/src-d/go-mysql-server/pull/767" data-hovercard-type="pull_request" data-hovercard-url="/src-d/go-mysql-server/pull/767/hovercard">#767</a>)</li>
</ul>ajnavarro