alamb opened a new pull request, #4226: URL: https://github.com/apache/arrow-datafusion/pull/4226
# Which issue does this PR close? Closes https://github.com/apache/arrow-datafusion/pull/4201 # Rationale for this change Keep up with dependencies # What changes are included in this PR? Take @dependabot changes in https://github.com/apache/arrow-datafusion/pull/4201 and fix up the code for the changes Update sqlparser requirement from 0.26 to 0.27 <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/sqlparser-rs/sqlparser-rs/blob/main/CHANGELOG.md";>sqlparser's changelog</a>.</em></p> <blockquote> <h2>[0.27.0] 2022-11-11</h2> <h3>Added</h3> <ul> <li>Support <code>ON CONFLICT</code> and <code>RETURNING</code> in <code>UPDATE</code> statement (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/666";>#666</a>) - Thanks <a href="https://github.com/main";><code>@main</code></a> and <a href="https://github.com/gamife";><code>@gamife</code></a></li> <li>Support <code>FULLTEXT</code> option on create table for MySQL and Generic dialects (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/702";>#702</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support <code>ARRAY_AGG</code> for Bigquery and Snowflake (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/662";>#662</a>) - Thanks <a href="https://github.com/SuperBo";><code>@SuperBo</code></a></li> <li>Support DISTINCT for SetOperator (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/689";>#689</a>) - Thanks <a href="https://github.com/unvalley";><code>@unvalley</code></a></li> <li>Support the ARRAY type of Snowflake (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/699";>#699</a>) - Thanks <a href="https://github.com/yuval-illumex";><code>@yuval-illumex</code></a></li> <li>Support create sequence with options INCREMENT, MINVALUE, MAXVALUE, START etc. (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/681";>#681</a>) - Thanks <a href="https://github.com/sam-mmm";><code>@sam-mmm</code></a></li> <li>Support <code>:</code> operator for semi-structured data in Snowflake(<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/693";>#693</a>) - Thanks <a href="https://github.com/yuval-illumex";><code>@yuval-illumex</code></a></li> <li>Support ALTER TABLE DROP PRIMARY KEY (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/682";>#682</a>) - Thanks <a href="https://github.com/ding-young";><code>@ding-young</code></a></li> <li>Support <code>NUMERIC</code> and <code>DEC</code> ANSI data types (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/695";>#695</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support modifiers for Custom Datatype (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/680";>#680</a>) - Thanks <a href="https://github.com/sunng87";><code>@sunng87</code></a></li> </ul> <h3>Changed</h3> <ul> <li>Add precision for TIME, DATETIME, and TIMESTAMP data types (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/701";>#701</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>add Date keyword (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/691";>#691</a>) - Thanks <a href="https://github.com/sarahyurick";><code>@sarahyurick</code></a></li> <li>Update simple_logger requirement from 2.1 to 4.0 - Thanks <a href="https://github.com/dependabot";><code>@dependabot</code></a></li> </ul> <h3>Fixed</h3> <ul> <li>Fix broken DataFusion link (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/703";>#703</a>) - Thanks <a href="https://github.com/jmg-duarte";><code>@jmg-duarte</code></a></li> <li>Add MySql, BigQuery to all dialects tests, fixed bugs (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/697";>#697</a>) - Thanks <a href="https://github.com/omer-shtivi";><code>@omer-shtivi</code></a></li> </ul> <h2>[0.26.0] 2022-10-19</h2> <h3>Added</h3> <ul> <li>Support MySQL table option <code>{INDEX | KEY}</code> in CREATE TABLE definiton (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/665";>#665</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support <code>CREATE [ { TEMPORARY | TEMP } ] SEQUENCE [ IF NOT EXISTS ] <sequence_name></code> (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/678";>#678</a>) - Thanks <a href="https://github.com/sam-mmm";><code>@sam-mmm</code></a></li> <li>Support <code>DROP SEQUENCE</code> statement (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/673";>#673</a>) - Thanks <a href="https://github.com/sam-mmm";><code>@sam-mmm</code></a></li> <li>Support for ANSI types <code>CHARACTER LARGE OBJECT[(p)]</code> and <code>CHAR LARGE OBJECT[(p)]</code> (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/671";>#671</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support <code>[CACHE|UNCACHE] TABLE</code> (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/670";>#670</a>) - Thanks <a href="https://github.com/francis-du";><code>@francis-du</code></a></li> <li>Support <code>CEIL(expr TO DateTimeField)</code> and <code>FLOOR(expr TO DateTimeField)</code> - Thanks <a href="https://github.com/sarahyurick";><code>@sarahyurick</code></a></li> <li>Support all ansii character string types, (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/648";>#648</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> </ul> <h3>Changed</h3> <ul> <li>Support expressions inside window frames (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/655";>#655</a>) - Thanks <a href="https://github.com/mustafasrepo";><code>@mustafasrepo</code></a> and <a href="https://github.com/ozankabak";><code>@ozankabak</code></a></li> <li>Support unit on char length units for small character strings (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/663";>#663</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Replace booleans on <code>SET ROLE</code> with a single enum. (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/664";>#664</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Replace <code>Option</code>s with enum for <code>DECIMAL</code> precision (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/654";>#654</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> </ul> <h2>[0.25.0] 2022-10-03</h2> <h3>Added</h3> <ul> <li>Support <code>AUTHORIZATION</code> clause in <code>CREATE SCHEMA</code> statements (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/641";>#641</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support optional precision for <code>CLOB</code> and <code>BLOB</code> (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/639";>#639</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> <li>Support optional precision in <code>VARBINARY</code> and <code>BINARY</code> (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/637";>#637</a>) - Thanks <a href="https://github.com/AugustoFKL";><code>@AugustoFKL</code></a></li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/0d91662c88c55c7d33a9a0b7e44a5f29f60d9fba";><code>0d91662</code></a> (cargo-release) version 0.27.0</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/6a847107cebf45e1efc9eebc4966327ea7d82bbd";><code>6a84710</code></a> Update CHANGELOG for 0.27.0 release (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/706";>#706</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/814367a6abe319bb8c9e030a4a804cd6c9cf2231";><code>814367a</code></a> Implement ON CONFLICT and RETURNING (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/666";>#666</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/ae1c69034e1a6924bceb54d4eb6eb8b14919d84e";><code>ae1c690</code></a> Fix broken DataFusion link (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/703";>#703</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/65c5a37bcebb5ff53b46dfc28bca6aee65efd020";><code>65c5a37</code></a> feat: add precision for TIME, DATETIME, and TIMESTAMP data types (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/701";>#701</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/cdf444706573714cc71f3f4e8fe93a43d740c6bc";><code>cdf4447</code></a> feat: add FULLTEXT option on create table for MySQL and Generic dialects (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/702";>#702</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/87b4a168cbcd83439c4e8729dd992d150eebd15c";><code>87b4a16</code></a> Parse ARRAY_AGG for Bigquery and Snowflake (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/662";>#662</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/0428ac742b204edd159be9fa0b2c3fb3ec542f14";><code>0428ac7</code></a> Add MySql, BigQuery to all dialects (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/697";>#697</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/f7817bc7c257b6db76bb19b83033a7f2f001313b";><code>f7817bc</code></a> Support <code>DISTINCT</code> for SetOperator (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/689";>#689</a>)</li> <li><a href="https://github.com/sqlparser-rs/sqlparser-rs/commit/0f7e144890db1e2f1b9da37787376449d26e6c13";><code>0f7e144</code></a> Support the ARRAY type of Snowflake (<a href="https://github-redirect.dependabot.com/sqlparser-rs/sqlparser-rs/issues/699";>#699</a>)</li> <li>Additional commits viewable in <a href="https://github.com/sqlparser-rs/sqlparser-rs/compare/v0.26.0...v0.27.0";>compare view</a></li> </ul> </details> <br /> Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`. [//]: # (dependabot-automerge-start) [//]: # (dependabot-automerge-end) --- -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
