Skip to main content

Release notes

This page summarizes changes in each version of RisingWave, including new features and important bug fixes.

v0.1.10

This version was released on July 5, 2022.

Main changes

SQL features

SQL operators and functions
  • Support string concatenation operator ||. #3147
  • Support interval comparison. #3222
  • Support dividing intervals by integers, floats, or decimals. #3441
  • Intervals multiplying intervals by floats. #3641
  • Support more temporal operations. #3472
  • Support Common Table Expressions (CTEs) as input of time window functions. #3188
  • Add these new functions:
    • concat() for concatenating strings #3091
    • repeat() for repeating string #3148
    • octet_length() and bit_length() for getting string length #3526
    • Row() for constructing rows #2914 #3152
    • pg_typeof() for getting data types of values #3494
    • current_database() for getting the name of the current database in the session #3650
    • approx_count_distinct() for distinct counting #3121
    • unnest() for expanding nested tables to rows #3017
  • Support count(), min(), and max() functions on these data types: interval, timestamp, varchar, and date. #3069
SQL commands
  • Support EXPLAIN CREATE INDEX. #3229
  • Add cascade and restrict options in REVOKE commands. #3363
  • Expand the CREATE TABLE syntax to support creating append-only tables. #3058
  • Support the CREATE USER command and user authentication. #3074
Data types
  • Support implicit casts from single-quoted literals. #3487
  • Add string as an alias for data type varchar. #3094
  • Support string intervals. #3037
Database management
  • Add the default super user “postgres”. #3127
  • The default schema name is changed to “public” from “dev”. #3166

Connectors

  • Add random seed for the Datagen Source Connector. #3124

Assets

v0.1.8

This version was released on May 14, 2022.

Main changes

SQL features

  • Support SQL functions: concat_ws(), abs(), round(), ceil(), floor(). #2589 #2531 #2716
  • Support casts from number types (smallint, integer, bigint, numeric, real, and double precision) to varchar using the to_string method. #2522
  • Support creating a table with nested columns. #2434
  • Support non-literals in the IN operator. #2588
  • Support the IS [NOT] DISTINCT FROM expression. #2582
  • Support the UPDATE command. Subqueries on the right side of multi-value assignments are not supported yet. #2602
  • Support table alias in window table functions. #2633
  • Support database user management. #2943

Connectors

Support the Datagen Source Connector, which can be used to generate mock data for testing purposes. #2737

Observability

  • Add metrics for these components in Grafana.
  • Support listing KVs by epoch and table in the risectl tool. #2640

Deployment

  • RisingWave docker images support the playground mode in the bridge Docker networking mode. #2921
  • CA certificates are bundled into RisingWave docker images so that docker images can be used with S3. #2853

Assets

Help us make this doc better!