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

Latest commit

 

History

History
40 lines (32 loc) · 5.45 KB

opendistro-elasticsearch-sql.release-notes-1.4.0.0.md

File metadata and controls

40 lines (32 loc) · 5.45 KB
Raw

2020-01-24, Version 1.4.0

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)