Bug #35796 SHOW CREATE TABLE and default value for BIT field

• Submitted: 3 Apr 2008 12:18
• Modified: 28 Jan 2009 22:00
• Reporter: Marc Delisle
• Status: Closed
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.1.22, 5.1.23
• OS: Any
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[3 Apr 2008 12:18] Marc Delisle

Description:
A default value for BIT field should be displayed using a bit-field value
(http://dev.mysql.com/doc/refman/5.1/en/bit-field-values.html) instead of a non-printable value.

How to repeat:
CREATE TABLE IF NOT EXISTS `bit` (
`bit-2` bit(2) NOT NULL default b'1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

SHOW CREATE TABLE `bit`;

[3 Apr 2008 13:28] Valeriy Kravchuk

Thank you for a problem report.

[24 Nov 2008 12:31] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/59671

2722 Sergey Glukhov	2008-11-24
      Bug#35796 SHOW CREATE TABLE and default value for BIT field
      show default value for BIT field in printable format

[24 Nov 2008 12:39] Alexander Barkov

The patch http://lists.mysql.com/commits/59671 looks ok to push.

[9 Dec 2008 9:54] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/61016

2737 Sergey Glukhov	2008-12-09
      Bug#35796 SHOW CREATE TABLE and default value for BIT field
      show default value for BIT field in printable format

[6 Jan 2009 13:57] Bugs System

Pushed into 5.0.76 (revid:[e-mail]-20090105160414-8q9j4bi1klkfwiup) (version source revid:[e-mail]-20081230114734-nmsc37ak330zlygn) (merge vers: 5.0.76) (pib:6)

[9 Jan 2009 0:55] Paul DuBois

Noted in 5.0.76 changelog.

SHOW CREATE TABLE did not display a printable value for the default
value of BIT columns.

Setting report to NDI pending push into 5.1.x/6.0.x.

[15 Jan 2009 6:38] Bugs System

Pushed into 5.1.31 (revid:[e-mail]-20090115053147-tx1oapthnzgvs1ro) (version source revid:[e-mail]-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)

[15 Jan 2009 16:23] Paul DuBois

Noted in 5.1.31 changelog.

Setting report to NDI pending push into 6.0.x.

[19 Jan 2009 11:32] Bugs System

Pushed into 5.1.31-ndb-6.2.17 (revid:[e-mail]-20090119095303-uwwvxiibtr38djii) (version source revid:[e-mail]-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)

[19 Jan 2009 13:09] Bugs System

Pushed into 5.1.31-ndb-6.3.21 (revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (version source revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)

[19 Jan 2009 14:49] Jon Stephens

Setting status back to NDI pending merge to 6.0 tree.

[19 Jan 2009 16:15] Bugs System

Pushed into 5.1.31-ndb-6.4.1 (revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (version source revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)

[20 Jan 2009 19:00] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090119171328-2hemf2ndc1dxl0et) (version source revid:[e-mail]-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)

[28 Jan 2009 22:00] Paul DuBois

Noted in 6.0.10 changelog.