Incorrect autocomplete behavior (Aliases not used in autocompletion if schema is present)

dbeaver / dbeaver

Free universal database tool and SQL client

https://dbeaver.io

Apache License 2.0

39.37k stars 3.41k forks source link

Incorrect autocomplete behavior (Aliases not used in autocompletion if schema is present) #23275

Open rizzipat opened 5 months ago

rizzipat commented 5 months ago

Description

"from "autocompletion assigns a name to the table but does not use the same name when suggesting fields, putting in table name instead.

DBeaver Version

Comunity Edition Versione 24.0.1.202403241413

Operating System

Windows 11

Database and driver

DB2 for IBM i

Steps to reproduce

1: select * from where

Additional context

No response

Destrolaric commented 5 months ago

@rizzipat ~~Hi, it looks like there were other queries before this one; it looks like autocompletion didn't recognize that the previous query context was closed. Could you provide the query that uses this alias?~~ nevermind Confirmed, thanks for the report.

rizzipat commented 5 months ago

Has the same behavior even on a new script. The field names are correct but unfortunately it prepends the table name instead of the alias