Bug #8485 BOOLEAN: Silent data type change to TINYINT

Description:
MySQL should never change the data type of a column.
But in the case of BOOLEAN column definitions, the server
changes the data type to TINYINT.

How to repeat:
mysql> create table t1 (col1 boolean);
Query OK, 0 rows affected (0.00 sec)

mysql> show create table t1;
+-------+---------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                |
+-------+---------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `col1` tinyint(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+---------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
-- This is incorrect. The data type chosen for the column was
BOOLEAN and this should be reflected in the SHOW statement.

Thank you for the bug report.

No reason to keep this not fixed.

Bug #22361 and bug #45181 are duplicates of this bug here.

Bug #46734 is set as duplicate of this bug here

Bug #38154 is depending on this bug here.

Bug #51491 is a duplicate of this bug here.

quote "Severity:	S3 (Non-critical)"

actually it is very critical

for adaptation of mysql as a replacement for 

ms access and any other database for vb

Implementation of this feature would be highly desirable to improve interoperability with third-party tools as well as to make a true Boolean data type available to application programmers (reducing the need for cast operations in applications).

If native implementation is taking too much effort, an implementation using a "wrapper" data type (wrapping and restricting the actual storage data type TINYINT to (optionally) change its external visibility to BOOLEAN) would probably be sufficient to start with.

Once a SQL99 compliant BOOLEAN gets implemented please als oconsider http://bugs.mysql.com/bug.php?id=63583

Still in 8.0.3.