[MDEV-22920] Update INVISIBLE column documentation example to be consistent Created: 2020-06-17  Updated: 2020-06-17  Resolved: 2020-06-17

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

Type: Bug Priority: Major
Reporter: Anel Husakovic Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

In the invisible column documentation, the example of creating a view is not consistent with the example before.
It should be updated to

MariaDB [test]> desc v1;
 
+-------+---------+------+-----+---------+-------+
 
| Field | Type    | Null | Key | Default | Extra |
 
+-------+---------+------+-----+---------+-------+
 
| y     | int(11) | YES  |     | NULL    |       |
 
| z     | int(11) | NO   |     | 4       |       |
 
+-------+---------+------+-----+---------+-------+
 
2 rows in set (0.001 sec)

Also here I would add as a first example case of having only 1 column as invisible where error is generated, like

MariaDB [test]> CREATE TABLE t (x INT INVISIBLE);
 
ERROR 1113 (42000): A table must have at least 1 column


Generated at Thu Feb 08 09:18:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.