[MDEV-32952] Inaccurate documentation for SHOW CREATE statements Created: 2023-12-05  Updated: 2023-12-12  Resolved: 2023-12-11

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Federico Razzoli Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: docs


 Description   

Some KB pages for SHOW CREATE statements seem to me inaccurate:

https://mariadb.com/kb/en/show-create-table/
"Shows the CREATE TABLE statement that created the given table"

This is incorrect, because some details might not match: non-significant characters, comments, quotes, table options...
It is even less correct if the table was modified after creation (ALTER TABLE).

The same bug is also in the output of the HELP statements.

I think that, for each SHOW CREATE statement, the docs should say: "Shows a CREATE $what statement that can be used to recreate the $what".

 Comments   
Comment by Federico Razzoli [ 2023-12-11 ]

I think that not all SHOW CREATE statements were fixed. I checked one randomly:
https://mariadb.com/kb/en/show-create-user/

Comment by Ian Gilfillan [ 2023-12-12 ]

Thanks, these have all been done.

Generated at Thu Feb 08 10:35:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.