Skip to content

fix: Add ORDER BY to guarantee output order#1903

Merged
averikitsch merged 4 commits into
GoogleCloudPlatform:masterfrom
olavloite:issue-1491
Dec 28, 2019
Merged

fix: Add ORDER BY to guarantee output order#1903
averikitsch merged 4 commits into
GoogleCloudPlatform:masterfrom
olavloite:issue-1491

Conversation

@olavloite

Copy link
Copy Markdown
Contributor

Add ORDER BY SingerId DESC to the sample query to guarantee the order of the returned values. This will fix the failing SpannerSample.queryWithArrayOfStruct sample.

@olavloite olavloite requested a review from a team December 20, 2019 14:32
@googlebot googlebot added the cla: yes This human has signed the Contributor License Agreement. label Dec 20, 2019
@averikitsch

Copy link
Copy Markdown
Contributor

Does this affect the meaning of the docs that this sample is used in?

@olavloite

Copy link
Copy Markdown
Contributor Author

No, the meaning of the docs stays the same and is not affected by the additional ORDER BY statement. See https://cloud.google.com/spanner/docs/structs#querying_data_with_an_array_of_struct_objects

(The code was also already changed for Node.js as the same problem occurred there)

@averikitsch averikitsch added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Dec 28, 2019
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Dec 28, 2019
@averikitsch averikitsch merged commit 5778b63 into GoogleCloudPlatform:master Dec 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

cla: yes This human has signed the Contributor License Agreement.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants