dbeaver / dbeaver/dbeaver

"Generate SQL" -> SELECT .. WHERE .. IN: generates incorrect query for system tables

Open
#35,147 2 comments 0 reactions 0 assignees View on GitHub
xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

"Generate SQL" generates incorrect query: there is no column name and values in IN-operator.

- Execute this query:
```
select *
from pg_stat_activity

```

https://github.com/user-attachments/assets/b837f7f7-2818-48cd-9e2c-531933bd9636

### DBeaver Version

Community Edition 24.1.5.202408012322

### Operating System

Windows 10

### Database and driver

PostgreSQL 16
PostgreSQL JDBC Driver 42.7.2

### Steps to reproduce

_No response_

### 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.