youd have to override visit_select() and pick up on  
compiler.is_subquery().  you could then do some tricks similar to what  
oracle.py does in visit_select() to create a wrapping layer.

also i noticed the usage of a kwarg 'mssql_aliased' which seems to be  
referenced nowhere.

On Jan 30, 2008, at 7:29 PM, Rick Morrison wrote:

> Just noticed that select.count() doesn't work on MSSQL. The  
> implementation wraps the select() in an outer query; MSSQL requires  
> an alias for the inner table when you do this.
>
> What's the visit_xxx function that we need to catch in the db module  
> to ensure the inner query is "aliasized" ?
>
> >


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to