Database selector in the query editor doesn't show options after clicking on it

[kevinwcyu]

What happened:

I noticed when updating e2e tests that the database selector doesn't show options unless it's opened, closed, and then opened again. Looks like it only happens in Grafana v10+. I didn't notice a problem with the Redshift datasource with uses the same ResourceSelector component.

Screen.Recording.2023-10-18.at.9.39.49.AM.mov

What you expected to happen:

Here's how it was working when running in Grafana v9.4.7

Screen.Recording.2023-10-18.at.9.46.53.AM.mov

How to reproduce it (as minimally and precisely as possible):

1. Run Athena in Grafana v10+
2. Add a panel with an Athena DS and click the database selector
3. Click away from the database selector to close it
4. Click the database selector again and now the options should appear.

Anything else we need to know?:

Environment:

• Grafana version: 10+
• Plugin version: 2.12.0

[nmarrs]

Upon closer review, it appears that this issue is impacting more than just the "database" selector but seems to be an issue for "region", "data source", "database", possibly "table". "column" seems to be the only selector that consistently works as expected

Screen.Recording.2024-10-03.at.3.40.28.PM.mov

[nmarrs]

My best understanding of where this issue is that react state was being updated but because of the array reference was not being rewritten the component was not re-rendering. In the case of redshift it appears that the state is being updated + modified into a new object as part of the fetch which is probably why the query form component is being rerendered and options are showing up as expected.