[MDEV-22345] Document allowed values for SET data type Created: 2020-04-22 Updated: 2020-05-11 Resolved: 2020-05-11 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data types, Documentation |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Roland Illig | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | documentation | ||
| Description |
|
https://mariadb.com/kb/en/set-data-type/ says:
I tried exactly that using the following DDL:
I got this:
To avoid uncertainties like these, the valid values for a SET data type should be documented. As far as I could see in Column_definition::create_interval_from_interval_list, only the comma is an invalid character in the values of the set. It should be clearly documented that this is the only character that is not allowed and that this is the only way to avoid ambiguities in the default clause. Is that the only reason why the comma is illegal? |
| Comments |
| Comment by Roland Illig [ 2020-05-11 ] | ||||
| ||||
| Comment by Ian Gilfillan [ 2020-05-11 ] | ||||
|
Grr, thanks, fixed! |