Skip to content

i18n(ja): fix TiDB Cloud Lake docs, part 4 of 4 (SQL reference s-z) - #24443

Merged
qiancai merged 15 commits into
pingcap:i18n-ja-release-8.5from
yahonda:i18n-ja-lake-fix-sql-s-z
Oct 14, 2026
Merged

qiancai merged 15 commits into
pingcap:i18n-ja-release-8.5from
yahonda:i18n-ja-lake-fix-sql-s-z

Conversation

@yahonda

@yahonda yahonda commented Oct 13, 2026 •

Copy link
Copy Markdown
Member

What is changed, added or deleted? (Required)

This PR is part 4 of 4 that fix the Japanese TiDB Cloud Lake docs (tidb-cloud-lake/, added in #24373 and synced in #24431). The changes come from a full review of all 1,121 Japanese Lake files against the English source on release-8.5. Following the request to group related fixes, the fixes are filed as four PRs that do not touch the same files. Each PR keeps one commit per theme, so you can review it commit by commit.

This PR covers tidb-cloud-lake/sql/ files whose names start with s to z (89 files).

Commits (themes):

  • Unify the term for aggregate: use 集計関数 / 集計インデックス, which matches other databases' Japanese docs (MySQL, SQL Server, Snowflake) and the rest of the TiDB Japanese docs. Keep 集約 where values are combined into one array, JSON value, or geometry, and where the English is not "aggregate".
  • Translate step, tutorial, example, and scenario labels: "Step N", "Tutorial N", and "Example-N" in headings, and the "Scenario:" label. Heading anchors are unchanged.
  • Translate page titles of function category pages, integration task pages, and feature pages whose Japanese term is already used in the body or in sibling pages. Engine and table-format names, Full-Text Index, and Stage stay in English.
  • Fix structural and sync issues: remove links added to front matter summaries and restore lost list markers in notes.
  • Align heading anchors with English slugs: the custom anchors collapsed double hyphens and changed underscores to hyphens, so links copied from the English docs did not resolve (38 broken links in total). After this series, all anchor links in the Lake docs resolve.
  • Fix mistranslations: sentences whose meaning differs from the English, each checked against the English source (for example, NULL handling, "exclusive" bounds, ordinal "occurrence", "Sets or unsets a setting", and literal type names that must stay in English).
  • Translate residual English: headings, table header cells, bold labels, link texts, and ordinary words left in English in the prose.

Kept in English on purpose: identifiers, SQL keywords, function and type names, UI labels, the admonition labels that the site renders, and the terms that resources/terms-en-ja.md keeps in English (stage, Warehouse, Worksheet, Schema Evolution, and so on). The "ロード (load)" gloss is kept because the glossary requires it.

Related: the glossary entry Aggregation → 集計 is removed in #24438 so that the translator can choose the term from context.

Other parts of this series: #24440, #24441, #24442

Which TiDB version(s) do your changes apply to? (Required)

Tips for choosing the affected version(s):

By default, CHOOSE MASTER ONLY so your changes will be applied to the next TiDB major or minor releases. If your PR involves a product feature behavior change or a compatibility change, CHOOSE THE AFFECTED RELEASE BRANCH(ES) AND MASTER.

For details, see tips for choosing the affected versions.

  • i18n-ja-release-8.5 (TiDB Japanese documentation for TiDB 8.5 versions)

What is the related PR or file link(s)?

AI agent involvement

  • The changes in this PR were primarily made by an AI agent on behalf of the PR author.

Do your changes match any of the following descriptions?

  • Delete files
  • Change aliases
  • Need modification after applied to another branch
  • Might cause conflicts after applied to another branch

🤖 Generated with Claude Code

Summary by CodeRabbit

  • Documentation
    • Improved Japanese translations and terminology across SQL, function, and database-management documentation.
    • Clarified descriptions for hash functions, NULL results, geometry operations, time boundaries, and file-deletion candidates without changing documented behavior.
    • Updated section links and anchors to improve navigation across the documentation.

yahonda and others added 9 commits October 13, 2026 16:13
Use one term for aggregate functions, the aggregating index, and SQL
aggregation in general, which matches other databases' Japanese docs
and the rest of the TiDB Japanese docs. Keep the other term where the
text means combining values into one array, JSON value, or geometry,
and where the English is not "aggregate".

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
…iDB Cloud Lake docs

Translate the "Step N", "Tutorial N", and "Example-N" labels left in
English in headings, using the forms that the rest of the Japanese
docs use, and unify the one file that used a different word for
"Step". Fully translate the few example headings left in English.
Translate the "Scenario:" label in the CityDrive guides. Heading
anchors are unchanged.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
…TiDB Cloud Lake docs

Translate the titles of the function category pages and the integration
task pages that were left in English, matching their sibling pages that
are already translated. Update the link texts that repeat these titles.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Translate the titles of feature overview pages whose Japanese term is
already used in the page body or in sibling pages (indexes, masking
policy, stored procedure, stream, tag, table, external function,
EXPLAIN commands, and Information_Schema tables). Keep engine and
table-format names, Full-Text Index, and Stage in English. Update the
TOC labels and link texts that repeat these titles.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
- _index.md: move the "Corresponding EN commit" comment below the front
  matter. With the comment on line 1, the front matter was not parsed
  and the page rendered it as body text with an empty title.
- Delete guides/ai-powered-features.md and guides/manage-costs.md, and
  drop the billing role section from guides/roles.md, to match the
  English docs (pingcap#24422). The translation sync does not carry over file
  deletions.
- Remove links and bold markup that were added to front matter
  summaries. Summaries are plain text.
- Restore the list markers in three notes, so that each item renders
  as a separate bullet, and move a sentence back to its original item.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
… docs

The custom anchors in the Japanese headings collapsed double hyphens
and changed underscores to hyphens (for example, create-table-like
instead of create-table--like, and record-delimiter instead of
record_delimiter). Links copied from the English docs use the English
slugs, so 38 links in the Japanese Lake docs did not resolve.

Set each custom anchor to the slug that the English heading produces,
including the -1 suffix for repeated headings. All in-page and
cross-page anchor links in the Lake docs now resolve.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Fix sentences whose Japanese meaning differs from the English, each
checked against the English source. Examples:

- NULL handling in GET, GET_PATH, GET_IGNORE_CASE,
  JSON_EXTRACT_PATH_TEXT, SHA, XXHASH32, and XXHASH64: the value is
  returned as the type, and NULL is returned only for NULL input.
- "exclusive" bounds were rendered as "mutually exclusive".
- The "occurrence" argument of REGEXP_INSTR and REGEXP_SUBSTR is an
  ordinal, not a count.
- "Sets or unsets a setting" was rendered as enable or disable.
- "surface area", "candidate", the "View" permission, the "Spec."
  (specifier) column, "data warehouse", and "extra load" were
  rendered with the wrong sense.
- A network policy limits the source IP ranges of connections, not the
  destination.
- Restore Apache Iceberg and geometry type names that must stay
  literal.
- Fix broken Japanese, stray spaces, and a doubled "see" phrase.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
…d Lake docs

Translate headings, table header cells, bold prose labels, and page
titles that were left in English, and update the link texts that
repeat them. Heading anchors are unchanged.

Keep in English: identifiers (system.* and information_schema.*
tables, option names, data type names), object and feature names
(Stage, Warehouse, Worksheets, Fail-Safe, Schema Evolution, and so on),
UI field names, data source names, and the admonition labels that the
site renders.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
…erence

Translate ordinary English words and phrases left in the prose of the
Lake SQL reference pages, such as bitmap, snapshot, timestamp,
specifier, policy, user, table, link texts that repeat translated page
titles, month and weekday names in descriptions, and the "Global"
object type value.

Keep identifiers, SQL keywords, function and type names, and terms
that the translation glossary keeps in English.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
@ti-chi-bot

ti-chi-bot Bot commented Oct 13, 2026

Copy link
Copy Markdown

Skipping CI for Draft Pull Request.
If you want CI signal for your change, please convert it to an actual PR.
You can still manually trigger a test run with /test all

@ti-chi-bot ti-chi-bot Bot added the do-not-merge/work-in-progress Indicates that a PR should not merge because it is a work in progress. label Oct 13, 2026
@coderabbitai

coderabbitai Bot commented Oct 13, 2026 •

Copy link
Copy Markdown

Review in Change Stack →

No actionable comments were generated in the recent review. 🎉

ℹ️ Recent review info
⚙️ Run configuration
  • Configuration used: Repository: pingcap/docs/.coderabbit.yaml
  • Review profile: ASSERTIVE
  • Plan: Advanced
  • Run ID: a4e78cbe-0d6d-4ccd-beab-5c0210bfd3db
📥 Commits

Reviewing files that changed from the base of the PR and between fdcf75a and d2930d7.

📒 Files selected for processing: 90
  • tidb-cloud-lake/sql/score.md
  • tidb-cloud-lake/sql/select.md
  • tidb-cloud-lake/sql/set-cache-capacity.md
  • tidb-cloud-lake/sql/set-operators-sql.md
  • tidb-cloud-lake/sql/set-role.md
  • tidb-cloud-lake/sql/set-secondary-roles.md
  • tidb-cloud-lake/sql/set-tag.md
  • tidb-cloud-lake/sql/set.md
  • tidb-cloud-lake/sql/settings-clause.md
  • tidb-cloud-lake/sql/sha.md
  • tidb-cloud-lake/sql/show-create-dictionary.md
  • tidb-cloud-lake/sql/show-dictionaries.md
  • tidb-cloud-lake/sql/show-functions.md
  • tidb-cloud-lake/sql/show-grants-sql.md
  • tidb-cloud-lake/sql/show-settings.md
  • tidb-cloud-lake/sql/show-tasks.md
  • tidb-cloud-lake/sql/show-user-functions.md
  • tidb-cloud-lake/sql/show-views.md
  • tidb-cloud-lake/sql/skewness.md
  • tidb-cloud-lake/sql/sounds-like.md
  • tidb-cloud-lake/sql/spatial-index-overview.md
  • tidb-cloud-lake/sql/sql-dialects-conformance.md
  • tidb-cloud-lake/sql/sql-function-reference.md
  • tidb-cloud-lake/sql/sql-identifiers.md
  • tidb-cloud-lake/sql/sql-statements-overview.md
  • tidb-cloud-lake/sql/sql-statements-reference.md
  • tidb-cloud-lake/sql/sql-variables.md
  • tidb-cloud-lake/sql/st-area.md
  • tidb-cloud-lake/sql/st-buffer.md
  • tidb-cloud-lake/sql/st-dimension.md
  • tidb-cloud-lake/sql/stage.md
  • tidb-cloud-lake/sql/start-five-minutes.md
  • tidb-cloud-lake/sql/stddev-pop.md
  • tidb-cloud-lake/sql/stored-procedure-scripting.md
  • tidb-cloud-lake/sql/stored-procedure.md
  • tidb-cloud-lake/sql/stream-hints.md
  • tidb-cloud-lake/sql/stream.md
  • tidb-cloud-lake/sql/string-geospatial.md
  • tidb-cloud-lake/sql/structured-semi-structured-functions.md
  • tidb-cloud-lake/sql/sub-bitmap.md
  • tidb-cloud-lake/sql/subquery-operators.md
  • tidb-cloud-lake/sql/sum-if.md
  • tidb-cloud-lake/sql/system-functions.md
  • tidb-cloud-lake/sql/system-history-log-history.md
  • tidb-cloud-lake/sql/system-query-cache.md
  • tidb-cloud-lake/sql/system-query-log.md
  • tidb-cloud-lake/sql/system-tables.md
  • tidb-cloud-lake/sql/table-functions.md
  • tidb-cloud-lake/sql/tag-overview.md
  • tidb-cloud-lake/sql/task-error-notification-payload.md
  • tidb-cloud-lake/sql/task-history.md
  • tidb-cloud-lake/sql/task.md
  • tidb-cloud-lake/sql/time-slice.md
  • tidb-cloud-lake/sql/time-slot.md
  • tidb-cloud-lake/sql/to-binary.md
  • tidb-cloud-lake/sql/to-date.md
  • tidb-cloud-lake/sql/to-geography.md
  • tidb-cloud-lake/sql/to-start-of-quarter.md
  • tidb-cloud-lake/sql/to-start-of-week.md
  • tidb-cloud-lake/sql/to-string.md
  • tidb-cloud-lake/sql/to-timestamp.md
  • tidb-cloud-lake/sql/top.md
  • tidb-cloud-lake/sql/trim.md
  • tidb-cloud-lake/sql/trunc-sql.md
  • tidb-cloud-lake/sql/try-to-timestamp.md
  • tidb-cloud-lake/sql/type-conversion-functions.md
  • tidb-cloud-lake/sql/undrop-database.md
  • tidb-cloud-lake/sql/undrop-table.md
  • tidb-cloud-lake/sql/unpivot.md
  • tidb-cloud-lake/sql/unset-variable.md
  • tidb-cloud-lake/sql/unset.md
  • tidb-cloud-lake/sql/update.md
  • tidb-cloud-lake/sql/user-role.md
  • tidb-cloud-lake/sql/uuid-functions.md
  • tidb-cloud-lake/sql/vacuum-drop-table-sql.md
  • tidb-cloud-lake/sql/vacuum-drop-table.md
  • tidb-cloud-lake/sql/vacuum-table-sql.md
  • tidb-cloud-lake/sql/vacuum-table.md
  • tidb-cloud-lake/sql/vacuum-virtual-column.md
  • tidb-cloud-lake/sql/variant.md
  • tidb-cloud-lake/sql/vector-index.md
  • tidb-cloud-lake/sql/vector.md
  • tidb-cloud-lake/sql/virtual-column-overview.md
  • tidb-cloud-lake/sql/weeks.md
  • tidb-cloud-lake/sql/window-functions-overview.md
  • tidb-cloud-lake/sql/window-funnel.md
  • tidb-cloud-lake/sql/with-consume.md
  • tidb-cloud-lake/sql/worker-overview.md
  • tidb-cloud-lake/sql/xxhash-sql.md
  • tidb-cloud-lake/sql/xxhash.md

Included review availability: This review used your included allowance. Your plan provides up to 4 included reviews per hour; 1 remain after this review.

📝 Walkthrough

This pull request updates Japanese SQL documentation across query, command, function, system, and specialized reference pages. It changes wording, headings, table labels, links, and anchors. It also clarifies several function-result descriptions. Documented SQL behavior is otherwise unchanged.

Changes: SQL query and reference pages

Layer / File(s) Summary
Query syntax and reference navigation
tidb-cloud-lake/sql/score.md, select.md, set-operators-sql.md, settings-clause.md, sql-dialects-conformance.md, sql-identifiers.md, sql-statements-overview.md, sql-statements-reference.md, sql-variables.md, subquery-operators.md, update.md
Japanese headings and labels were added or revised. Several section anchors changed, while SQL examples and descriptions remain unchanged.
Command and system reference pages
tidb-cloud-lake/sql/set*.md, show-*.md, stage.md, stored-procedure*.md, stream*.md, tag-overview.md, task*.md, system-*.md, unset*.md, user-role.md, worker-overview.md, with-consume.md, virtual-column-overview.md
Titles, descriptions, table labels, and link text were localized. Command entries, destinations, and documented behavior remain unchanged.
Function, data-type, and specialized SQL pages
tidb-cloud-lake/sql/*function*.md, sha.md, xxhash*.md, to-*.md, st-*.md, spatial-index-overview.md, vacuum-*.md, vector*.md, variant.md, window-*.md, and related pages
Japanese terminology and section labels were updated. SHA and XXHASH descriptions now state the result for NULL arguments separately. Other documented function behavior and examples are unchanged.

Priority: ➖ Normal

Estimated code review effort: 2 (Simple) | ~15 minutes

Change: Other

Merge Risk: ⚪ Minimal · up to d2930

The Japanese documentation updates preserve the checked SQL and vacuum descriptions, with no identified material user-facing regression. The PR presents minimal merge risk.

### Architecture Summary

Architecture risk: 🔵 Low · up to d2930

The change affects 1 system.

Changed systems: tidb-cloud-lake

Architecture concerns
No architecture-level concerns identified.

Review details

Systems and components

  • observed — tidb-cloud-lake (service) was modified; 90 changed files map to changed impact.

Before / after behavior

  • observed — Modified behavior in tidb-cloud-lake/sql/score.md: 概要と本文の検索方式の表現を「反転インデックス」から「転置インデックス」に変更しました。SCORE が検索条件に一致した行の関連性スコアを返し、WHERE 句で MATCH または QUERY と併用する説明は維持されています。
  • observed — Modified behavior in tidb-cloud-lake/sql/select.md: The COLUMNS heading was translated from English to Japanese; its anchor is unchanged.
  • observed — Modified behavior in tidb-cloud-lake/sql/select.md: The column-position heading was translated from English to Japanese; its anchor is unchanged.
  • observed — Modified behavior in tidb-cloud-lake/sql/select.md: The retrieving-all-columns heading was translated from English to Japanese; its anchor is unchanged.
Pre-merge checks: Passed 5
Passed Passed checks: 5 passed
Check name Status Explanation
Title check Passed The title clearly identifies the Japanese localization fixes for the TiDB Cloud Lake SQL reference, including the s-z file range and series position.
Description check Passed The description explains the scope, rationale, affected files, target version, related references, AI involvement, and applicable checklist items. The required change and version sections are complete…
Docstring Coverage Passed No functions found in the changed files to evaluate docstring coverage. Skipping docstring coverage check. Docstring coverage is scoped to functions touched by this diff. Analyzed 0 functions across 0…
Linked Issues check Passed Check skipped because no linked issues were found for this pull request.
Out of Scope Changes check Passed Check skipped because no linked issues were found for this pull request.
✨ Finishing Touches: 💡 1
🛠️ Fix failing CI checks: 💡
  • Commit to this branch
  • Create a new PR
🧪 Generate unit tests (beta)
  • Create a new PR
  • Autofix · Keep fixing CodeRabbit findings and required CI, and resolving merge conflicts

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

Comment @coderabbitai help to get the list of available commands.

@ti-chi-bot ti-chi-bot Bot added the missing-translation-status This PR does not have translation status info. label Oct 13, 2026
@ti-chi-bot ti-chi-bot Bot added the size/XL Denotes a PR that changes 500-999 lines, ignoring generated files. label Oct 13, 2026
@ti-chi-bot

ti-chi-bot Bot commented Oct 13, 2026

Copy link
Copy Markdown

[APPROVALNOTIFIER] This PR is NOT APPROVED

This pull-request has been approved by:
Once this PR has been reviewed and has the lgtm label, please assign lilin90 for approval. For more information see the Code Review Process.
Please ensure that each of them provides their approval before proceeding.

The full list of commands accepted by this bot can be found here.

Details Needs approval from an approver in each of these files:

Approvers can indicate their approval by writing /approve in a comment
Approvers can cancel approval by writing /approve cancel in a comment

yahonda and others added 3 commits October 14, 2026 10:31
Match the Bloom filter wording used in the rest of the Lake docs.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
… reference

Three terms were used for "specifier" in the date and time format pages. Use the one that the headings of the date and time page use.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
The dictionary pages used two Japanese terms for "dictionary". Use the one that the dictionary overview page and the DDL overview use. The page title and link text "Dictionary" stay in English as an object name.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
@ti-chi-bot ti-chi-bot Bot added size/XXL Denotes a PR that changes 1000+ lines, ignoring generated files. and removed size/XL Denotes a PR that changes 500-999 lines, ignoring generated files. labels Oct 14, 2026
yahonda and others added 3 commits October 14, 2026 11:37
Match the page title and the term used in the other spatial index pages. Command names stay in English.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Here "bitmap" is a data type name listed with string, variant, geometry, and geography, which stay in English.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Reword the heading so that it reads as functions dedicated to window operations, in contrast to the aggregate functions used as window functions in the next section. The anchor is unchanged.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
@yahonda
yahonda marked this pull request as ready for review October 14, 2026 02:42
@ti-chi-bot ti-chi-bot Bot removed the do-not-merge/work-in-progress Indicates that a PR should not merge because it is a work in progress. label Oct 14, 2026
@qiancai qiancai added the translation/no-need No need to translate this PR. label Oct 14, 2026
@ti-chi-bot ti-chi-bot Bot removed the missing-translation-status This PR does not have translation status info. label Oct 14, 2026
@ti-chi-bot ti-chi-bot Bot added the needs-1-more-lgtm Indicates a PR needs 1 more LGTM. label Oct 14, 2026
@ti-chi-bot

ti-chi-bot Bot commented Oct 14, 2026

Copy link
Copy Markdown

[LGTM Timeline notifier]

Timeline:

  • 2026-10-14 16:09:12.524286633 +0000 UTC m=+833762.271517472: ☑️ agreed by qiancai.

@qiancai
qiancai merged commit 7bc8361 into pingcap:i18n-ja-release-8.5 Oct 14, 2026
6 of 10 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

needs-1-more-lgtm Indicates a PR needs 1 more LGTM. size/XXL Denotes a PR that changes 1000+ lines, ignoring generated files. translation/no-need No need to translate this PR.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants