Bug #88367 timestamp(3) alter table not show

• Submitted: 6 Nov 2017 2:32
• Modified: 6 Nov 2017 6:01
• Reporter: 富 姜
• Status: Verified
• Category: MySQL Workbench
• Severity: S5 (Performance)
• Version: 6.3.9
• OS: Windows (Microsoft Windows 7 Professional Service Pack 1)
• CPU Architecture: Any
• Tags: WBBugReporter

[6 Nov 2017 2:32] 富 姜

Description:
----[For better reports, please attach the log file after submitting. You can find it in D:\Users\jiangxf\AppData\Roaming\MySQL\Workbench\log\wb.log]

nothing error in log

How to repeat:
CREATE TABLE `test_abc` (
   `id` bigint(10) NOT NULL AUTO_INCREMENT,
   `modify_time` timestamp(3) NOT NULL,
   `my_column1` int(2) NOT NULL,
   `my_column2` varchar(28) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `modify_time` (`modify_time`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

create table then use alter table ,can not show my_column1 my_column2 column.
but use select * from test_abc can show.

------------------------------------------

use right click (Alter Table ...)
---------------------------------
timestamp(3) then my_column1 my_column2 not show,
timestamp then my_column1 my_column2 can show.

[6 Nov 2017 2:35] 富 姜

snapshot

Attachment: 无标题.png (image/png, text), 24.55 KiB.

[6 Nov 2017 6:01] MySQL Verification Team

Hello!

Thank you for the report and test case.
Verified as described on Win7 with WB 6.3.9.

Thanks,
Umesh

[6 Nov 2017 6:02] MySQL Verification Team

## CLI

root@localhost [test]> CREATE TABLE `test_abc` (
    ->    `id` bigint(10) NOT NULL AUTO_INCREMENT,
    ->    `modify_time` timestamp(3) NOT NULL,
    ->    `my_column1` int(2) NOT NULL,
    ->    `my_column2` varchar(28) NOT NULL,
    ->    PRIMARY KEY (`id`),
    ->    KEY `modify_time` (`modify_time`)
    ->  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]>
root@localhost [test]> show create table `test_abc`\G
*************************** 1. row ***************************
       Table: test_abc
Create Table: CREATE TABLE `test_abc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modify_time` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `my_column1` int(2) NOT NULL,
  `my_column2` varchar(28) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `modify_time` (`modify_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.01 sec)

WB Session

Navigate to table -> Alter Table

[25 Jan 2018 10:03] MySQL Verification Team

Bug #89397 marked as duplicate of this one

[2 Feb 2018 5:34] MySQL Verification Team

Bug #89502 marked as duplicate of this

[13 Feb 2018 6:42] MySQL Verification Team

Bug #80255 marked as duplicate of this one

[13 Feb 2018 13:35] Eric Platow

this still happens in 6.3.10