boluor opened a new pull request, #3831:
URL: https://github.com/apache/doris-website/pull/3831
## Summary
Two ZH-only single-line doc bugs surfaced by the doc verifier on Doris 4.1.1:
### `unix-timestamp.md` (zh)
`select unix_timestamp('1007-11-30 10:30:19')` was missing the trailing
semicolon. The whole 举例 section is one giant `\`\`\`sql` block where statements
are separated by `;`; without the semicolon the result-table ASCII art (`+---+
| … | +---+`) gets concatenated onto the SQL and sent to the cluster, which
trips on `|` ("extraneous input"). The EN version has the semicolon.
### `DESC-TABLE.md` (zh)
Two issues in example 2:
1. The example uses `DESC demo.test_table ALL;`, but neither this page nor
its prior `CREATE TABLE` ever creates a `demo` database. The `demo.` qualifier
was a leftover stand-in and contradicts the previous example (`DESC
test_table;`). The `<db_name>.<table_name>` syntax is already documented in the
Syntax block on line 16, so dropping the qualifier doesn't lose pedagogical
value.
2. The expected-output table shows `IndexKeysType = DUP_KEYS`, but the same
page's `CREATE TABLE` uses `UNIQUE KEY(user_id)`, so the real value is
`UNIQUE_KEYS`. The `DUP_KEYS` row was stale from when the example may have used
a `DUPLICATE KEY` table.
## Verification
Verified both flows end-to-end on a fresh Doris 4.1.1 single-node cluster:
```
mysql> select unix_timestamp('1007-11-30 10:30:19');
+---------------------------------------+
| unix_timestamp('1007-11-30 10:30:19') |
+---------------------------------------+
| 0 |
+---------------------------------------+
```
```
mysql> DESC test_table ALL;
+------------+---------------+---------+-------------+--------------+------+-------+---------+-------+---------+------------+-------------+
| IndexName | IndexKeysType | Field | Type | InternalType | Null |
Key | Default | Extra | Visible | DefineExpr | WhereClause |
+------------+---------------+---------+-------------+--------------+------+-------+---------+-------+---------+------------+-------------+
| test_table | UNIQUE_KEYS | user_id | bigint | bigint | No |
true | NULL | | true | | |
| | | name | varchar(20) | varchar(20) | Yes |
false | NULL | NONE | true | | |
| | | age | int | int | Yes |
false | NULL | NONE | true | | |
+------------+---------------+---------+-------------+--------------+------+-------+---------+-------+---------+------------+-------------+
```
## Test plan
- [x] Verified `select unix_timestamp('1007-11-30 10:30:19');` returns 0 on
Doris 4.1.1
- [x] Verified `DESC test_table ALL;` on the schema defined earlier in the
page returns the corrected table contents
- [x] Both fences are unbroken markdown (no fence-parsing changes needed
beyond removing/renaming the existing content)
🤖 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]
