Created attachment 317311 [details] Test script Description of problem: For more complicated select query text values are not returned correctly. Version-Release number of selected component (if applicable): sqlite-3.5.6-2.fc9.i386 works OK sqlite-3.5.9-1.fc9.i386 does not work How reproducible: Always. Steps to Reproduce: 1. Run the attached script. Actual results: u'/first' u'2long' ERROR u'/first' u'3longestaaa' ERROR u'/first' u'4shorter.ext' ERROR u'/secon' u'1.ext' ERROR u'/second' u'2long' ERROR u'/second' u'3longestaaa' ERROR u'/second' u'4shorter.ext' ERROR u'/second' u'4shorter.ext' OK Expected results: u'/first' u'1.ext' OK u'/first' u'2longer.ext' OK u'/first' u'3longestaaa.ext' OK u'/first' u'4shorter.ext' OK u'/second' u'1.ext' OK u'/second' u'2longer.ext' OK u'/second' u'3longestaaa.ext' OK u'/second' u'4shorter.ext' OK
Verified (thanks for the nice reproducer case). It's already fixed upstream: http://www.sqlite.org/cvstrac/chngview?cn=5341, ticket http://www.sqlite.org/cvstrac/tktview?tn=3201 Will fix shortly, just pondering what to do about rawhide (update to slightly incompatible 3.6.2 or just patch this up) which is affected too atm.
sqlite-3.5.9-2.fc9 has been pushed to the Fedora 9 testing repository. If problems still persist, please make note of it in this bug report. If you want to test the update, you can install it with su -c 'yum --enablerepo=updates-testing update sqlite'. You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F9/FEDORA-2008-8499
sqlite-3.5.9-2.fc9 has been pushed to the Fedora 9 stable repository. If problems still persist, please make note of it in this bug report.