cockroachdb / cockroachdb/cockroach

\dC+ command in SQL shell gives an error

Open
#98,407 0 comments 0 reactions 0 assignees View on GitHub
C-bug
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

**Describe the problem**

In `master` builds using `cockroach demo` I am able to list the type casts using `\dC` but `\dC+` displays the following error:

~~~
demo@127.0.0.1:26257/movr> \dC+
List of casts:
ERROR: column "c.tableoid" does not exist
SQLSTATE: 42703
~~~

According to #88061 this behavior should work.

**To Reproduce**

1. Pull latest `master`.
2. Build using `/dev build short`.
3. Start demo using `./cockroach demo`.
4. Run `\dC` to show the type casts.
5. Run `\dC+` and see the error.

**Expected behavior**
The output of `\dC` with an additional **Descriptions** column.

Jira issue: CRDB-25249

Contributor guide

Open the contributing guide

Research direction

Start with the SQL shell entry points for the \dC and \dC+ commands and reproduce the failure with ./cockroach demo as described. Compare the queries used by both commands, focusing on the c.tableoid reference; done means \dC+ succeeds and includes the additional Descriptions column without an error.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sql
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.