sql: alter database set primary region does not work

[awoods187]

SET PRIMARY REGION does not work while simply dropping SET works:

root@127.0.0.1:26257/movr> ALTER DATABASE movr SET PRIMARY REGION "us-east1";
invalid syntax: statement ignored: at or near "set": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
ALTER DATABASE movr SET PRIMARY REGION "us-east1"
                    ^
HINT: try \h ALTER DATABASE
root@127.0.0.1:26257/movr> ALTER DATABASE movr PRIMARY REGION "us-east1";
ALTER DATABASE PRIMARY REGION

Time: 46ms total (execution 23ms / network 23ms)

This is despite hints telling you to use set:

ALTER DATABASE movr ADD REGION "us-east";
ERROR: cannot add region "us-east" to database movr
SQLSTATE: 42P12
HINT: you must add a PRIMARY REGION first using ALTER DATABASE movr SET PRIMARY REGION "us-east"

We should add support for SET PRIMARY REGION.

[awoods187]

It doesn't work for alter either:

root@127.0.0.1:26257/movr> ALTER DATABASE movr SET PRIMARY REGION "us-west1";
invalid syntax: statement ignored: at or near "set": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
ALTER DATABASE movr SET PRIMARY REGION "us-west1"
                    ^
HINT: try \h ALTER DATABASE
root@127.0.0.1:26257/movr> ALTER DATABASE movr PRIMARY REGION "us-west1";
ALTER DATABASE PRIMARY REGION

Time: 46ms total (execution 22ms / network 24ms)