execSQL misbehaviour
Submitted by Bryce Nesbitt
Link to original bug (#335295)
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