This issue consists of three parts linked together:
Not all available columns are added when expanding symbol * using Ctrl + Space for queries with joins.
there are no aliases for expanded columns in resulted query text
formatting of the resulting query should take into account some option in settings (if it is true then each new column should be presented on a new line, otherwise - in one line)
DBeaver Version
Community Edition 24.1.0
Operating System
Windows 10
Database and driver
PostgreSQL 16
PostgreSQL JDBC Driver 42.7.2
Steps to reproduce
Use this code:
SELECT
*
FROM pg_class as c
JOIN pg_attribute as a ON a.attrelid = c.oid
JOIN pg_type as t ON t.oid = a.atttypid;
set input pointer after symbol * and press Ctrl + Space
Expected:
all columns from three tables are added
aliases should be presented for each column to distinguish in code which table the column related to (for example: c.relname, ... a.attname, ...)
if some setting in options is set to true, then all columns are placed on the same line, otherwise - each column - on a new line
See below the desired behaviour released in DbForge
Actual:
only columns from first table are added
there is no alias before each column name (relname, ... attname ...)
E1izabeth
commented
4 months ago
Description
This issue consists of three parts linked together:
DBeaver Version
Community Edition 24.1.0
Operating System
Windows 10
Database and driver
PostgreSQL 16 PostgreSQL JDBC Driver 42.7.2
Steps to reproduce
Use this code: SELECT * FROM pg_class as c JOIN pg_attribute as a ON a.attrelid = c.oid JOIN pg_type as t ON t.oid = a.atttypid;
set input pointer after symbol * and press Ctrl + Space
Expected:
Actual:
Additional context
Desired behaviour: