0.30.17 (2022-06-09)

Bug Fixes

• cubesql: Simple query: commit/rollback in pg-wire (#4743) (3e03870)

Features

• cubesql: Add Postgres pg_database meta layer table (64e65eb)
• cubesql: add support public compount identifier in filters (#4742) (74aaef6)
• cubesql: Workarounds for Tableau Desktop (ODBC) (951c4b5)

0.30.16 (2022-06-08)

Bug Fixes

• cubesql: Allow binary encoding for all types in pg-wire (d456745)
• cubesql: TIMESTAMP/TZ was wrong in some BIs (pg-wire) (dfdb5ff)

0.30.14 (2022-06-07)

Bug Fixes

• databricks-jdbc: concurrency improvements (e7857f0)

Features

• cubesql: Auto-closing hold cursos on transaction end (simple query) (79725ec)
• cubesql: cast DECIMAL with default precision and scale (#4709) (771d179)
• cubesql: Support CAST for name, int2/4/8 (#4711) (36fe891)
• cubesql: Support CLOSE [name | ALL] (cursors) for pg-wire (#4712) (91048bd)
• cubesql: Support Metabase pg_type introspection query (2401dbf)
• helm-charts: Add imagePullSecrets in k8s manifest (#4491) (cdda813)

0.30.15 (2022-06-07)

This release doesn't contain any changes.

0.30.13 (2022-06-05)

Features

• cubesql: PowerBI is not empty filter (e31ffdc)

0.30.11 (2022-06-03)

Bug Fixes

• cubesql: array_lower, array_upper - correct behaviour (#4677) (a3f29d4)

Features

• cubesql: Add pg_catalog.pg_matviews meta layer table (2fbc5f4)
• cubesql: PowerBI contains filter support (#4646) (3cbd753)
• cubesql: Support [NOT] ILIKE operator (96b05c8)
• cubesql: Support ArrayIndex for scalars (419689e)

0.30.10 (2022-06-01)

Bug Fixes

• cubesql: Handle Flush pg-wire message (f779e75)
• cubesql: Store description on Portal in Finished state (f5f6566)

Features

• cubesql: information_schema.constraint_column_usage meta table (1fe8312)
• cubesql: information_schema.views meta table (490d721)
• cubesql: Support ANY expressions (77e0672)
• cubesql: Support current_database(), current_schema(), current_user for pg-wire (a18f68c)
• cubesql: Support string for NULLIF (metabase pg_class query) (#4638) (ef962e7)
• Initial support for FETCH/DECLARE (cursors) for simple query in pg-wire (#4601) (b160773)

0.30.9 (2022-05-31)

Bug Fixes

• cubesql: Allow CASE with pg_attribute.atttypmod offset (fc09160)

Features

• cubesql: Support comparison between strings and booleans (#4618) (e4352c3)

0.30.8 (2022-05-30)

Bug Fixes

• cubesql: Empty results on JOIN with AND + OR in WHERE (#4608) (96c2f15)
• cubesql: fix log error standalone (#4606) (3e3e010)
• driver-materialize: filter non-materialized objects from schema (#4584) (a32a9a9)

Features

• cubesql: Allow ::information_schema.cardinal_number casting (b198fb3)
• cubesql: excel subquery column with same name (#4602) (ea3a0bc)
• cubesql: PowerBI basic queries support (455ae07)
• cubesql: Support array_upper, array_lower UDFs (5a3b6bb)
• cubesql: Support to_char UDF (#4600) (48077a9)
• schema-compiler: allowNonStrictDateRangeMatch flag support for the pre-aggregations with time dimension (#4582) (31d9fae)

0.30.7 (2022-05-26)

Bug Fixes

• cubesql: Correct command completion for SET in pg-wire (ab42e54)
• playground: query validation (2052895)

Features

• cubesql: Support escaped string literals, E'str' (ef9700d)
• cubesql: Support multiple stmts for simple query in pg-wire (0f645cb)

0.30.6 (2022-05-24)

Bug Fixes

• cubesql: Normalize column names for joins and aliased columns (7faadc9)

Features

• cubesql: Support _pg_truetypid, _pg_truetypmod UDFs (1436a76)

0.30.5 (2022-05-23)

Bug Fixes

• schema-compiler: exclude non-included dimensions from drillMembers (#4569) (c1f12d1)

Features

• packages: add Firebolt driver (#4546) (9789d95)
• statefulset annotations (#4422) (27c1ff2)

0.30.4 (2022-05-20)

Bug Fixes

• cubesql: Skip returning of schema for special queries in pg-wire (479ec78)
• cubesql: Wrong format in RowDescription, support i16/i32/f32 (0c52cd6)
• cubestore: Prevent deleting a schema that contains tables (2824fb2)
• playground: refresh stale tokens (#4551) (80ce87d)
• playground: Remove all time time dimension without granularity (#4564) (054f488)
• refresh worker force queue reconcile logic (#4529) (144e97d)

Features

• Download streaming select * from table originalSql pre-aggregations directly (#4537) (a62d81a)
• cubesql: Allow ::oid casting (bb31838)
• cubesql: Initial support for type receivers (452f504)
• cubesql: Support ||, correct schema/catalog/ordinal_position (6d6cbf5)
• cubesql: Support DISCARD [ALL | PLANS | SEQUENCES | TEMPORARY |… (#4560) (390c764)
• cubesql: Support IS TRUE|FALSE (4d227b1)
• cubestore: Adds minio s3 region env to cubestore cloud storage (#4539) Thanks @olejeglejeg! (739d79c)

0.30.3 (2022-05-17)

Bug Fixes

• cubesql: Add support for all types to pg_catalog.format_type UDF (c49c55a)
• cubesql: Coerce empty subquery result to NULL (e59d2fb)
• cubesql: Fix several UDFs to return correct row amount (f1e0223)

Features

• cubesql: Ignore pg_catalog schema for UDFs (ab2a0da)

0.30.2 (2022-05-16)

Features

• cubesql: Superset Postgres protocol support (#4535) (394248f)

0.30.1 (2022-05-14)

Bug Fixes

• materialize-driver: commit cursor on release (#4526) (441581c)

Features

• cubesql: Add CUBEJS_PG_SQL_PORT env support and SQL API reference docs (#4531) (de60d71)
• cubesql: Provide specific error messages for not matched expressions (e035780)
• cubesql: Support quarter field in date_part SQL function (7fdf4ac)

0.30.0 (2022-05-11)

Features

• cubesql: Support dynamic key in ArrayIndex expression (#4504) (115dd55)
• streamlined-config: CUBEJS_EXTERNAL_DEFAULT and CUBEJS_SCHEDULED_REFRESH_DEFAULT defaults changed to "true" (#4367) (d52adaf)

0.29.57 (2022-05-11)

Bug Fixes

• cubesql: Fix format_type udf usage with tables (a49b2b4)
• cubesql: Reject SELECT INTO queries gracefully (8b67ff7)
• drivers: Fixes error when data result is empty for AthenaDriver (1e7e203)

Features

• persistence access mode (#4420) (d479e98)

0.29.56 (2022-05-06)

Bug Fixes

• docker: Pack redshift driver for dev docker image, fix #4497 (c80fffc)

Features

• cubesql: Correct support for regclass in CAST expr (#4499) (cdab58a)
• cubesql: More descriptive error messages (812db77)
• cubesql: Partial support for Tableau's table_cat query (#4466) (f1956d3)
• cubesql: Support pg_catalog.pg_enum postgres table (2db445a)
• cubesql: Support pg_get_constraintdef UDF (#4487) (7a3018d)
• cubesql: Support pg_type_is_visible postgres udf (47fc285)
• cubestore: Wires ParquetMetadataCache (#4297) (e20f0e7)