execSQL misbehaviour

Submitted by Bryce Nesbitt

Description

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:

Set up a postgres data source in gnome-database-properties
Enter array forumula =execSQL("Postgres Test","fishy","fishfish","select addr1,addr2 from eg_pod limit 6").
Use the awful syntax inherited from Excel to execute this: ctrl-shift-enter.
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.

Version: 1.6.x