dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.68k stars 3.51k forks source link

Informix -Autocomplete - insert table aliases not working #35816

Open ceinmart opened 1 month ago

ceinmart commented 1 month ago

Description

Since a few versions ago the autocomplete , insert table aliases stopped to work for Informix database connections. For Oracle , SQL Server , Mysql , still working

dbeaver automcomplete

DBeaver Version

CE 24.2.1.202409221725

Operating System

Windows 10

Database and driver

IBM Informix 4.50.10.1

Steps to reproduce

  1. write a simple sql like : select * from table
  2. press ctrl+space to open the autocomplete window or complete automatically 3

Additional context

No response

MashaKorax commented 1 month ago

Thanks for your report.

ceinmart commented 1 month ago

Hi, I noticed this problem wasn't reproducible. If need any logs or active some kind of debug to get more information, please, let me know how to do and share here.

ceinmart commented 1 month ago

Complementing... What I do.

Started dbeaver with args: dbeaver.exe -vmargs "-Ddbeaver.trace.enabled=true"

With a cygwin session, at folder AppData/Roaming/DBeaverData/workspace6/.metadata , I ran tail -f dbeaver-debug.log

On dbeaver open a new SQL console, connected to the database , wrote a simple select * from <tabname> and completed it with ctrl+space.

Isn't exactly in sync , appears this error on debug log. Not sure if related with de probelm.

2024-10-07 10:50:30.832 - org.jkiss.dbeaver.model.exec.DBCException: Progress sub task without start
org.jkiss.dbeaver.model.exec.DBCException: Progress sub task without start
        at org.jkiss.dbeaver.model.runtime.DefaultProgressMonitor.subTask(DefaultProgressMonitor.java:97)
        at org.jkiss.dbeaver.model.runtime.DefaultProgressMonitor.startBlock(DefaultProgressMonitor.java:126)
        at org.jkiss.dbeaver.model.impl.AbstractSession.<init>(AbstractSession.java:49)
        at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.<init>(JDBCConnectionImpl.java:53)
        at org.jkiss.dbeaver.model.impl.jdbc.JDBCDataSource.createConnection(JDBCDataSource.java:416)
        at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.openSession(JDBCExecutionContext.java:241)
        at org.jkiss.dbeaver.model.impl.jdbc.JDBCExecutionContext.openSession(JDBCExecutionContext.java:1)
        at org.jkiss.dbeaver.model.DBUtils.openMetaSession(DBUtils.java:1735)
        at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructLookupCache.reloadObject(JDBCStructLookupCache.java:111)
        at org.jkiss.dbeaver.model.impl.jdbc.cache.JDBCStructLookupCache.getObject(JDBCStructLookupCache.java:63)
        at org.jkiss.dbeaver.ext.generic.model.GenericObjectContainer.getTable(GenericObjectContainer.java:164)
        at org.jkiss.dbeaver.ext.generic.model.GenericStructureAssistant$TableReference.resolveObject(GenericStructureAssistant.java:213)
        at org.jkiss.dbeaver.ui.editors.sql.dialogs.SuggestionInformationControl$1.run(SuggestionInformationControl.java:130)
        at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:117)
        at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
ceinmart commented 1 month ago

sorry, closed by accident... already reopened