[Bug]: SHOW tables; did not show tables

[ianu82]

Short description of current behavior

A user using MSSQL in MindsDB Cloud connected to a DB. Running the Show Tables; command showed the tables within MindsDB as expected. That is working.

But then the user used USE to switch to the database they'd connected and did SHOW tables; and the return was empty. No tables were shown. However, there are tables in the database.

There may be an error on the DB connection itself and Treeview also failed for this same DB.

MindsDB Team: Please see General channel in Slack for the user's screenshare of this problem.

Video or screenshots

No response

Expected behavior

No response

How to reproduce the error

No response

Anything else?

No response

[tomhuds]

Slack message for ref: https://mindsdb.slack.com/archives/C5R3N7XS8/p1685055310301419