Bump transport from 6.6.2 to 6.7.0 in /modules/elasticsearch (#1344)
Bump transport from 6.6.2 to 6.7.0 in /modules/elasticsearch (#1344)

Bumps [transport](https://github.com/elastic/elasticsearch) from 6.6.2 to 6.7.0.
<details>
<summary>Commits</summary>

- [`8453f77`](https://github.com/elastic/elasticsearch/commit/8453f7701de25c467ce08088ddddac185cb8028c) SQL: Preserve original source for cast/convert function ([#40271](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40271))
- [`8b9fd09`](https://github.com/elastic/elasticsearch/commit/8b9fd0937d1e1a4ef95dc0db6b111ff80955104a) Reduce retention lease sync intervals ([#40302](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40302))
- [`c1999c7`](https://github.com/elastic/elasticsearch/commit/c1999c7b604793bc808b3685f11610def576a154) SQL: fix LIKE function equality by considering its pattern as well ([#40260](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40260))
- [`3522b00`](https://github.com/elastic/elasticsearch/commit/3522b00ae6c46cb3154fb660d998ee4ddd7ceb4c) Moving tests in locale-aware test file ([#40254](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40254))
- [`145e10b`](https://github.com/elastic/elasticsearch/commit/145e10b52e45818a84b7afaa6c627faba9e82769) Fix so non super users can also create API keys ([#40028](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40028)) ([#40288](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40288))
- [`e9ab087`](https://github.com/elastic/elasticsearch/commit/e9ab0879077df9f07c783005a4da0b37cd8a1d90) SQL: Fix issue with getting DATE type in JDBC ([#40207](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40207))
- [`3c00866`](https://github.com/elastic/elasticsearch/commit/3c008663a2749ff38804700bf0163814369b703f) SQL: Fix issue with optimization on queries with ORDER BY/LIMIT ([#40256](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40256))
- [`6998ea7`](https://github.com/elastic/elasticsearch/commit/6998ea7280772816b503d72ce9a5621328848c82) SQL: Fix issue with date columns returned always in UTC ([#40163](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40163))
- [`df1883d`](https://github.com/elastic/elasticsearch/commit/df1883d745f074d4d0c3de41726bddbf80c16243) Fix snapshot restore logging on fresh restore ([#40252](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40252))
- [`d5b26a4`](https://github.com/elastic/elasticsearch/commit/d5b26a46cd2e2b6d75442385b59427ad102c0419) Cascading primary failure lead to MSU too low ([#40249](https://github-redirect.dependabot.com/elastic/elasticsearch/issues/40249))
- Additional commits viewable in [compare view](https://github.com/elastic/elasticsearch/compare/v6.6.2...v6.7.0)
</details>
<br />

[![Dependabot compatibility score](https://api.dependabot.com/badges/compatibility_score?dependency-name=org.elasticsearch.client:transport&package-manager=gradle&previous-version=6.6.2&new-version=6.7.0)](https://dependabot.com/compatibility-score.html?dependency-name=org.elasticsearch.client:transport&package-manager=gradle&previous-version=6.6.2&new-version=6.7.0)

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting `@dependabot rebase`.

[//]: # (dependabot-automerge-start)
If all status checks pass Dependabot will automatically merge this pull request.

[//]: # (dependabot-automerge-end)

---

<details>
<summary>Dependabot commands and options</summary>
<br />

You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot ignore this [patch|minor|major] version` will close this PR and stop Dependabot creating any more for this minor/major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
- `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme

Additionally, you can set the following in the `.dependabot/config.yml` file in this repo:
- Update frequency (including time of day and day of week)
- Automerge options (never/patch/minor, and dev/runtime dependencies)
- Pull request limits (per update run and/or open at any time)
- Out-of-range updates (receive only lockfile updates, if desired)
- Security updates (receive only security updates, if desired)

Finally, you can contact us by mentioning @dependabot.

</details>
outofcoffee/testcontainers-java,rnorth/test-containers,testcontainers/testcontainers-java,testcontainers/testcontainers-java,testcontainers/testcontainers-java,outofcoffee/testcontainers-java,rnorth/test-containers,outofcoffee/testcontainers-java,rnorth/test-containers