cockroachdb / cockroachdb/cockroach
\dC+ command in SQL shell gives an error
- 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
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