Bug 139298 - EDITING: New created query doesn't show any row every time
Summary: EDITING: New created query doesn't show any row every time
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.0.1 rc
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Caolán McNamara
URL:
Whiteboard: target:7.2.0 target:7.1.0
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2020-12-29 07:16 UTC by Robert Großkopf
Modified: 2021-01-22 10:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-12-29 07:16:45 UTC
Open any database file.
Go to "Queries"  → "Create Query in Design View …"
Create a query and test this query and run this query (Edit → Run Query [F5]) in design view.
There is no content shown in the query.

This bug happens every time in LO 7.1.0.1 on OpenSUSE 15.2 64bit rpm Linux.
Comment 1 Julien Nabet 2020-12-29 09:18:05 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

No specific logs on console.
Comment 2 Julien Nabet 2020-12-29 09:19:18 UTC
Also the query works because once saved, if we double click query to execute it, the result displays well.
Comment 3 Aron Budea 2021-01-01 09:00:17 UTC
Bibisected to the following consecutive commits that are a single commit in repo bibisect-linux-64-7.1. Adding CC: to Caolán McNamara.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=5f7cf9ccba25a94c275ec67936dc29f0adb4129a
author		Caolán McNamara <caolanm@redhat.com>	2020-08-10 19:49:25 +0100
committer	Caolán McNamara <caolanm@redhat.com>	2020-08-12 20:22:23 +0200

"use InterimDBTreeListBox"

https://cgit.freedesktop.org/libreoffice/core/commit/?id=7b314c6aceb51d01b9b4314764b0f5852b4fb655
author		Caolán McNamara <caolanm@redhat.com>	2020-08-10 21:05:46 +0100
committer	Caolán McNamara <caolanm@redhat.com>	2020-08-12 20:22:41 +0200

"drop now unused DBTreeListBox"
Comment 4 Caolán McNamara 2021-01-20 09:37:51 UTC
building the identified commit confirms it, though still a mystery as to why
Comment 5 Caolán McNamara 2021-01-20 17:20:43 UTC
got it: https://gerrit.libreoffice.org/c/core/+/109720
Comment 6 Commit Notification 2021-01-21 09:15:11 UTC
Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/e2b3b0b36558c719795644bdfa2853db5a8d6db7

tdf#139298 New created query doesn't show any row

It will be available in 7.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 7 Caolán McNamara 2021-01-21 09:34:35 UTC
fixed in master, backports to 7-1 and 7-1-0 in gerrit
Comment 8 Commit Notification 2021-01-21 15:20:48 UTC
Caolán McNamara committed a patch related to this issue.
It has been pushed to "libreoffice-7-1":

https://git.libreoffice.org/core/commit/c22c707743814e2fa199a0517b510c12abaebc92

tdf#139298 New created query doesn't show any row

It will be available in 7.1.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 9 Commit Notification 2021-01-22 09:24:28 UTC
Caolán McNamara committed a patch related to this issue.
It has been pushed to "libreoffice-7-1-0":

https://git.libreoffice.org/core/commit/aa83592b46e3acc3049fae9460e0df747b8c08ff

tdf#139298 New created query doesn't show any row

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.