# user\_part\_histograms bug

**URL:** <https://forums.toadworld.com/t/user-part-histograms-bug/40864>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 25, 2018, 9:13pm UTC](https://forums.toadworld.com/t/user-part-histograms-bug/40864 "2018-04-25T21:13:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [April 25, 2018, 9:13pm UTC](https://forums.toadworld.com/t/user-part-histograms-bug/40864/1 "2018-04-25T21:13:51Z")

</div>

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).

 ![26.04.png](https://global.discourse-cdn.com/quest/original/2X/c/c494352c4218ee9585a93778dc140250dbd23066.png)

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

Obviously the same parser machine  
🙂

Brg

Damir