> changing the poly unions to look like this fixes it:
>
> abcd_union = polymorphic_union(
> {
> 'd':a_table.join(b_table).join(c_table).join(d_table),
> 'c':a_table.join(b_table).join(c_table).select
> (a_table.c.type=="c"),
> 'b':a_table.join(b_table).select(a_table.c.type=="b"),
> 'a':a_table.select(a_table.c.type=='a')
> }, None)
oooh i get it, the 'c' and 'b' joins were also joining with the b and
c rows that were inherited by d... right?
i shouldve though of that... but thats what you get for working late
into the night :(
thanks!
> someday ill be brave enough to build these poly unions into the core
> engine...they have come a long way in recent months but i still feel
> like we're still learning about their quirks (hence i force everyone
> to learn about them :) ).
well by the time I wrap this up in SQLElixir you won't have to :)
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
