Bug 139239

Summary:	Database-wizard: List box for ODBC: No value could be chosen by key with VCL: gtk3
Product:	LibreOffice	Reporter:	Robert Großkopf <robert>
Component:	Base	Assignee:	Caolán McNamara <caolan.mcnamara>
Status:	RESOLVED FIXED
Severity:	normal	CC:	caolan.mcnamara, serval2412
Priority:	medium
Version:	6.4.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:	target:7.2.0 target:7.1.1 target:7.0.5
Crash report or crash signature:		Regression By:
Attachments:	arbitrary ~/.odbc.ini to reproduce

Description Robert Großkopf 2020-12-26 08:11:18 UTC

For this bug you need moe than one database, which could connected to through ODBC.

Open LO.
Start "Base Database".
1. Step: Connect to an existing database → ODBC
2. Step: Set up ODBC Connection → Browse.
List box for Data sources appear.
Type the first characters of the data source and press Enter.

This happens with gtk3: a textbox appears and you could type the characters, but nothing has been chosen in the list box by this. You could type the whole name of the database and it won't be chosen.

This happens with VCL: kf5: Typing a key will set the selected value to the first data source, which could be chosen and start with the character. Typing again the second value with the same starting character will be chosen.

Behavior of gtk3 is a bug. Textbox does nothing. You have to chose the data source by mouse.

Solution: Delete this textbox if gtk3 couldn't work with it.

All tested with LO 6.4.5.2, also with LO 7.1.0.1 on OpenSUSE 15.1 64bit rpm Linux.

Comment 1 Julien Nabet 2021-01-31 13:31:20 UTC

On pc Debian x86-64 with master sources updated today, I could reproduce this.

Caolán: thought you might be interested in this one since it's specific to gtk3

Comment 2 Caolán McNamara 2021-01-31 16:48:14 UTC

Created attachment 169333 [details]
arbitrary ~/.odbc.ini to reproduce

Comment 3 Commit Notification 2021-01-31 19:29:53 UTC

Caolán McNamara committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/515763dd9106c5e2237fc7515628d37700fddc00

Resolves: tdf#139239 set correct search column

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 4 Caolán McNamara 2021-01-31 19:31:59 UTC

fixed in master, backports to 7-1 and 7-0 in gerrit

Comment 5 Commit Notification 2021-02-01 11:23:14 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/f37ac606dd92d85ccdc8189f274213888a594c84

Resolves: tdf#139239 set correct search column

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 6 Commit Notification 2021-02-01 11:38:33 UTC

Caolán McNamara committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/5da235b0f2371b97cc719dc0e357834b2fb52ab9

Resolves: tdf#139239 set correct search column

It will be available in 7.0.5.

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.