Missing FROM keyword

Issue #111 resolved
Former user created an issue

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)

  1. Log in to comment