[PR] [fix](doc) zh: unix-timestamp missing semicolon; DESC-TABLE wrong db qualifier and stale IndexKeysType [doris-website]

["boluor (via GitHub)" <gi...@apache.org>]

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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [PR] [fix](doc) zh: unix-timestamp missing semicolon; DESC-TABLE wrong db qualifier and stale IndexKeysType [doris-website]

["morningman (via GitHub)" <gi...@apache.org>]

morningman merged PR #3831:
URL: https://github.com/apache/doris-website/pull/3831


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org