work on only one database

[neckva]

Describe the bug I don't know if it's really a bug or the expected behaviour. When I fill in the "database" field with the database I want to work on, I still have access to all the databases in connections. So I don't understand what's the point of the "database" field if you can't choose? Above all, it's annoying because when I make a query, often a table with the same name exists in both databases (test and production), which means I have to specify it each time.

Expected behavior I only want access to my database.

Desktop (please complete the following information):

• SQLTools Version 0.28.0
• VS Code Version: 1.82.2 on code server 4.17.0
• OS: ubuntu 23.04
• Driver:
  • [ ] PostgreSQL/Redshift
  • [x] MySQL/MariaDB
  • [ ] MSSQL/Azure
  • [ ] SQLite
  • [ ] Other? Which...
• Database version: mariadb 10.3.32

[gjsjohnmurray]

Is your case the same as #1065?

You wrote "all the databases in connections". Have you defined several MySQL connections, each to a different database? Are you being offered tables from all of them when you are writing a query? If so, does this only happen when they are in the "connected" state?