search

wmjie / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

Sequence object generates invalid sql #85

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
seq = Sequence('MySequence')

nextid = db2.execute(seq)

Output SQL: 
SELECT NEXTVAL FORMySequence FROM SYSIBM.SYSDUMMY1

Expected Output:
SELECT NEXTVAL FOR MySequence FROM SYSIBM.SYSDUMMY1

Workaround:
seq = Sequence(' MySequence') # Insert a space before sequence name

nextid = db2.execute(seq)

Running version ibm_db_sa 2.0 on win7/python2.5

Original issue reported on code.google.com by TjaartB...@gmail.com on 4 Oct 2011 at 3:07

GoogleCodeExporter commented 9 years ago 
Thanks for reporting,

This issue fixed by changeset #147 
(http://code.google.com/p/ibm-db/source/detail?r=147).

Original comment by jazlee on 5 Oct 2011 at 9:16