Hello,

Shouldn't SQLAlchemy emit (at least) a warning when a window function is mapped with an orm.column_property(), marked deferred=True, and accessed without query.options(orm.undefer()) context (.. or maybe it's the role of the dev to call it in a non-deferred context?) ?

For example:

'row_number' : orm.column_property(
                sql.func.row_number().\
                over(partition_by=table['content'].c.container_id,
                     order_by=table['content'].c.weight.desc()),
                deferred = True
            )

will always return 1 in a deferred context ..

Julien

--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to