Features

• Support the standalone version by Java and Python SDKs (#1302 #1325 #1485 @tobegit3hub @HuilinWu2 @keyu813)
• Support the blocking execution for offline queries (#1486 @vagetablechicken )
• Add the getStatement API in Java SDK (#1231 @dl239 )
• Support multiple rows insertion in the Python SDK (#1402 @hezhaozhao-git )
• Support the JDBC connection (#1511 @vagetablechicken )

Bug Fixes

• The error message is empty when executing show deployment in CLI fails. (#1415 @dl239 )
• The show job and show jobs cannot display correct information. (#1440 @vagetablechicken )
• The built-in function execution on a string filed with the length of greater than 2048 characters causes OpenMLDB crash. (#1540 @dl239 )
• The simple expression inference fails in some cases (#1443 @jingchen2222 )
• The PreparedStatement in Java SDK does not perform as expected. (#1511 @vagetablechicken )

Code Refactoring

#1467 @aimanfatima ; #1513 @L-Y-L ; #1503 @Stevinson ;

Acknowledgement

We appreciate the contribution to this release from all of our contributors, especially those from the community, including @hezhaozhao-git @HuilinWu2 @keyu813 @aimanfatima @L-Y-L @Stevinson . We are looking forward to your contribution!

Feature

• Experimental Support parameterized query under BatchMode #262

SQL Syntax

• nvl & nvl2: #238
• bitwise operators: &, |, ^, ~ #244
• between predicate: #277

Feature

• Add VARCHAR Type #196

Bug Fix

• Fix invalid back qoute identifier name #192. Note: option key can't write as multiple path style (e.g a.b) now
• InsertPreparedStatement set month by mistake when use Date type [#200]

v0.2.1

Changes:

• add arm64 docker demo image

Note:

For other purpose, use v0.2.0

Features

• Refactor front-end using zetasql. Thus OpenMLDB can support more SQL syntaxs and provide friendly syntax error message.
• Better code style and comment
• Add APIServer module. User can use Rest API access OpenMLDB.#70

SQL Syntax

Changed

• table options syntax: #103
• lead method: #136

Removed

• || and && as logical operator: #99
• at function: #136

Note

• openmldb-0.2.0-linux.tar.gz targets on x86_64
• aarch64 artifacts consider experimental

Features

• Refactor front-end using zetasql. Thus OpenMLDB can support more SQL syntaxs and provide friendly syntax error message.
• Better code style and comment
• Add APIServer module. User can use Rest API access OpenMLDB.#70

SQL Syntax

Changed

• table options syntax: #103
• lead method: #136

Removed

• || and && as logical operator: #99
• at function: #136