I'm using sqlalchemy 0.7.1 on openSUSE 11.4 (which has python2.7) but
the problem was also observed with older versions of python.
Basically, with_only_columns seems to "lose" information about the columns:
import sqlalchemy as sa
e = sa.create_engine( 'sqlite:///' )
conn = e.connect()
m = sa.MetaData()
m.bind = conn
t = sa.Table('a', m, sa.Column('a', sa.String()) )
t.create()
s1 = sa.select( [t.c.a, sa.func.length(t.c.a), t.c.a * 2 ] )
cols = [ c for c in s1.c ]
s2 = s1.with_only_columns( cols )
print s1
print s2
conn.execute(s1)
conn.execute(s2)
--
Jon
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
