Closed sqlalchemy-bot closed 16 years ago
Michael Bayer (zzzeek) wrote:
thanks for the bug report, this issue is fixed in 7f43bc55e027b6419ac5a9893515ad9581c98538 with some test coverage added.
If any problems arise within the ORM stage of things feel free to post to the mailing list or open more tickets.
Changes by Michael Bayer (zzzeek): set state to "resolved"
Issue created by Anonymous
I want to create a select object onto a view or table in the database which doesn't have a full sqlalchemy Table definition. I can do this using the text() feature to create a select object which referenced my table in plain text.
However, a problem arises if I want to then use this select as a subselect of another query. To do this, my select must have an alias. However, in 0.4.3 this causes an error which was not present in 0.3.9. The issue can be illustrated with a single line of code:
which throws the error
It is not possible to set an oid_column property on the select or the from clause. On the select it is a read only property, and the _TextFromClause has no such property.