SQLTable.itervalues() can be interrupted by other queries

[GoogleCodeExporter]

What steps will reproduce the problem?
see test_itervalues_long() in sqltable_test.py

What is the expected output? What do you see instead?
itervalues() and values() should return the same set of values.

Kenny Daily reported this problem originally in the context of an
AnnotationDB based upon a SQLTable sliceDB.  For details see this thread:
http://groups.google.com/group/pygr-dev/msg/7b3752ac44f35fff?hl=en

Original issue reported on code.google.com by cjlee...@gmail.com on 20 Jun 2009 at 2:32

[GoogleCodeExporter]

Kenny, please test that this fixes your specific reproducible.  Get the latest 
source
from github master branch.

Original comment by cjlee...@gmail.com on 20 Jun 2009 at 3:21

• Changed state: FixedNeedsReview

[GoogleCodeExporter]

Hi Kenny,
by the way, to test this, the SQLTable for the sliceDB must have been created 
with
the serverInfo argument (instead of the cursor argument).  This enables the 
SQLTable
to create a new cursor object for the iterator, to isolate it from other queries
performed against the same table.

-- Chris

Original comment by cjlee...@gmail.com on 22 Jun 2009 at 8:41

[GoogleCodeExporter]

Original comment by mare...@gmail.com on 4 Sep 2009 at 8:33

• Added labels: Milestone-Release0.8, reviewby-kmdaily

[GoogleCodeExporter]

I tested this, and the solution works fine.

Original comment by kmda...@gmail.com on 15 Nov 2010 at 11:02

• Changed state: ReviewedNeedsCommit

[GoogleCodeExporter]

Original comment by cjlee...@gmail.com on 17 Dec 2010 at 11:38

• Changed state: Closed