After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 172213 - execSQL returns one less records
execSQL returns one less records
Status: RESOLVED DUPLICATE of bug 335295
Product: Gnumeric
Classification: Applications
Component: Database plugin
1.4.x
Other All
: Normal normal
: ---
Assigned To: Rodrigo Moya
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-03-31 10:07 UTC by dfszb
Modified: 2010-06-01 06:41 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description dfszb 2005-03-31 10:07:28 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:
Comment 1 Jody Goldberg 2005-05-30 14:22:49 UTC
rodrigo : can you replicate this ?
Comment 2 Jon Kåre Hellan 2006-10-19 20:42:05 UTC
Testing with gnumeric and libgda CVS (1.7.3 and 1.9.104) and the sqlite provider, I get all the rows.
Comment 3 Bryce Nesbitt 2007-08-29 08:22:14 UTC
See also #335295
Comment 4 Andreas J. Guelzow 2010-06-01 06:41:06 UTC
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 ***