Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Releases: opendistro-for-elasticsearch/sql

Version 1.7.0.0

04 May 21:47
ede36f2
Compare
Choose a tag to compare

Breaking Changes

  • Change #414: Invalidate HTTP GET method.

Features

SQL Features

  • Feature #390: Simple Query Cursor support. (issue: #16)
  • Feature #400: New SQL cluster settings endpoint.

Documentation

  • Feature #417: More docs in reference manual and add architecture doc. (issue: #380)

Security

  • Change #456: Escape comma for CSV header and all queries. (issue: #455)
  • Change #447: Fix CSV injection issue. (issue: #449)
  • Change #419: Anonymize sensitive data in queries exposed to RestSqlAction logs. (issue: #97)

Bugfixes

  • Bugfix #452: Support using aggregation function in order by clause. (issue: #277)
  • Bugfix #442: Count(distinct field) should translate to cardinality aggregation. (issue: #439)
  • Bugfix #437: Enforce AVG return double data type. (issue: #408)
  • Bugfix #425: Ignore the term query rewrite if there is no index found. (issue: #355)
  • Bugfix #418: Support subquery in from doesn't have alias. (issue: #416)
  • Bugfix #412: Add support for strict_date_optional_time. (issue: #411)
  • Bugfix #381: field function name letter case preserved in select with group by. (issue: #373)

Version 1.6.0.0

26 Mar 01:52
941065b
Compare
Choose a tag to compare

Features

Elasticsearch Compatibility

  • Feature #376: Elasticsearch 7.6.1 compatibility

Testing

  • Feature #374: Integration test with external ES cluster (issue: 353)
  • Feature #384: CI/CD using github Actions workflow

Documentation

  • Feature #366: Documentation for simple query (issue: #363)
  • Feature #379: Documentation for Pagination (issue: #16)

Enhancements

SQL Features

  • Enhancement #367: Report date data as a standardized format (issue: #342)

Exception Handling

  • Enhancement #362: Handle the elasticsearch exceptions in JDBC formatted outputs(issues: #320, 308)
  • Enhancement #372: Modified the wording of exception messages and created the troubleshooting page(issue: #320)

Bugfixes

  • Bugfix #310: Add DATETIME cast support (issue: #268)
  • BugFix #365: Return Correct Type Information for Fields (issue: #316)
  • BugFix #377: Return object type for field which has implicit object datatype when describe the table (issue:sql-jdbc#57)
  • BugFix #381: FIX field function name letter case preserved in select with group by (issue: #373)

Version 1.4.0.0

11 Dec 21:51
b29cc87
Compare
Choose a tag to compare

Features

Elasticsearch Compatibility

  • Feature #312: Elasticsearch 7.4.2 compatibility

