[Sqlalchemy-tickets] Issue #3428: Warning about unresolved label when passing argument via text() to order_by (zzzeek/sqlalchemy)

[Priit L. <iss...@bi...>]

New issue 3428: Warning about unresolved label when passing argument via text() to order_by
https://bitbucket.org/zzzeek/sqlalchemy/issue/3428/warning-about-unresolved-label-when

Priit Laes:

When passing following argument to order_by as `text('(count=0)')`, sqlalchemy-1.0.4 emits following warning. This seems to be a regression from 0.9 series. 

```
#!python

sqlalchemy/sql/compiler.py:572: SAWarning: Can't resolve label reference '(stock = 0)'; converting to text() (this warning may be suppressed after 10 occurrences)
```


The order clause itself looks like this (`stock` and `price` come via labelled columns from joined tables):
`.order_by(Product.id, '(stock = 0)', 'price', Warehouse.min_days)`

I have yet to extract a nice self-contained testcase for SQLAlchemy, but here's an example SQLFiddle http://sqlfiddle.com/#!15/fbfe4/5 which showcases the way I use the '(stock = 0)' as an argument to order_by.