googleapis / googleapis/google-cloud-go
spannertest: ReadUsingIndex returns incorrect results
Open
api: spanner
priority: p2
- Dominant language
- Go
- Stars
- 4.5k
- Forks
- 1.6k
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 109
Description
Tested with spanner package v1.41.0 AND v1.44.0
```sql
CREATE INDEX FooBarIndex ON Foo(Bar);
```
```go
barValue := "bar"
query := "SELECT Bar FROM Foo @{FORCE_INDEX=FooBarIndex} WHERE Bar = @barValue"
iter := s.client.Single().Query(ctx, spanner.Statement{
SQL: query,
Params: map[string]interface{}{
"barValue": barValue,
},
})
// retval: ["bar", "bar", "bar"]
```
```go
iter := s.client.Single().ReadUsingIndex(ctx, "Foo", "FooBarIndex", spanner.KeySets(spanner.Key{barValue}), []string{"Bar"})
// retval: []
```
Contributor guide
Assessment
This issue has not been assessed yet.