On Tue, Jul 10, 2012 at 11:31 AM, Michael Bayer <mike...@zzzcomputing.com>wrote:

> So some modifications to CTE are made in r079123b04dc6 (0.8) /
> ra742d1526e86 (0.7)  such that CTEs are now rendered based on name-based
> logic only.  A given CTE name will only be rendered as a full statement
> once, and precedence rules now ensure that the "outermost" CTE is the one
> that's rendered in all cases.   Two entirely non-related CTEs with the same
> name now generates a CompileError.
>

Awesome.  Thanks for the changes, Mike.  I confirmed it works as advertised
for 0.7.9 (but you knew that).

Until 0.7.9 is released I'll just use the "cte_working" alias trick.  Your
fix makes it unnecessary, but it doesn't seem to do any harm and will still
work later so I'm set.

Thanks again.  And yeah, I agree that CTE thing/syntax is more than a bit
confusing in general!  Incredibly useful, though.

Russ

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to