Bug 72637 - Embedded Firebird : table not re-displayed after a sort
Summary: Embedded Firebird : table not re-displayed after a sort
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.2.0.0.beta2
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-12 11:13 UTC by ribotb
Modified: 2014-10-12 08:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
firebird sort (22.82 KB, application/x-zip)
2013-12-12 11:16 UTC, ribotb 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description ribotb 2013-12-12 11:13:03 UTC 
My OS : Windows 7 SP1 32birs

I want to sort a table to display record in a certain order.
- Open a table
- Click on [Sort] button and choose a field or click on [Sort ascending] or [Sort descending] button
- Table is not re-displayed.
see attached file firebird_sort.zip

Bernard Ribot
Comment 1 ribotb 2013-12-12 11:16:29 UTC 
Created attachment 90658 [details]
firebird sort
Comment 2 Robert Großkopf 2013-12-12 14:56:12 UTC 
Can confirm this bug. Open a table in internal firebird, mark a colum, press [Sort ascending],[Sort descending] or try to change [Sort] → the whole data would disappear.
Comment 3 Robert Großkopf 2013-12-12 14:57:43 UTC 
Have forgotten to switch the platform. My test-system is openSUSE 12.3 64bit rpm Linux.
Comment 4 Julien Nabet 2013-12-14 00:20:31 UTC 
On pc Debian x86-64 with master sources updated today, I can reproduce this.

I noticed this:
warn:legacy.tools:7447:1:svtools/source/brwbox/brwbox1.cxx:1599: no column object - invalid id?

I created a simple table with 2 fields and 4 lines
open table
nNewPos = 1
pCols->size() = 3

after having clicked sort, gdb session gives:
nNewPos = 65535
pCols->size() = 1

part of bt:
#0  BrowseBox::GoToColumnId (this=0x1704210, nColId=65535, bMakeVisible=1 '\001', bRowColMove=0 '\000')
    at /home/julien/compile-libreoffice/libo/svtools/source/brwbox/brwbox1.cxx:1596
#1  0x00002aaaae7e45fe in BrowseBox::GoToColumnId (this=0x1704210, nColId=65535) at /home/julien/compile-libreoffice/libo/svtools/source/brwbox/brwbox1.cxx:1578
#2  0x00002aaaca8d2d41 in FmXGridPeer::setCurrentColumnPosition (this=0x16fe470, nPos=0) at /home/julien/compile-libreoffice/libo/svx/source/fmcomp/fmgridif.cxx:2327
#3  0x00002aaaca8c9fd3 in FmXGridControl::setCurrentColumnPosition (this=0x16fef50, nPos=0) at /home/julien/compile-libreoffice/libo/svx/source/fmcomp/fmgridif.cxx:931
#4  0x00002aaacbf117b9 in dbaui::SbaXDataBrowserController::setCurrentColumnPosition (this=0x170b790, _nPos=0)
    at /home/julien/compile-libreoffice/libo/dbaccess/source/ui/browser/brwctrlr.cxx:2693
#5  0x00002aaacbf08a50 in dbaui::SbaXDataBrowserController::applyParserOrder (this=0x170b790, _rOldOrder="", _xParser=
    uno::Reference to (dbaccess::OSingleSelectQueryComposer *) 0x1afac80) at /home/julien/compile-libreoffice/libo/dbaccess/source/ui/browser/brwctrlr.cxx:1707

I gave a try with hsqldb by creating a brand new ODB file with the same table and I don't reproduce this.

Andrzej/Lionel: put you in cc since you might be interested in this tracker
Comment 5 Julien Nabet 2014-10-12 07:06:48 UTC 
On pc Debian x86-64 with 4.3.2 Debian package, I don't reproduce this anymore.
Putting it as WFM.

If I'm wrong/missed something, don't hesitate to reopen this tracker of course.
Comment 6 ribotb 2014-10-12 08:53:41 UTC 
It's OK with:
Version: 4.3.2.2
Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d

and with:
Version: 4.4.0.0.alpha0+
Build ID: 9aa36a1ad39e37c372cc833a44fba450b8cc30cd
TinderBox: Win-x86@42, Branch:master, Time: 2014-10-09_03:25:27

Bernard