hankinsoft
Bug: Find Objects not returning matching columns
Describe the bug
Describe the bug Searching, "Find objects", does not search columns
To Reproduce Steps to reproduce the behavior:
- Find objects
- Fuzzy match, containing, matching - all exhibit same behavior
- Search for a known column name
- No results
Expected behavior If I search for "ProviderID" it should return the column that is named that.
Screenshots If applicable, add screenshots to help explain your problem.
Additional details Enter any additional details we should know about.
Product
SQLPro for MSSQL
App version
Version 2025.91 (Build 115613.5)
Platform
macOS
Installation source
App Store
Can you reproduce, then send me the log files? You can find the logs by going to 'View' -> 'Logs'. I would suggest clearing them out first, then re-launching the app and trying a search. Then sending the updated logs.
I am searching exactly for an existing column name. It appears to work for tables. But not columns.
2026/01/08 22:37:18:384 Application is becoming active.
2026/01/08 22:37:19:630 -- <Enter HSDatabaseTreeScopeTabViewController:updateSearchResults:442>
2026/01/08 22:37:19:631 -- <Exit HSDatabaseTreeScopeTabViewController:updateSearchResults:442> took 0.00 seconds.
2026/01/08 22:37:19:686 Want to update entries for 2 databases.
2026/01/08 22:37:19:686 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:686 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:686 MSSQL updateSearchEntries took: 0.000106 (2 databases).
2026/01/08 22:37:19:715 Want to update entries for 9 databases.
2026/01/08 22:37:19:715 MSSQLVersionHelper finding version for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 MSSQLVersionHelper version was cached for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL database search entries are NOT old, (forced refresh?: NO)
2026/01/08 22:37:19:715 MSSQL updateSearchEntries took: 0.000137 (9 databases).
2026/01/08 22:37:19:715 MSSQLVersionHelper finding version for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 MSSQLVersionHelper version was cached for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 MSSQLVersionHelper finding version for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 Database tree - searching for [ProviderInstructionsID]
2026/01/08 22:37:19:715 MSSQLVersionHelper version was cached for 0725A2E7582681EF8460C32BEBCDE653
2026/01/08 22:37:19:715 Database tree - going to search 2 entries.
2026/01/08 22:37:19:715 Database tree - search configuration:
2026/01/08 22:37:19:715 - Search scope limitation count: 0
2026/01/08 22:37:19:715 - Search type: 1 (Containing)
2026/01/08 22:37:19:715 - Case sensitivity: Ignoring case
2026/01/08 22:37:19:715 - Search scope: Everywhere
2026/01/08 22:37:19:718 Database tree - inner search took 0.00 seconds.
2026/01/08 22:37:19:718 Started reloadData
2026/01/08 22:37:19:719 Finished reloadData
2026/01/08 22:37:19:719 Database tree - finished search [ProviderInstructionsID] took 0.00 and found 0 results.
2026/01/08 22:37:19:740 Started reloadData
2026/01/08 22:37:19:740 Finished reloadData
2026/01/08 22:37:20:786 Application is resigning activity.
I am searching exactly for an existing column name. It appears to work for tables. But not columns.
Ahhhh, search does not find columns but just objects such as tables, views, procedures. I'm not positive if I feel that columns should come back here. Let me do a bit of thinking about that.