> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/release-notes/earlier-releases/2023/may-2023.md).

# May 2023

## Weekly Software Updates

The following software updates were released in May:

### 2023.05.28-18.43

#### :wrench: Bug Fixes 

* `CASE WHEN` now handles `NULL` as input and returns the `ELSE` value.  
* CDC: Fixed the bug that caused the ingestion of a decimal type column to be converted to binary base64 string.

***

### 2023.05.17-13.45

#### :arrow\_up: Enhancements

* Validate that the first parameter in an [`ARRAY_JOIN`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/cRwd8HdvuMaKZlXispwq) is not a literal. 
* Ingestion wizard now supports Amazon Kinesis source.

#### :wrench: Bug Fixes 

* [`COLUMN_TRANSFORMATIONS`](/content/reference-1/sql-commands/jobs/create-job/ingestion.md#column_transformations) with dependencies between them created the wrong name for the nested column. 
* Fixed target name column value for Snowflake outputs in the [`system.information_schema.jobs`](/content/reference-1/monitoring/system-catalog/monitoring/jobs.md) table.

***

### 2023.05.15-02.23

#### :sparkles: New Features

* New SQL syntax for [`SHOW CREATE`](/content/reference-1/general/view-entity-syntax.md) is now supported:
  * `SHOW CREATE JOB "Job name"`
  * `SHOW CREATE TABLE "Table name"`
  * `SHOW CREATE MATERIALIZED VIEW "MV name"`
  * `SHOW CREATE CLUSTER "Cluster name"`

#### :arrow\_up: Enhancements

* PostgreSQL Jobs: 
  * Support reading 14+ partitioned tables by the root table name instead of the underlying partition table names.
* Snowflake Jobs: 
  * Added query tag to queries executed by Upsolver for easier cost tracking.

#### :wrench: Bug Fixes 

* Fixed the bug where `TABLE_DATA_RETENTION` could be disabled by disabling compactions.
* Dropping a table while specifying `DELETE_DATA = true` did not delete data files written by jobs with `RUN_PARALLELISM > 1`.
* Parquet files are now distributed more evenly when ingesting data from Amazon S3 with high execution parallelism.
* Fixed a bug when selecting from large materialized views with predicates on key columns would return "Query exceeded input row limit".
* Fixed a bug where a job reading from [`system.information_schema.columns`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/RcdOaE3embnDK2gkcyaN) does not write data into a table.
* Fixed a bug where querying [`system.monitoring.jobs`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/NmVM3rZUQQeygomOBNnd) can result in an error.
* [`BYTES_SUBSTRING`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/MhhvNeEvAgIt6E6Nhais) position now starts from **1** as `SUBSTRING` (previously started from **0**).

***

### 2023.05.04-07.39

#### :arrow\_up: Enhancements

* Support querying all system tables using the syntax: `SELECT $*`.
* Information Schema: added a `type_evolution` column to the system table. [`system.information_schema.columns`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/RcdOaE3embnDK2gkcyaN) to show all previous types of the column.
* Improved statistics in [Job Status](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/jEzA8OoJhnxS7qfIgVF0). 

#### :wrench: Bug Fixes 

* Fixed the issue of inviting a member to the organization not working. 
* Prevented the creation of sync jobs that read from system tables. 
* Fixed a bug in jobs when writing to Amazon S3 with a dynamic location. 
* Fixed a bug that caused some columns to be missing when reading from a table. 


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://upsolver.gitbook.io/content/release-notes/earlier-releases/2023/may-2023.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.