cockroachdb / cockroachdb/cockroach

ui: table list confused when table name contains special whitespace

Open
#94,327 2 comments 0 reactions 0 assignees View on GitHub
A-webui-databases C-bug T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

(Found via #94027)

**Describe the problem**

When a table name contains special whitespace characters _which are allowed in PostgreSQL_, the table view in the DB console breaks down.

**To Reproduce**

1. run `cockroach demo --empty`
2. type in `CREATE TABLE "a`, press enter key
3. complete on a 2nd line: ` b" (x int);`
4. navigate to db console -> databases -> defaultdb

See:
- all table metadata is unavailable
- there is a red error banner at the bottom
- javascript console report: `RequestError: admin-show-columns: relation "defaultdb.public.ab" does not exist`

**Expected behavior**

The db console should support special whitespace (including `\n`, `\f`, `\v`, `\t`) without problem.

**Additional data / screenshots**
image

**Environment:**
- `master` branch towards v23.1

Epic: CRDB-20388

Jira issue: CRDB-22830

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.