Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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 |