Toad World® Forums

Toad Insight column filter shows no columns

Howdy!

In 12.10b7 (and also 12.9 GA), I have this query:

SELECT
bm.table_name,
dt.blocks8192/1024/1024 size_mb,
SUM(bm.expected_rows) rows_to_del
FROM busy_master bm JOIN dba_tables dt ON bm.table_name = dt.table_name
WHERE dt.owner = ‘ASDKLF’
GROUP BY bm.table_name, dt.blocks
8192/1024/1024, dt.num_rows
ORDER BY 2 DESC;

I want to add “dt.num_rows” to the columns selected, so I add a row in the SELECT columns, type “dt.” and wait 1500ms. The Toad Insight popup shows with all of the columns in DBA_TABLES. I type “N” in the filter and the columns all disappear. If I simplify the query down to:

SELECT
bm.table_name
FROM busy_master bm JOIN dba_tables dt ON bm.table_name = dt.table_name;

…Toad Insight works as expected when I add the new column. Thoughts???

TIA!
Rich