Testing

  • Feature (#335, #343): Sql test bench bug fix, improvement and more test cases (issues: #335, #339)

Documentation

  • Feature (#302, #305, #303): Documentation for basic usage of plugin & improvement of contributing docs (issues: #293, #243)

Github Actions

  • Feature (#283, #287): Added github action to build and run tests. Gradle build will publish compiled plugin, that is ready to install into elastic

Enhancements

Lexer and Semantic

  • Enhancement #345: Syntax and semantic exceptions handling for unsupported features (issue: #320)

SQL Feature

  • Enhancement (#346, #352): Support function over aggregation result (issues: #194, #229, #270, #292)
  • Enhancement #273: Support conditional functions: IF, IFNULL, ISNULL (issues: #224, #235)
  • Enhancement #274: Support JOIN without table alias (issue: #232)
  • Enhancement #278: Support subquery in from with parent only has select (issue: #230)
  • Enhancement #282: Support datetime functions: MONTH, DAYOFMONTH, DATE, MONTHNAME, TIMESTAMP, MAKETIME, NOW, CURDATE (issue: #235)
  • Enhancement #300: Support DISTINCT feature in SELECT clause (issue: #294)

Response

  • Enhancement #334: Change the default response format to JDBC (issue: #159)

Bugfixes

  • BugFix #267: Fixed operatorReplace Integration Test (issue: #266)
  • BugFix #275: Fix issue that IP type cannot pass JDBC formatter (issue: #272)
  • BugFix #284: Fixed flaky test suite, that was breaking Github action build
  • BugFix #295: Corrected the selected field names displayed in the schema of JDBC formatted response (issue: #290)
  • BugFix #296: Fixed functions work improperly with fieldvalue/constant param for current use (issues: #279, #291, #224)
  • BugFix #298: Fixed issue of log10 function gets inaccurate results (issue: #297)
  • BugFix #307: Fix the issue of column alias not working for GROUP BY (issue: #299)
  • BugFix #333: Fixed the issue of substring not working correctly when fieldname is put as . (issue: #330)
  • BugFix #337: Fix JDBC response for delete query (issue: #131)

Version 1.2.1.0

13 Dec 23:13
080701b
Compare
Choose a tag to compare

Notable changes

  • Feature #202: Elasticsearch 7.2.1 compatibility

Version 1.3.0.0

13 Nov 03:52
842c215
Compare
Choose a tag to compare

Notable changes

  • Feature #258: Elasticsearch 7.3.2 compatibility

  • Feature #201: Improve query verification by adding semantic analyzer

  • Enhancement #262: Support CASE statement in one more grammer

  • Enhancement #253: Support Cast function

  • Enhancement #260: Support string operators: ASCII, RTRIM, LTRIM, LOCATE, LENGTH, REPLACE

  • Enhancement #254: Support SELECT <number_literal>

  • Enhancement #251: Support number operators: POWER, ATAN2, COT, SIGN/SIGNUM

  • Enhancement #215: Support ordinal in GROUP/ORDER BY clause

  • Enhancement #213: Support <table>.<column> syntax

  • Enhancement #212: Support Quoted identifiers

  • Enhancement #199: Support NOT operator with nested field query

  • Enhancement #166: Support pretty option for explain request

  • Enhancement #162: Support ORDER BY for 2 or more columns sorts only by last column in aggregation query

  • Enhancement #151: Improve query verification and exception handling

  • Enhancement #128: Support case-changing functions

  • Enhancement #120: Support aggregation function in HAVING

  • Enhancement #82: Pre-verification before actual execution of query

  • Enhancement #75: Support order by on SQL functions like SUM etc

  • BugFix #265: Fix the LOG function that delivered inaccurate result

  • BugFix #233: Function names are case-sensitive

  • BugFix #191: Fix new syntax check for LEFT JOIN on nested field and metadata field

  • BugFix #188: Having doesn't working on nested field

  • BugFix #187: Aggregation on Nested Array Field return unexpected value

  • BugFix #186: Alias of group key is not returned correctly

  • BugFix #176: ORDER BY expects function names written only in lowercase

  • BugFix #175: ORDER BY doesn't respect table aliases

  • BugFix #170: Some flaky test cases fail and pass after retry

  • BugFix #158: Aliases aren't working for ORDER BY and GROUP BY

  • BugFix #132: Integration Test Cluster doesn't terminated when integration test failed

  • BugFix #125: Parsing Exception when WHERE clause has true/false in CONDITION

  • BugFix #122: Query with custom-function doesn't respect LIMIT

  • BugFix #121: Dot/period at start of index name fails to parse

  • BugFix #111: JDBC format of aggregation query with date_format adds unnecessary column bug

Version 0.10.0.0

31 Jul 20:15
27697a7
Compare
Choose a tag to compare
  • Feature #134: Elasticsearch 6.8.1 compatibility

Version 1.2.0.0

23 Jul 20:52
7d8d9c4
Compare
Choose a tag to compare

Notable changes

  • Feature #125: Elasticsearch 7.2.0 compatibility

  • Feature #103: Sort on custom script based functions

  • BugFix #104: GROUP BY and ORDER BY for custom script based functions
    generated wrong DSL

  • BugFix #95: NPE thrown when selecting all in query with nested fields involved

  • BugFix #108: Custom script based functions weren't supported in JDBC

and other minor bugfixes

Version 1.1.0.0

10 Jul 23:15
e0e43a6
Compare
Choose a tag to compare
  • Feature #90: Elasticsearch 7.1.1 compatibility
  • Migration #17: Finished integ test migration and deprecated Maven build.
  • Enhancement #34: Detached request ID from SqlRequest object.
  • BugFix #46: Multi-index queries require identical mappings for indices.
  • BugFix #92: Improper handling of SELECT statement
  • BugFix #93: Blank query causes IndexOutOfBoundsException

Version 1.0.0.0

26 Jun 18:25
9207550
Compare
Choose a tag to compare

Feature #47: Support for Elasticsearch 7.0.1.
Feature #56: Adding coverage report.
Feature #65: Support for enabling/disabling SQL feature.

BugFix #44: Fixing the order of fields in csv output
BugFix #68: Support number field
BugFix #37: Fix for PERCENTILES query result in csv output

Version 0.9.0.0

25 Apr 17:22
Compare
Choose a tag to compare
  • Feature #29: Add support for Elasticsearch 6.7.1
  • Migration #17: Migrate legacy integration tests in Maven to ES test in Gradle.