GoogleCloudPlatform / GoogleCloudPlatform/cloud-spanner-emulator

Add support for `ALTER SEARCH INDEX`

Open
#324 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
334
Forks
77
Avg merge
8m
Merged PRs (30d)
2

Description

It appears the emulator does not support the [`ALTER SEARCH INDEX`](https://docs.cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language#search_index_statements) syntax.

The following statement

```sql
ALTER SEARCH INDEX foo ADD COLUMN bar;
```

produces

```
Caused by: com.google.cloud.spanner.SpannerBatchUpdateException:
INVALID_ARGUMENT: io.grpc.StatusRuntimeException:
INVALID_ARGUMENT: Error parsing Spanner DDL statement:
ALTER SEARCH INDEX foo ADD COLUMN bar : Syntax error on line 1, column 7: Encountered 'SEARCH' while parsing: alter_statement
```

### Version
Image: 1.5.50 (958afe2419dd1)
https://console.cloud.google.com/artifacts/docker/cloud-spanner-emulator/us/gcr.io/emulator/sha256:958afe2419dd17c44f8205dfc63ad11ec00cbca3a8135bc3effde46a71dbc4e8

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.