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)

0.29.55 (2022-05-04)

Bug Fixes

• cubesql: Correct handling for boolean type (cff6c8b)
• cubesql: Tableau new regclass query fast fix (2a7ff1e)

Features

• cubesql: Tableau cubes without count measure support (931e2f5)

0.29.54 (2022-05-03)

Bug Fixes

• Disable UPX compressing for Cube Store arm64-linux-gnu, fix #4474 (#4476) (3cb8586)
• Make dimensions and measures nullable fields for GraphQL API (#4477) Thanks @MarkLyck ! (84e298e), closes #4399
• cubesql: Using same alias on column yields Option.unwrap() panic (a674c5f)
• Prestodb timestamp cast to work in prestodb and athena (#4419) Thanks @apzeb ! (8f8f61a), closes #4221

Features

• cubejs: rollupJoin between multiple databases (#4371) (6cd77d5)
• cubesql: Tableau boolean filters support (33aa5f1)
• cubesql: Tableau cast projection queries support (71ec644)
• cubesql: Tableau contains support (71dcad0)
• cubesql: Tableau min max number dimension support (2abe13e)
• cubesql: Tableau not null filter support (d48d0e0)
• cubesql: Tableau week support (6d987ea)
• Detailed client TS types (#4446) Thanks @reify-thomas-smith ! (977cce0), closes #4202

0.29.53 (2022-04-29)

Bug Fixes

• @cubejs-client/core: Correct LogicalAndFilter/LogicalOrFilter types: allow any filter types in and / or (#4343) Thanks @tchell ! (699a2f4)
• @cubejs-client/core: fix HTTP poll not working if Cube API stops and recovers (#3506) Thanks @rongfengliang ! (c207c3c)
• cubejs-playground: fix history header scrolling in graphql explorer (#4410) (a8b82b5)
• cubesql: fix pg_constraint confkey type (#4462) (82c25fd)
• cubestore: Index selection for different permutations of columns in a group by omits sorted indexes (#4455) (fb31edd)
• playground: change the url on query change (5c59298)

Features

• @cubejs-client/core: Accept immutable queries (#4366) Thanks @reify-thomas-smith! (19b1514), closes #4160
• client-core: Add HTTP status code to RequestError (#4412) (6ec4fdf)
• client-vue: boolean filters support (#4314) (8a3bb3d)
• cubesql: Aggregate aggregate split to support Tableau extract date part queries (532b4ee)
• cubesql: Projection aggregate split to support Tableau casts (#4435) (1550774)
• cubesql: Support for pg_get_userbyid, pg_table_is_visible UDFs (64f8885)
• cubesql: Support generate_subscripts UDTF (a29551a)
• cubesql: Support get_expr query for Pg/Tableau (#4421) (4d4918f)
• cubesql: Support information_schema._pg_expandarray postgres UDTF (#4439) (1af4290)
• cubesql: Support pg_catalog.pg_am table (24b231d)
• cubesql: Support Timestamp, TimestampTZ for pg-wire (0b38b3d)
• cubesql: Support unnest UDTF (110bdf8)
• cubesql: Tableau default having support (4d432c0)
• cubesql: Tableau Min, Max timestamp queries support (48ee34e)
• cubesql: Tableau range of dates support (ef56133)
• cubesql: Tableau relative date range support (87a3817)
• cubesql: Unwrap filter casts for Tableau (0a39420)
• packages: Materialize driver (#4320) (d40d13b)
• playground: display error stack traces (#4438) (0932cda)

0.29.52 (2022-04-23)

Note: Version bump only for package cubejs

0.29.51 (2022-04-22)

Bug Fixes

• cubesql: Bool encoding for text format in pg-wire (7faf34b)
• cubesql: current_schema() UDF (69a75dc)
• cubesql: Proper handling for Postgresql table reference (35f5635)
• playground: chart templates (#4426) (ebc83a9)

Features

• cubesql: Correlated subqueries support for introspection queries (#4408) (1f02b2c)
• cubesql: Implement rewrites for SELECT * FROM WHERE 1=0 (#4427) (0c9abd1)
• cubesql: Support arrays in pg-wire (b7925ba)
• cubesql: Support generate_series UDTF (#4416) (3321925)
• cubesql: Support GetIndexedFieldExpr rewrites (#4424) (8dca8b5)
• cubesql: Support information_schema._pg_datetime_precision UDF (4d20ee6)
• cubesql: Support information_schema._pg_numeric_precision UDF (6fc6c0a)
• cubesql: Support information_schema._pg_numeric_scale UDF (398d1db)
• cubesql: Support lc_collate for PostgreSQL (120ce31)
• cubesql: Support NoData response for empty response in pg-wire (6711c8a)
• cubesql: Support pg_get_expr UDF (#4425) (2b51d70)
• cubesql: Support pg_get_userbyid UDF (c6efef8)
• cubesql: Use proper command completion tags for pg-wire (3e777ec)
• databricks-driver: Export bucket support for S3/Azure (#4430) (4512126)
• query-language: "startsWith", "endsWith" filters support (#4128) (e8c72d6)