[Sqlalchemy-users] selectone broken >= r1181

[Florian Boesch]

selectone of a mapper does not work anymore.

See atachment for demo programm.
import traceback

engine = create_engine('oracle://dsn=orcl&user=test&password=test')

foo = Table('foo', engine, Column('id', Integer, Sequence('foo_seq'), primary_key=True))
class Foo(object): pass
foos = mapper(Foo, foo)
try: foo.drop()
except: pass
try: foo.create()
except: pass

foos.selectone() #this gives the exception below

'''
File "selectone.py", line 13, in ?
  foos.selectone()
File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.1.4-py2.4.egg/sqlalchemy/mapping/mapper.py", line 496, in selectone
  raise InvalidRequestError('Multiple rows returned for selectone')
sqlalchemy.exceptions.InvalidRequestError: Multiple rows returned for selectone
'''