dbeaver / dbeaver/dbeaver

Column 'Filter by value' not working if foreign key constraint is set

Open
#22,234 3 comments 0 reactions 1 assignee Claimed by @Matvey16 View on GitHub
x:mysql xf:data xf:filters xf:metadata
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.