boluor opened a new pull request, #3875: URL: https://github.com/apache/doris-website/pull/3875
The `PERIOD_ADD`, `PERIOD_DIFF` and `TIME_FORMAT` pages each show a `SELECT ... FROM <table>` example with an expected result, but never define the table on the page. As written these examples cannot be run or reproduced — a reader who copies them gets `Table [...] does not exist`. This PR adds the missing `CREATE TABLE` + `INSERT` for each table, carried in a standard HTML comment (`<!-- setup-sql ... -->`) just before the example. Because it is an HTML comment, **the rendered page is unchanged** and **no documented expected output is modified**. Table contents were reverse-derived from the output already printed on each page and verified end-to-end on the matching cluster for each doc tree. ### Pages and tables | Function | Table(s) | | --- | --- | | `PERIOD_ADD` | `test_period_add` | | `PERIOD_DIFF` | `test_period_diff` | | `TIME_FORMAT` | `test_time_format`, `test_format` | These pages exist only in the dev/`current` and `version-4.x` trees; updated in EN + ZH (12 files). Verified on a 4.1.1 cluster (4.x) and a master build (dev): the affected examples failed with "table does not exist" before this change and pass (output matches the doc, including the full TIME_FORMAT specifier table) after it. No `ja-source` changes. 🤖 Generated with [Claude Code](https://claude.com/claude-code) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
