GoogleCloudPlatform / GoogleCloudPlatform/cloud-spanner-emulator

Missing INFORMATION_SCHEMA.INDEXES.SEARCH_(PARTITION_BY|ORDER_BY)

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

Description

These columns are missing in `INFORMATION_SCHEMA.INDEXES`.
- `SEARCH_PARTITION_BY`
- `SEARCH_ORDER_BY`

In cloud-spanner-emulator v1.5.52:

```
spanner> DESCRIBE SELECT * FROM INFORMATION_SCHEMA.INDEXES;
+---------------------+---------------+
| Column_Name | Column_Type |
+---------------------+---------------+
| TABLE_CATALOG | STRING |
| TABLE_SCHEMA | STRING |
| TABLE_NAME | STRING |
| INDEX_NAME | STRING |
| INDEX_TYPE | STRING |
| PARENT_TABLE_NAME | STRING |
| IS_UNIQUE | BOOL |
| IS_NULL_FILTERED | BOOL |
| INDEX_STATE | STRING |
| FILTER | STRING |
| SPANNER_IS_MANAGED | BOOL |
| SEARCH_PARTITION_BY | ARRAY |
| SEARCH_ORDER_BY | ARRAY |
+---------------------+---------------+
```

In real instance:

```
spanner> DESCRIBE SELECT * FROM INFORMATION_SCHEMA.INDEXES;
+--------------------+-------------+
| Column_Name | Column_Type |
+--------------------+-------------+
| TABLE_CATALOG | STRING |
| TABLE_SCHEMA | STRING |
| TABLE_NAME | STRING |
| INDEX_NAME | STRING |
| INDEX_TYPE | STRING |
| PARENT_TABLE_NAME | STRING |
| IS_UNIQUE | BOOL |
| IS_NULL_FILTERED | BOOL |
| INDEX_STATE | STRING |
| SPANNER_IS_MANAGED | BOOL |
+--------------------+-------------+
```

## Note
* These columns are not yet documented in https://docs.cloud.google.com/spanner/docs/information-schema#indexes.
* Related: #330

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.