ResultProxy doesn't respect keys defined at Table object

Please see test case:

from sqlalchemy import create_engine, MetaData, Table, Column, Integer

e = create_engine("sqlite://")
m = MetaData(bind=e)
t = Table("t", m, Column("a", Integer, key="b"))
m.create_all()

e.execute(t.insert().values(b=1))
print [for x in e.execute(t.select())](x.b)

and execution result:

Traceback (most recent call last):
  File "test.py", line 9, in <module>
    print [for x in e.execute(t.select())](x.b)
  File "/Users/andreypopp/Workspace/zvq/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2667, in _key_fallback
    expression._string_or_unprintable(key))
sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 'b'"

While I think that that should work fine and return [1](1).

Comments (10)