My Oracle Support Banner

SQL Developer Using Auto-complete List Displays Too Many Candidates For Column Names Based Simple Prefix (Doc ID 2903707.1)

Last updated on FEBRUARY 11, 2023

Applies to:

Oracle SQL Developer - Version 22.2.1 and later
Information in this document applies to any platform.

Symptoms

ENV
====
Windows 10
SQLDEV 22.2.1

Problem Description
---------------------------------------------------
Auto-complete list too many columns

When using alias for a table in a query with multiple tables, the auto-complete for columns list other table's columns. In the example below, the auto-complete for b. would show columns of table a.

SELECT a.c1, b.<ctrl+space>
FROM t1 a, t2 b;
Ctrl space after a. and both a and b tables appear

Tested in SQL Developer 22.2.1 and reproduced issue.
Tested in SQL Developer 22.2.0 and reproduced issue.
Tested in SQL Developer 21.4.3 and did not reproduce the issue.
Tested in SQL Developer 21.4.2 and did not reproduce the issue.

Workaround

Use SQL Developer 21.4.3.  Bug is predicted to be fixed in 23.1.0RC2

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.