spanner: fix ITs to order results in SELECT queries
The Cloud Spanner emulator can return results in a randomized order.
Change-Id: I617c734a5d602e2d940b970fc7e0d88ba002b8ad
Reviewed-on: https://code-review.googlesource.com/c/gocloud/+/53810
Reviewed-by: kokoro <noreply+kokoro@google.com>
Reviewed-by: Shanika Kuruppu <skuruppu@google.com>
diff --git a/spanner/integration_test.go b/spanner/integration_test.go
index 15aa480..3c99954 100644
--- a/spanner/integration_test.go
+++ b/spanner/integration_test.go
@@ -394,7 +394,7 @@
got, err := readAll(su.Query(
ctx,
Statement{
- "SELECT SingerId, FirstName, LastName FROM Singers WHERE SingerId IN (@id1, @id3, @id4)",
+ "SELECT SingerId, FirstName, LastName FROM Singers WHERE SingerId IN (@id1, @id3, @id4) ORDER BY SingerId",
map[string]interface{}{"id1": int64(1), "id3": int64(3), "id4": int64(4)},
}))
if err != nil {
@@ -728,7 +728,7 @@
got, err := readAll(ro.Query(
ctx,
Statement{
- "SELECT SingerId, FirstName, LastName FROM Singers WHERE SingerId IN (@id1, @id3, @id4)",
+ "SELECT SingerId, FirstName, LastName FROM Singers WHERE SingerId IN (@id1, @id3, @id4) ORDER BY SingerId",
map[string]interface{}{"id1": int64(1), "id3": int64(3), "id4": int64(4)},
}))
if err != nil {
