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 335295 - execSQL misbehaviour
execSQL misbehaviour
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: Database plugin
1.6.x
Other Linux
: Normal normal
: ---
Assigned To: Rodrigo Moya
Jody Goldberg
: 172213 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2006-03-20 23:22 UTC by Bryce Nesbitt
Modified: 2018-05-22 13:14 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Bryce Nesbitt 2006-03-20 23:22:21 UTC
Please describe the problem:
Using Gnumeric 1.6.1 from the SUSE supplimentary distribution,
along with gnome-database-properties 1.3.91 and Postgres 8.0.3.

Also tested with mySQL 4.1.13 with similar results.

Steps to reproduce:
1. Set up a postgres data source in gnome-database-properties
2. Enter array forumula =execSQL("Postgres Test","fishy","fishfish","select
addr1,addr2 from eg_pod limit 6").
3. Use the awful syntax inherited from Excel to execute this: ctrl-shift-enter.
4. Observe that just two rows and one column of valid data are returned.  The
rest of the cells get '0'.

Actual results:
Partial data.

Expected results:
All the data.

Does this happen every time?
Yes.

Other information:
Note that it seems to ignore the first three parameters (source, login and
password).  And libgda asks me for the password two more times before the data
is returned.
Comment 2 Jon Kåre Hellan 2006-10-19 20:42:59 UTC
Testing with gnumeric and libgda CVS (1.7.3 and 1.9.104) and the sqlite provider, I get all the rows.

Username and password in the execSQL statement seems to be ignored, I'm prompted for them.
Comment 3 Bryce Nesbitt 2006-10-30 16:18:11 UTC
Beyond this: I'd love a way to return results without needing to know the number of columns and rows in advance.

I'd love a simple "enter some sql" box, that returns the proper number of rows (with headers).
Comment 4 Bryce Nesbitt 2007-08-29 08:21:21 UTC
Reconfirmed with Gnumeric 1.6.3 from SUSE (current release).

=execSQL("ezsched","postgres","","select * from route")
1	0	0	0
2	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
Comment 5 Bryce Nesbitt 2007-08-29 16:05:41 UTC
Retested with MySQL 5.0.26.  Bug still present:

=execSQL("mtest","root","fishfish","select * from CCS_TERMS")
1  0
2  0
0  0
0  0

Oddly if I mess with this enough something happens and data is returned.  But I can't repeat that part (getting the data).

The "would split an array" thing is annoying too.

Comment 6 Bryce Nesbitt 2007-08-29 16:09:35 UTC
libgda is 1.3.91 in this case (SUSE 10.2).
Comment 7 Andreas J. Guelzow 2010-06-01 06:41:06 UTC
*** Bug 172213 has been marked as a duplicate of this bug. ***
Comment 8 GNOME Infrastructure Team 2018-05-22 13:14:17 UTC
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/50.