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
• Status: Won't fix
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[1 Sep 2016 10:49] Junyi Lu

Description:
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.

http://dev.mysql.com/doc/refman/5.6/en/create-table.html 

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
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-----------------+--------------------------------------------------------------------------------------------------------------+
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”.