Created attachment 92726 [details] The attached file contains a table with many columns and queries GoodQurey and BugQuery demonstrating the described behaviour. I create table with more than 10 columns, columns' types are not important. When I try to open the table, I receive the following error message: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch' and no data is displayed. The same happens with a select query having more than 10 columns. Tables having 10 or less columns are opened fine. Query having 10 or less columns opens also fine even it is build from a table having more than 10 columns. The error occurs even for empty tables or queries. I am using LO 4.2.0 RC1 through RC3 with the Czech UI downloaded from the main LO site. The experimental features in the LO settings are switched on.
I have opened the bug-query. Can't confirm the bug here with OpenSUSE 12.3 Linux 64bit rpm, LO 4.2.0.3. The query works as expected. When I try the same with the table the table couldn't be opened. Should we change the title and delete the query-part? The problem: You have written about two bugs. The behavior is the same for you, but not for other people. Regards Robert
Have tested a little bit more. I could reproduce the bug for more than 12 columns in a query. I will switch this report to New.
Adding Andrjez and Lionel to CC
Sorry Andrzej, got a case of the keyboard dyslexia today ;-)
I reproduce with LO 4.2.4.1 (Win7/x86). I tried a workaround : SELECT * FROM but I have the same message. And I can't open the table (same message). Bernard
Adding as blocker for making Firebird the default
On pc Debian x86-64, I had different results according to LO version: 1) LO 4.2.4, Debian package (once enable experimental has been checked) I reproduced exactly the description - table opening : KO (with same message as indicated by Jiri) - bugQuery opening : KO - goodQuery opening : OK 2) 4.2 sources udpated today (once enable experimental has been checked) - table opening : OK - bugQuery opening : OK - goodQuery opening : OK so future 4.2.6 should be ok. Could someone give a try to 4.2.5RC1?
Look at the comment ... https://bugs.freedesktop.org/show_bug.cgi?id=76164#c8
wabik: it seems the bug can't be reproduced from 4.2.6. (see https://bugs.freedesktop.org/show_bug.cgi?id=76164#c9) Could someone give a try to the 4.2 daily build? (see http://dev-builds.libreoffice.org/daily/libreoffice-4-2/)
Version: 4.2.6.0.0+ Build ID: 743bcdebef21deeb73f0111b4e6e047c88fd7b8f TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-06-04_14:23:07 The same error: Error code: 1 firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch'
Thank you for your feedback, no idea then :-(.
When I click on good query, I get an immediate crash oOSX with my latest master build :-/ separate bug report coming
Tried opening bug query on OSX LO 4242 Error code: 1 firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch' Good query loads OK
This most probably comes from the hardcoded "10" at http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/StatementCommonBase.cxx#125 This hardcoded 10 (my guess) needs to be replaced by *runtime-determined* right value of columns in the query. Thanks to Julien Nabet for finding that piece of code, while investigating bug 79714.
(In reply to comment #14) > This hardcoded 10 (my guess) needs to be replaced by *runtime-determined* > right value of columns in the query. Reading the Firebird API doc, section DSQL programming methods / Method 3 page 101 (http://www.ibphoenix.com/files/60ApiGuide.zip - linked from http://www.firebirdsql.org/en/reference-manuals/), actually what the code does looks OK from a cursory glance. Try with 10, and if this is not enought, then reallocate and call isc_dsql_describe again. Indeed, there was a out_sqlda->sqln = n; missing, which Julien just added. Julien: doesn't your patch for bug 79714 actually fix this bug, too?
(In reply to comment #15) >.. > Julien: doesn't your patch for bug 79714 actually fix this bug, too? Yes and no. Yes because indeed, I can open both queries of the attachment (fdo#79714 doesn't include a specific attachment but links to the attachment of this fdo) on MacOs. No because there's a crash, at least with debug build when closing LO (only when I opened at least 1 of the 2 queries). That's why, I'm eager to see the result on a non debug build :)
(In reply to comment #16) > (In reply to comment #15) > >.. > > Julien: doesn't your patch for bug 79714 actually fix this bug, too? > Yes and no. > Yes because indeed, I can open both queries of the attachment (fdo#79714 > doesn't include a specific attachment but links to the attachment of this > fdo) on MacOs. > No because there's a crash, at least with debug build when closing LO (only > when I opened at least 1 of the 2 queries). > That's why, I'm eager to see the result on a non debug build :) Confirming that your patch allows me to open both queries. I don't see a crash on exit either, and I have a debug build :-) Nice work for nailing this :-))
As far as I'm concerned, you can set this to resolved fixed.
Thank you Alex for the test! So with: - on master http://cgit.freedesktop.org/libreoffice/core/commit/?id=0acd0ed3a58698a34e11dd82f3368a983f8530df - 4.3 https://gerrit.libreoffice.org/9741 - 4.2 https://gerrit.libreoffice.org/9742 and according to your comment, let's put it as FIXED.
Ooops, having just checked my autoge, I'm not using dgbutil after all, so can not confirm that a debug build doesn't cras, but at least my normal build works ;-)
I can confirm that the issue is fixed. LO 4.3.0 RC1 works fine for me. Thanks, Jiri