psql tab completion broken for storage servers, tags, profiles and resource groups (pre-PG15 query format)

Offen Anfängerfreundlich
#2,316 0 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen

Maintainer antworten meist innerhalb von 2 Tagen

@allenvox arbeitet bereits daran.

Seit 14.11.2026.

  • #2321 von @allenvox — offen

Bewertung

Schwierigkeit
2/5
Geschätzter Aufwand
1-3 Stunden
Anfängerfreundlichkeit
72/100
Issue-Typ
Bug
Klarheit
Klar beschrieben
Aktivitätsstatus
Aktiv
Tech-Stack
c, postgresql
Bereich
cli, databases

Rechercherichtung

Die vier Makros Query_for_list_of_tags, Query_for_list_of_resgroups, Query_for_list_of_storage_servers und Query_for_list_of_profiles befinden sich in src/bin/psql/tab-complete.c. Vergleiche sie mit Query_for_list_of_servers, das bereits die PG16-Form mit einem einzigen LIKE '%s' verwendet. Stelle die vier auf diese Form um, baue psql neu und prüfe, dass TAB nach ALTER TAG t_ oder ALTER STORAGE SERVER s_ Namen ohne coordinator-ERROR vervollständigt. Die zugehörigen Regeln für COMMENT und DROP STORAGE SERVER sind getrennt und können hier oder in #2312 behandelt werden.

Vom Indexierungsmodell aus dem Issue-Text verfasst.

Beschreibung

Apache Cloudberry version

main

What happened

psql tab completion of object names does not work for four Cloudberry-specific object types: storage servers, tags, profiles and resource groups. Pressing TAB after ALTER STORAGE SERVER , ALTER TAG , DROP TAG , ALTER PROFILE , ALTER RESOURCE GROUP , etc. offers nothing, even when matching objects exist. Each attempt also logs a server-side ERROR on the coordinator.

Root cause. These four query macros in src/bin/psql/tab-complete.c still use the pre-PG15 template form:

Query_for_list_of_tags        ... WHERE substring(pg_catalog.quote_ident(tagname),1,%d)='%s'
Query_for_list_of_resgroups   ... WHERE substring(pg_catalog.quote_ident(rsgname),1,%d)='%s'
Query_for_list_of_storage_servers ... WHERE substring(pg_catalog.quote_ident(srvname),1,%d)='%s'
Query_for_list_of_profiles    ... WHERE substring(pg_catalog.quote_ident(profilename),1,%d)='%s'

Upstream commit 02b8048ba5d ("psql: improve tab-complete's handling of variant SQL names", PG15) changed the template contract. _complete_from_query() now does

appendPQExpBuffer(&query_buffer, simple_query, e_object_like, e_ref_object, e_ref_schema);

and expects a single LIKE '%s'. Upstream's own macros were converted when the PG16 code was merged, but these Cloudberry-specific ones were not. As a result, %d receives a char * (undefined behavior) and %s receives the NULL e_ref_object. The generated query looks like this:

ERROR:  negative substring length not allowed
STATEMENT:  SELECT pg_catalog.quote_ident(srvname) FROM pg_catalog.gp_storage_server
            WHERE substring(pg_catalog.quote_ident(srvname),1,-1478678816)='(null)'

When the garbage length happens to be positive, the query runs but matches nothing.

What you think should happen instead

Object names should complete. Convert the four macros to the PG16 form, as Query_for_list_of_servers already does:

#define Query_for_list_of_storage_servers \
" SELECT srvname "\
"   FROM pg_catalog.gp_storage_server "\
"  WHERE srvname LIKE '%s'"

The other three need the same change. The storage-server conversion has been verified: with psql rebuilt and driven through a pty, ALTER STORAGE SERVER <TAB> lists the servers, and the coordinator ERROR disappears.

How to reproduce
CREATE TAG t_demo;
CREATE PROFILE p_demo;
CREATE STORAGE SERVER s_demo OPTIONS (endpoint 'x');

In interactive psql, press TAB after each of the following. None of them completes:

  • ALTER TAG t_
  • ALTER PROFILE p_
  • ALTER STORAGE SERVER s_
  • ALTER RESOURCE GROUP admin_

The coordinator log gets one bad query per completion attempt, against gp_storage_server, pg_tag, pg_profile and pg_resgroup, all of the substring(...,1,<garbage>)='(null)' form.

Related completion bugs for storage servers (same area)

The single-word {"SERVER", Query_for_list_of_servers} entry in words_after_create, and the generic COMMENT ON X Y → IS rule, win over the multi-word "STORAGE SERVER". This gives:

  • DROP STORAGE SERVER <TAB> and CREATE STORAGE USER MAPPING FOR u STORAGE SERVER <TAB> complete foreign servers (for example gp_exttable_server).
  • COMMENT ON STORAGE SERVER <TAB> completes IS instead of a server name.
  • ALTER STORAGE SERVER s <TAB> offers RENAME TO, but the grammar has no such form.

The following additions were verified to fix the first three cases (the user-mapping case still needs its own rule):

else if (Matches("COMMENT", "ON", "STORAGE", "SERVER"))
    COMPLETE_WITH_QUERY(Query_for_list_of_storage_servers);
...
else if (Matches("DROP", "STORAGE", "SERVER") ||
         Matches("DROP", "STORAGE", "SERVER", "IF", "EXISTS"))
    COMPLETE_WITH_QUERY(Query_for_list_of_storage_servers);
Operating System

Linux (platform independent)

Anything else

Found while reviewing #2312. That PR touches the ALTER STORAGE SERVER <name> completion line but not the issues above. The storage-server part can be fixed there or here.

Vorherrschende Sprache
C
Sterne
1.4k
Forks
273
Ø Merge
4 T. 6 Std.
Gemergte PRs (30 T.)
105

Entwicklungsumgebung

Erste Schritte

  1. Lesen Sie das ganze Issue und danach den Beitragsleitfaden des Projekts.
  2. Schreiben Sie ins Issue, dass Sie es übernehmen — das erspart doppelte Arbeit.
  3. Forken Sie das Repository und arbeiten Sie in einem Branch.
  4. Öffnen Sie einen Pull Request, der die Issue-Nummer nennt.

Mehr aus apache/cloudberry

Alle Issues in apache/cloudberry

Ähnliche Issues

Weitere Issues zu C

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.