[12.2.387 Pro] - Object info in popup (MariaDB)

[12.2.387 Pro] - Object info in popup (MariaDB)

When hovering the cursor over an object (eg. a table) in the editor, the popup window should show the comment on that object (if applicable). However, this does not happen until the object in the Database Explore is hovered over. As soon as you hover the cursor over the object in the Database Explorer, the comment that was missing from the popup appears, regardless of the location, it works in the editor after that. It also refreshes (in case it is cached) after eg. an ALTER TABLE t COMMENT 'whatever'; statement.

Check this short video here.

I believe the root cause is that comments aren't yet in the cache, we are trying to delay some queries to shorten the loading times for intellisense items. While with MariaDB and Postgres reading system catalog views is quick, with some other databases like Oracle that's a very heavy lifting task.

One quick workaround for that, in the mouse over hint in the editor, click the Info link. It will show Info pane with object and column comments, and with some other stuff. and will also add it to the cache.