Toad World® Forums

user_part_histograms bug


#1

Hi all,

Toad last prod (12.12.0.39) x64 and last beta (13.0.0.69) x64.
db 11.2.0.3 x64 (client as well)

Simple query:

SELECT table_name || ‘.’ || partition_name sql_string
FROM user_part_histograms PH
GROUP BY TABLE_NAME, PARTITION_NAME
HAVING count(DISTINCT COLUMN_NAME) = 0
ORDER BY TABLE_NAME, PARTITION_NAME;

produce error:ORA-00900 Invalid SQL query (F9 or F5).

Interesting part is that SQL Optimizer (9.2.2.270) x64, has the same problem.

Obviously the same parser machine
:slight_smile:

Brg

Damir