Bug #91909 Create/Modify Table: Virtual Unsigned Left Out
Submitted: 6 Aug 2018 14:01 Modified: 7 Aug 2018 2:01
Reporter: James Robinson Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.12 OS:Microsoft Windows (Windows 10)
Assigned to: CPU Architecture:x86 (Intel)
Tags: Data Type, generated column, stored column, table creation, table editor, unsigned integer, virtual column

[6 Aug 2018 14:01] James Robinson
When creating or modifying a table and adding/modifying a column that is virtual (stored or not) that is an unsigned number, the "UNSIGNED" adjective is left out of the SQL sent and creates a signed numeric column instead.

How to repeat:
Create or modify table column, and set as a signed/unsigned type (such as INT/BINGINT). Select "Generated" checkbox. Choose either virtual or stored storage type. Click apply. The resulting SQL sent to the server does not include "UNSIGNED" and will create a signed number type. The interface will deselect the "UNSIGNED" checkbox when it checks the table columns.
[7 Aug 2018 2:01] MySQL Verification Team
Thank you for the bug report.