steps: -new database -connect to an existing database: 'text' -select a folder with csv files. In database: -click on tables -double click on table name -click on 'sort ascending' or 'sort descending' result: -rows are removed from view. expected: -sort by column. (this works as expected in open office)
(just clarifying the summary ..)
In addition to the shrinking of the data grid that the reporter sees, my debug build of recent master shows an assertion raised when <sort ascending> removes the last row from the data grid. I am reporting the assertion here because of a suspicion that the assertion may shed light on the shrinkage of the data grid. For specificity, here are my STR: (1) Download soon-to-be-attached example1.csv and example1.odb to the same directory. (2) Open example1.odb from the command line. (3) In Database pane click <Tables>. (4) In Tables pane, double-click <example1>. Program displays data grid with four rows; column "number" shows values 1, 2, 3, 4. (5) In toolbar, click icon <sort ascending>. As fdo#80968 complains, the data grid shows three rows; column "number" shows values 2, 3, 4. (6) Twice more, in toolbar click icon <sort ascending>, The data grid shows one row, column "number" shows 4. (7) In toolbar click icon <sort ascending>. Program raises assertion in connectivity::flat::OFlatTable::seekRow, ETable.cxx:788. The terminal output includes (lines wrapped for readability in the bug report): soffice.bin: /home/terry/lo_hacking/git/libo2/connectivity/ source/drivers/flat/ETable.cxx:788: virtual bool connectivity::flat::OFlatTable::seekRow (connectivity::IResultSetHelper::Movement, sal_Int32, sal_Int32&): Assertion `m_nRowPos == 1 || nCurPos == lastRowPos.second' failed. Application Error Fatal exception: Signal 6 For comparison, LibreOffice 3.5.4.2, as delivered with debian-wheezy, continues to show four rows in the data grid after <sort ascending>. My LibreOffice is master commit dc795cb, fetched 2014-07-02 2357 UTC, configured: --enable-option-checking=fatal --enable-dbgutil --enable-crashdump --without-system-postgresql --without-myspell-dicts --with-extra-buildid --without-doxygen --with-external-tar=/home/terry/lo_hacking/git/src built and running on debian-wheezy 64-bit.
Created attachment 102384 [details] backtrace from raised assertion
Created attachment 102385 [details] small .csv file
Created attachment 102386 [details] .odb using the .csv
Correcting comment 2: The master version that I fetched on 2014-07-02 is 397362c.
From bibisect: c5c74730cbc91eb2e9d18540bdd35cb21a575ee9 is the first bad commit ... source-hash-0c45b5548537cffddc3fbdd6b1c2b9a8a1bdbc4a ... and: :100644 100644 b4e21c8614416d179923704fadc7546503d04c36 bd3ca519fa54a6fe9bdc5c57f9c4d152c1caebc9 M ccache.log :100644 100644 ad204c1fc5385369636b556a4d546a5fcead1ff3 b8e5174ba64f21b3eed701d429c3936e36800bf4 M commitmsg :100644 100644 9abfa19dac9efef1adb77afd8519b39f04c3156d 0694ee4d2663349a74dc0c368699203742e46004 M dev-install.log :100644 100644 f8d16f39c524e43b309b48385e461114d3603d91 3dee2057c0d1784243699d3e4d8f0af2413e5298 M make.log :040000 040000 94b4146e3181c95352b9ed90c14f889cf114a85d 65913d0ac6b1cc964184af567dec2fa039fd3b7f M opt
Adding self to CC if not already on
The behaviour seems to have changed as of the below commit. Adding Cc: to lionel@mamane.lu. Could you possibly take a look at this one? Thanks commit 48b29cd42ba10fbb3f7be697fd79a0984b4daa1b Author: Lionel Elie Mamane <lionel@mamane.lu> Date: Sun May 19 13:20:51 2013 +0200 flat db driver: reorganise OFlatTable Change-Id: I5d522abdffaf1aeb4ae0996d3a19acdcca474f95
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b00f2bbf9b970115da4452ea0aab93b1c8da7b11 fdo#80968 file resultset seek table to before beginning on opening resultset It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b8faf41a2ba7ad787c93eaa66e0665940e1d2b85&h=libreoffice-4-4 fdo#80968 file resultset seek table to before beginning on opening resultset It will be available in 4.4.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2414f02ff0d087d144b472b5b4b1f93d6e3e2960&h=libreoffice-4-3 fdo#80968 file resultset seek table to before beginning on opening resultset It will be available in 4.3.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
With versions Version: 4.5.0.0.alpha0+ Build ID: a272f5b7b30f356418ecf28eb95d066f081d1624 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-09_09:50:59 Locale: en_CA and Version: 4.5.0.0.alpha0+ Build ID: 89a81a6610cf316666291750e7300bcd1a97d062 TinderBox: Win-x86@39, Branch:master, Time: 2015-01-07_00:57:18 Locale: en_CA I observe that the reported problem is not evident. Thank you, Lionel. However, the assertion that I mentioned in comment 2 is already absent in the daily dbgutil version of 2014-11-30: the sort icon is disabled when there are no rows visible. This proves false my speculation that my assertion is related to this bug report.
*** Bug 68925 has been marked as a duplicate of this bug. ***
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]