fix(test/alloydbainl): use explicit SQL alias prompt in integration test - #3916

🤖 I have created a release *beep* *boop*
---


##
[1.11.0](v1.10.0...v1.11.0)
(2026-09-10)


### Features

* Add Toolbox version check on startup
([#3837](#3837))
([7d36de3](7d36de3))
* **alloydb:** Provide actionable error when read-only mode is used on
pre-PG17
([#3902](#3902))
([28ace11](28ace11))
* **MCP Apps:** Add support for MCP Apps
([#4008](#4008))
([9cf3e95](9cf3e95))
* **MCPResources:** Add support for MCP Resources
([#3968](#3968))
([fb227b0](fb227b0))
* **mcp:** Serve groups/list and groups/get as a Toolbox extension
([#3914](#3914))
([eaf2a9c](eaf2a9c))
* **source/bigquery:** Attach SQLCommenter attributes as BigQuery job
labels ([#3843](#3843))
([bf0f1a5](bf0f1a5))
* **sources:** Add ConnectOnce, a helper for connecting on first use
([#3905](#3905))
([16c31fa](16c31fa))


### Bug Fixes

* **docs/cloudgda:** Document context fields, fix PSV example and links
([#3919](#3919))
([ae47535](ae47535))
* **looker:** Update want clause
([#3962](#3962))
([9593321](9593321))
* **source/http:** Block IETF protocol assignments range in default SSRF
guard ([#3909](#3909))
([4302e86](4302e86))
* **sources:** Release the handle when a source fails to connect
([#3921](#3921))
([0001190](0001190))
* **test/alloydbainl:** Use explicit SQL alias prompt in integration
test ([#3916](#3916))
([596eaf9](596eaf9))

---
This PR was generated with [Release
Please](https://github.com/googleapis/release-please). See
[documentation](https://github.com/googleapis/release-please#release-please).

Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com>

mcp-toolbox 1.11.0

Created-by: HarmonybrewBot
Commit-by: HarmonybrewBot
Merged-by: HarmonybrewBot
Description: Created by `brew bump`

---

Created with `brew bump-formula-pr`.<details>
  <summary>release notes</summary>
  <pre>## [1.11.0](googleapis/mcp-toolbox@v1.10.0...v1.11.0) (2026-09-10)


### Features

* Add Toolbox version check on startup ([#3837](googleapis/mcp-toolbox#3837)) ([7d36de3](googleapis/mcp-toolbox@7d36de3))
* **alloydb:** Provide actionable error when read-only mode is used on pre-PG17 ([#3902](googleapis/mcp-toolbox#3902)) ([28ace11](googleapis/mcp-toolbox@28ace11))
* **MCP Apps:** Add support for MCP Apps ([#4008](googleapis/mcp-toolbox#4008)) ([9cf3e95](googleapis/mcp-toolbox@9cf3e95))
* **MCPResources:** Add support for MCP Resources ([#3968](googleapis/mcp-toolbox#3968)) ([fb227b0](googleapis/mcp-toolbox@fb227b0))
* **mcp:** Serve groups/list and groups/get as a Toolbox extension ([#3914](googleapis/mcp-toolbox#3914)) ([eaf2a9c](googleapis/mcp-toolbox@eaf2a9c))
* **source/bigquery:** Attach SQLCommenter attributes as BigQuery job labels ([#3843](googleapis/mcp-toolbox#3843)) ([bf0f1a5](googleapis/mcp-toolbox@bf0f1a5))
* **sources:** Add ConnectOnce, a helper for connecting on first use ([#3905](googleapis/mcp-toolbox#3905)) ([16c31fa](googleapis/mcp-toolbox@16c31fa))


### Bug Fixes

* **docs/cloudgda:** Document context fields, fix PSV example and links ([#3919](googleapis/mcp-toolbox#3919)) ([ae47535](googleapis/mcp-toolbox@ae47535))
* **looker:** Update want clause ([#3962](googleapis/mcp-toolbox#3962)) ([9593321](googleapis/mcp-toolbox@9593321))
* **source/http:** Block IETF protocol assignments range in default SSRF guard ([#3909](googleapis/mcp-toolbox#3909)) ([4302e86](googleapis/mcp-toolbox@4302e86))
* **sources:** Release the handle when a source fails to connect ([#3921](googleapis/mcp-toolbox#3921)) ([0001190](googleapis/mcp-toolbox@0001190))
* **test/alloydbainl:** Use explicit SQL alias prompt in integration test ([#3916](googleapis/mcp-toolbox#3916)) ([596eaf9](googleapis/mcp-toolbox@596eaf9))

| **OS/Architecture**                                                                                       | **Description**                                                                                                          | **SHA256 Hash**                                                     |
| --------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------- |
| [linux/amd64](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/linux/amd64/toolbox) ([Signature](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/linux/amd64/toolbox.asc)) | For **Linux** systems running on **Intel/AMD 64-bit processors**.                                                        | 4d86b7c75916e2de721b9dc9dfb681f9a29fe4a8a01779007b2f6b1f5819296c    |
| [darwin/arm64](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/darwin/arm64/toolbox)     | For **macOS** systems running on **Apple Silicon** (M1, M2, M3, etc.) processors.                                        | 5e94db330b5ec77a916c4670ec1337d97abbb9865b13a705f81f87ca14592307    |
| [darwin/amd64](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/darwin/amd64/toolbox)     | For **macOS** systems running on **Intel processors**.                                                                   | 4a05bc786302571823f8c10b0ed2ce4f219c4a05c9899e91a9743ca8ec932743    |
| [windows/amd64](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/windows/amd64/toolbox.exe) | For **Windows** systems running on **Intel/AMD 64-bit processors**.                                                      | 3c8c46d8efad225636e341fcdb137557779ee1c1b0c362d1b4870901c2668ccf    |
| [windows/arm64](https://storage.googleapis.com/mcp-toolbox-for-databases/v1.11.0/windows/arm64/toolbox.exe) | For **Windows** systems running on **ARM 64-bit processors**.                                                            | feb2d0d55c003b30af7a9afa22f11721239c70cc21812a2de66c425de76a2153    |</pre>
  <p>View the full release notes at <a href="https://github.com/googleapis/mcp-toolbox/releases/tag/v1.11.0">https://github.com/googleapis/mcp-toolbox/releases/tag/v1.11.0</a>.</p>
</details>
<hr>

See merge request: Harmonybrew/homebrew-core!19994

The AI-NL tests asserted the full response string, which embeds the SQL
column alias chosen by the model. The model does not reliably honour the
requested alias and sometimes returns `result` instead of `number_one`,
failing the test even though the query returned the correct value.

#3877 and #3916 tried to stabilise this by rewriting the prompt. Nothing
in the tool contract binds the alias, so a prompt can only lower the
failure rate.

Match the affected responses with a regex that accepts any single column
set to 1. The row and column counts are still pinned, so the assertion
can still catch a genuine regression.

#4125)

## Description

These tests asserted the full response string, which includes the SQL
column alias chosen by the model. The model sometimes returns `result`
instead of `number_one`, so the test failed even though the query
returned the correct value.

#3877 and #3916 tried to fix this by rewriting the prompt. Nothing in
the tool contract binds the alias, so a prompt can only lower the
failure rate.

This matches the affected responses with a regex that accepts any single
column set to 1. Row and column counts are still pinned so the assertion
can still catch a real regression. Cases that assert error messages are
unchanged.

Integration tests need live AlloyDB credentials and were not run
locally. `go vet` and `gofmt` are clean. The patterns were checked
against the response shapes from both endpoints, including the exact
string in the failure report.

## PR Checklist

- [x] Make sure you reviewed

[CONTRIBUTING.md](https://github.com/googleapis/mcp-toolbox/blob/main/CONTRIBUTING.md)
- [x] Make sure to open an issue as a

[bug/issue](https://github.com/googleapis/mcp-toolbox/issues/new/choose)
  before writing your code! That way we can discuss the change, evaluate
  designs, and agree on the general idea
- [x] Ensure you have manually reviewed the entire diff before
requesting a
  review
- [x] Ensure the tests and linter pass
- [x] Code coverage does not decrease (if any source code was changed)
- [x] Appropriate docs were updated (if necessary)
- [ ] Make sure to add `!` if this involve a breaking change

🛠️ Fixes #3874

Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>