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.

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

sql: alias availability zone and zone #59251

Closed
awoods187 opened this issue Jan 21, 2021 · 2 comments · Fixed by #59270
Closed

sql: alias availability zone and zone #59251

awoods187 opened this issue Jan 21, 2021 · 2 comments · Fixed by #59270
Assignees
Labels
A-multiregion Related to multi-region C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Comments

@awoods187
Copy link
Contributor

We should focus on using Zone in our docs, but it would be nice to alias availability zone in case someone forgets:

root@127.0.0.1:26257/movr> ALTER DATABASE movr SURVIVE AVAILABILITY ZONE FAILURE;
invalid syntax: statement ignored: at or near "availability": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
ALTER DATABASE movr SURVIVE AVAILABILITY ZONE FAILURE
                            ^
HINT: try \h ALTER DATABASE
root@127.0.0.1:26257/movr> ALTER DATABASE movr SURVIVE ZONE FAILURE;
ALTER DATABASE SURVIVE

Time: 45ms total (execution 24ms / network 22ms)
@awoods187 awoods187 added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Jan 21, 2021
@awoods187 awoods187 added the A-multiregion Related to multi-region label Jan 21, 2021
@ajstorm
Copy link
Collaborator

ajstorm commented Jan 22, 2021

Weird. At one point I thought we had the AVAILABILITY in there. @otan?

@otan
Copy link
Contributor

otan commented Jan 22, 2021

i think you argued that you didn't want it 😂

#56837

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-multiregion Related to multi-region C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants