Chuck Larrieu Casias

storage/mysql: add option for interpreting zero datetime values

1

### Feature request Unfortunately, MySQL has a date 0000-00-00. This affects the Date type as well as the timestamp type. This 0 date is absurd because it never actually happened....

sql: consider adding a `try_parse_mysql_datetime` function

1

### Feature request The [string produced](https://github.com/MaterializeInc/materialize/blob/main/src/mysql-util/src/decoding.rs#L190) with `TEXT COLUMNS (a_timestamp_column)` does not match the format [try_parse](https://materialize.com/docs/sql/functions/pushdown/) requires to enable temporal filter pushdown. We should consider adding a new `try_parse_mysql_datetime` function...

Specify UTC timezone with try_parse timestamp function

1

### Feature request A customer was bitten by the fact that try_parse_timestamp returns a timestamp type instead of timestamptz at utc. Since it only accepts timestamps of the form YYYY-MM-DDThh:mm:ss.sssZ...

Reduce Debezium cost with idempotency key

2

### Feature request Debezium offers before and after images for record updates which we can use to issue diffs in Materialize. The issue is that there are certain failure scenarios...

`SHOW TABLES` Binder Error: Ambiguous reference to catalog or schema

3

### What happens? I am using the embedded duckdb database with Rill. It created a database file called `sunpower.db` and loaded a table. ``` duckdb sunpower.db D show tables; Error:...