nrainer-materialize

"AWS (Real)" is flaky

2

### Buildkite link https://buildkite.com/materialize/nightlies/builds/6448#018daa2c-f08f-405c-95d0-1fc0a0f6d7bc ### Relevant log output ```source : {'S': 'ERROR', 'C': '58000', 'M': 'role trust policy does not require an external ID', 'D': "The trust policy for the...

tests: add mysql-cdc tests

1

### Issues https://github.com/MaterializeInc/materialize/issues?q=is%3Aissue+author%3Anrainer-materialize+label%3AT-mysql+label%3AC-bug

ci: annotate when an error also occurred on main

2

Demo (expecting a failure in "unused dependencies"): https://buildkite.com/materialize/nightlies/builds?branch=nrainer-materialize%3Aci%2Fannotate-error-also-on-main

test/sqllogictest/dates-times.slt fails

9

### What version of Materialize are you using? 2ddde540c480e5f3da569a9f7d9d1f9960efd2ae ### What is the issue? `date-times.slt` fails (https://buildkite.com/materialize/sql-logic-tests/builds/5834#018dacbf-c5fd-4e37-8d81-ce099751d34c). ``` _bk;t=1708000738923 SELECT '"?!?2024-02-13 17:01:58.37848 ?+ 00 + '::timestamp with time zone; _bk;t=1708000738939...

thread 'coordinator' panicked at src/adapter/src/catalog.rs: all dropped_notices entries have `Arc::strong_count(_) == 1

24

### What version of Materialize are you using? 97ff6eb84ad1d04759a4b69100f469a420461fa4 ### What is the issue? SQLancer QueryPartitioning in [builds/6270](https://buildkite.com/materialize/nightlies/builds/6270#018d63bb-4323-4a55-9bb6-ca02b2601df2): ``` $ docker compose run --detach sqlancer --random-seed 2056923865 --host materialized --port...

Demo: https://buildkite.com/materialize/tests/builds/75744

* include all test cases * this would allow counting how many test cases run and detecting when the number significantly decreases

### Feature request Extensions to https://github.com/MaterializeInc/materialize/issues/18858. See tasks. ```[tasklist] ### Tasks - [ ] https://github.com/MaterializeInc/materialize/issues/19824 - [ ] https://github.com/MaterializeInc/materialize/issues/19825 - [ ] https://github.com/MaterializeInc/materialize/issues/19830 - [ ] https://github.com/MaterializeInc/materialize/issues/19829 - [ ]...

The following queries fail in mz but succeed in Postgres: ``` materialize=> select 'Jun 01 2023 11:22:33 +0000'::DATE; ERROR: invalid input syntax for type date: unknown units Jun: "Jun 01...