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.
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
Created attachment 169333 [details] arbitrary ~/.odbc.ini to reproduce
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.
fixed in master, backports to 7-1 and 7-0 in gerrit
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.
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.