[Sqlalchemy-tickets] [sqlalchemy] #2896: fire_sequence logic can get tripped on a non-sequence backend

[sqlalchemy <mi...@zz...>]

#2896: fire_sequence logic can get tripped on a non-sequence backend
--------------------+--------------------------------------------
 Reporter:  zzzeek  |           Owner:  zzzeek
     Type:  defect  |          Status:  new
 Priority:  high    |       Milestone:  0.8.xx
Component:  sql     |        Severity:  very major - up to 2 days
 Keywords:          |  Progress State:  in queue
--------------------+--------------------------------------------
 {{{
 #!python
 from sqlalchemy import *
 e = create_engine("sqlite://", echo=True)
 metadata = MetaData()

 task = Table('y', metadata,
     Column('set_id', Integer, primary_key=True)
     )
 dataset = Table("x", metadata,
     Column("set_id", Integer, Sequence("some_seq"), primary_key=True)
 )

 dataset.append_constraint(ForeignKeyConstraint([dataset.c.set_id],
 [task.c.set_id]))

 metadata.create_all(e)

 e.execute(dataset.insert())
 }}}

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2896>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python