Description of problem: when attempting to utilize tab completion. sudo dnf install bash Error: in prepare, no such column: bash% select pkg from available where pkg like "bash%" and pkg not in (select pkg fr error here ---^ Version-Release number of selected component (if applicable): 4.16.2 Installed: dnf-0:4.16.2-2.fc39.noarch at Tue 15 Aug 2023 02:54:45 AM GMT Built : Fedora Project at Fri 04 Aug 2023 11:19:30 AM GMT Installed: rpm-0:4.18.92-1.fc39.x86_64 at Tue 15 Aug 2023 02:54:13 AM GMT Built : Fedora Project at Wed 02 Aug 2023 05:06:29 PM GMT How reproducible: every time currently Steps to Reproduce: 1.sudo dnf install bash 2.hit tab to autocomplete entry 3. Actual results: Error: in prepare, no such column: bash% select pkg from available where pkg like "bash%" and pkg not in (select pkg fr error here ---^ Expected results: package name autocompleted. Additional info:
Modifying /usr/share/bash-completion/completions/dnf line 115: from: local query="select pkg from $table WHERE pkg LIKE \"$prefix%\"" to: local query="select pkg from $table where pkg like '$prefix%'" appears to resolve.
Submitted, https://github.com/rpm-software-management/dnf/pull/1979 this appears to be related to https://sqlite.org/src/info/c995932c3ffe7f27
Changed merged, thanks for the report: https://github.com/rpm-software-management/dnf/pull/1979
*** Bug 2236786 has been marked as a duplicate of this bug. ***