--- title: "Materialize v0.106" date: 2024-07-03 released: true patch: 2 --- [//]: # "NOTE(morsapaes) v0.106 shipped support for the new `VALUE DECODING ERRORS` clause behind a feature flag, which allows Kafka upsert sources to continue ingesting data in the presence of decoding errors." ## v0.106 #### SQL * Add support for the [`SHOW CREATE CLUSTER`](/sql/show-create-cluster/) command, which returns the DDL statement used to create a cluster. ```mzsql SHOW CREATE CLUSTER c; ``` ```nofmt name | create_sql ------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- c | CREATE CLUSTER "c" (DISK = false, INTROSPECTION DEBUGGING = false, INTROSPECTION INTERVAL = INTERVAL '00:00:01', MANAGED = true, REPLICATION FACTOR = 1, SIZE = '100cc', SCHEDULE = MANUAL) ``` #### Bug fixes and other improvements * Add the `mz_catalog_unstable` and [`mz_introspection`](/sql/system-catalog/mz_introspection/) system schemas to the system catalog, in support of the ongoing migration of unstable and replica introspection relations from the [`mz_internal`](/sql/system-catalog/mz_internal/) system schema into dedicated schemas. * Add `introspection_debugging` and `introspection_interval` to the `mz_clusters` system catalog table. These columns are useful for feature development. * Fix a bug in the [MySQL source](https://materialize.com/docs/sql/create-source/mysql/) that unecessarily enforced the `replica_preserve_commit_order` configuration parameter when connecting to a primary server for replication. This configuration parameter is only required when connecting to a MySQL read-replica.