Bug #82836 Supported bool/boolean type not mentioned in "CREATE TABLE SYNTAX" section
Submitted: 1 Sep 2016 10:49 Modified: 18 Oct 2016 13:16
Reporter: Junyi Lu Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[1 Sep 2016 10:49] Junyi Lu
MySQL does support bool as a column type when creating table. However there's no relevant information about that in the CREATE TABLE SYNTAX section.


How to repeat:
mysql> create table table_with_bool ( bool_col bool );

Query OK, 0 rows affected (1.21 sec)

mysql> show create table table_with_bool;
| Table           | Create Table                                                                                                 |
| table_with_bool | CREATE TABLE `table_with_bool` (
  `bool_col` tinyint(1) DEFAULT NULL
1 row in set (0.11 sec)

Suggested fix:
Add the missing introduction about bool type
[5 Sep 2016 18:24] MySQL Verification Team
Thank you for the bug report.
[18 Oct 2016 13:16] Paul DuBois
You're correct, but this is deliberate. As the section in question says:

Data Types and Attributes for Columns

data_type represents the data type in a column definition. spatial_type represents a spatial data type. The data type syntax shown is representative only. For a full description of the syntax available for specifying column data types, as well as information about the properties of each type, see Chapter 11, Data Types, and Section 11.5, “Extensions for Spatial Data”.