search

hankinsoft / SQLPro

SQLPro bug & features tracking.
104 stars 27 forks source link

Renaming a table doesn't update autocomplete suggestions #922

Closed gabriel-r closed 1 year ago

gabriel-r commented 1 year ago

Describe the bug Renaming a table doesn't update autocomplete suggestions, old table name still listed

To Reproduce Steps to reproduce the behavior:

  1. Connect to a Postgres DB, with a table name myrecords_once
  2. Type a query and notice the nice autocomplete for table names
  3. Rename the table to myrecords_later
  4. Type a query and "oh no!"

Expected behavior New table name should be listed

Screenshots Screenshot 2023-07-29 at 15 10 47 SQLPro Studio — public p1_ids_2023_upto_07-28

Environment details (please complete the following information):

hankinsoft commented 1 year ago

If you wait about 10 seconds, then check the autocomplete again, has it updated?

gabriel-r commented 1 year ago

A good workaround is to use the Refresh option in the table or DB contextual menu. But it still looks and feels bad.

hankinsoft commented 1 year ago

Fixed for a build which should be available late next week.

hankinsoft commented 1 year ago

2023.56 should now be available on setapp and should sort this. If you get the chance, please check if this now works as expected.

gabriel-r commented 1 year ago

Works well, even the color highlighting in the editor picks up the new mismatching table name on-the-fly.

Tested on SetApp latest.