Column 'Filter by value' not working if foreign key constraint is set
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 183
Description
### Description
If I want to use the 'Filter by value' Feature from a column header and enter a value, which is present in a row into the 'Choose value(s) to filter' input field, the value will not be selectable in the list to create a filter from it.
Everything works fine, when I remove the foreign_key_constriant form the column and follow the same procedure.
### DBeaver Version
Community Edition Version 23.3.0.202312031432
### Operating System
Ubuntu 22.04
### Database and driver
mysql Ver 15.1 Distrib 10.5.21-MariaDB, for debian-linux-gnu (x86_64) running inside a docker container
### Steps to reproduce
1. Open a table having a foreign key constraint on a column in 'Data' view
2. Right click the header of this column and select 'Filter by value'
3. Enter a value present in row of this column => No value is shown in the list to select for filter creation
4. Select 'Properties' view
5. Select 'Foreign Keys'
6. Remove the the foreign key of the column and save
7. Go back to data view, repeat 2. and 3. => The value is shown in the list to select for filter creation
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.