Toad World® Forums

Parser issue with CONNECT BY and START WITH on subquery factoring clause

Howdy!

In 12.10.0.10, I’m running the query from http://blog.tanelpoder.com/files/scripts/ash/ash_wait_chains.sql (***WARNING: RUNNING THAT QUERY ASSUMES YOU’VE LICENSED THE CORRECT ORACLE PACK!***) in the Editor. But the parser complains about the uber-complex format of the subqueries in the WITH clause.

I’ve tried replacing the variables with hard-coded values, but the parser still complains at the end of the WITH clause. The SQL executes fine, however.

Thoughts?
Rich

Hi Rich,

What parser (or other) message did you get?

I found out that the parser has trouble with queries containing something of the form CONNECT BY NOCYCLE (a > b) by complaining on ambiguous syntax on the START clause. (new issue QP-1733, regression since Mar 3, 2014)

Thanks,
Andre

Fixed for one of the next betas.

Yay! Thanks, Andre! I couldn’t find a way to grab the text of the popup error, and the screenshot was way ugly. [:)]

Rich

Well, let’s hope it addresses what you meant … If not then at least we made a good step forwards.

Andre

Looking good in beta 13! Thanks, Andre!

Rich