- changed status to resolved
Missing FROM keyword
Issue #111
resolved
Try this:
from sqlalchemy import *
engine = create_engine('sqlite://filename=:memory:', echo=True)
test = Table('test', engine, Column('id', Integer, primary_key=True))
test.create()
select([func.max(test.c.id)](func.max(test.c.id))).execute()
It only generates SELECT max(test.id)
. There is no FROM
keyword.
However, this works:
select([func.max(test.c.id)](func.max(test.c.id)), test.c.id>0).execute()
Comments (1)
-
repo owner - Log in to comment
fixed in changeset:1127 + unit test added