Cursors with invalid names not handled properly in SQL/pgwire mix

[dvarrazzo]

Describe the problem

If a cursor name is not a valid identifier (but can be used in double quotes), pgwire describe seems unable to find it.

To Reproduce

The following script fails with psycopg.errors.InvalidCursorName: unknown portal "1-2-3":

import os
import psycopg

with psycopg.connect(os.environ["DSN"]) as conn:
    with conn.cursor("1-2-3") as cur:
        cur.execute("select generate_series(1,3)")
        cur.fetchall() == [(1,), (2,), (3,)]

Handling this name at purely sql level has no problem:

defaultdb=> begin;
BEGIN

*defaultdb=> DECLARE "1-2-3" CURSOR FOR select generate_series(1, 3) as bar;
DECLARE CURSOR

*defaultdb=> fetch 1 from "1-2-3";
┌─────┐
│ bar │
├─────┤
│   1 │
└─────┘
(1 row)

Environment:

• CockroachDB version 22.1.3

Jira issue: CRDB-17557
Epic CRDB-14049

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-experience (found keywords: import)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}