| Bug #8485 | BOOLEAN: Silent data type change to TINYINT | ||
|---|---|---|---|
| Submitted: | 13 Feb 2005 1:40 | Modified: | 29 Sep 2008 23:29 |
| Reporter: | Trudy Pelzer | ||
| Status: | Verified | ||
| Category: | Server: Types | Severity: | S3 (Non-critical) |
| Version: | 5.0.3-alpha-debug | OS: | Linux (SuSE 9.1) |
| Assigned to: | Evgeny Potemkin | Target Version: | |
| Triage: | Triaged: D5 (Feature request) | ||
[13 Feb 2005 3:12]
Miguel Solorzano
Thank you for the bug report.
[29 Sep 2008 23:29]
Konstantin Osipov
No reason to keep this not fixed.
[10 Jun 13:23]
Susanne Ebrecht
Bug #22361 and bug #45181 are duplicates of this bug here.
[17 Aug 5:01]
Susanne Ebrecht
Bug #46734 is set as duplicate of this bug here
[19 Oct 12:44]
Susanne Ebrecht
Bug #38154 is depending on this bug here.
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.