Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: make the interface of SHOW and EXPLAIN more consistent #3467

Closed
jseldess opened this issue Jul 31, 2018 · 0 comments
Closed

sql: make the interface of SHOW and EXPLAIN more consistent #3467

jseldess opened this issue Jul 31, 2018 · 0 comments
Assignees
@jseldess
Labels
C-product-change
Milestone
2.1

Comments

@jseldess
Copy link
Contributor

jseldess commented Jul 31, 2018 •
edited
Loading

PR: cockroachdb/cockroach#27098

From release notes:

The SHOW CREATE statement has been simplified and can be used equivalently on tables, views, and sequences without having to specify the type of object to inspect. [#27098][#27098] {% comment %}doc{% endcomment %}

The column labels in the output of SHOW COLUMNS have been renamed for consistency with information_schema. The new generation_expression column reports the expression used for computed columns. [#27098][#27098] {% comment %}doc{% endcomment %}

The column labels in the output of EXPLAIN and all SHOW statements have been renamed for consistency. [#27098][#27098] {% comment %}doc{% endcomment %}
@jseldess jseldess added this to the 2.1 milestone Jul 31, 2018
This was referenced Jul 31, 2018
Closed
Closed
@jseldess jseldess self-assigned this Aug 6, 2018
@jseldess jseldess added in progress and removed ready labels Aug 8, 2018
@jseldess jseldess mentioned this issue Aug 8, 2018
Closed
jseldess added a commit that referenced this issue Aug 8, 2018
@jseldess
Update all SHOW statements
c262afa 
Fixes #3467.
Fixes #3371.

This PR updates the primary places in the docs where we cover
SHOW statements. There may still be some out-dated examples,
but we can update those as we go.

This PR also combines SHOW CREATE TABLE, SHOW
CREATE VIEW, and SHOW CREATE SEQUENCE into a single SHOW
CREATE page, and removes the experimental status
from SHOW CONSTRAINTS.

EXPLAIN will be handled separately.
@jseldess jseldess mentioned this issue Aug 8, 2018
Merged
jseldess added a commit that referenced this issue Aug 8, 2018
@jseldess
Update all SHOW statements
bb28ad2 
Fixes #3467.
Fixes #3317.

This PR updates the primary places in the docs where we cover
SHOW statements. There may still be some out-dated examples,
but we can update those as we go.

This PR also combines SHOW CREATE TABLE, SHOW
CREATE VIEW, and SHOW CREATE SEQUENCE into a single SHOW
CREATE page, and removes the experimental status
from SHOW CONSTRAINTS.

EXPLAIN will be handled separately.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jseldess jseldess

Labels
C-product-change
Projects
None yet
Milestone
2.1
Development

No branches or pull requests
1 participant
@jseldess