GNOME Bugzilla – Bug 172213
execSQL returns one less records
Last modified: 2010-06-01 06:41:06 UTC
Please describe the problem: ExecSQL seems to return wrong number of records. Ex: I have a mysql connection, to the bugzilla DB, having 3 products (I can see them if I browse the database with the data connection tool). Selecting 3 or more rows and 1 column, entering the query: execSql("bugs", "bugzilla", "the_password","select name from products") returns only the first two names in the products table. Steps to reproduce: 1. configure a connection to a bugzilla db 2. select n rows and 1 column 3. execute the query above 4. check the results Actual results: some data is missing Expected results: to see all of the data Does this happen every time? yes. Other information:
rodrigo : can you replicate this ?
Testing with gnumeric and libgda CVS (1.7.3 and 1.9.104) and the sqlite provider, I get all the rows.
See also #335295
While this isn't an exact duplicate there are apparently issues with EXECSQL that should be fixed together. *** This bug has been marked as a duplicate of bug 335295 ***