View Issue Details

IDProjectCategoryView StatusLast Update
0002849SymmetricDSBugpublic2018-12-05 14:57
ReporteranouriAssigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.8.5 
Target Version3.10.0Fixed in Version 
Summary0002849: Create Table maps a column originally created as an ENUM('y','n') to a Enum(2)
Description021-data-loader-1] Running alter sql:
CREATE TABLE `data_dic`(
    `table_name` VARCHAR(40) NOT NULL,
    `field_name` VARCHAR(30) NOT NULL,
    `caption` VARCHAR(40) NULL,
    `min_size` INT DEFAULT 120,
    `field_order` SMALLINT,
    `field_type` ENUM(6) DEFAULT 'text' NULL,
    `popup_form` VARCHAR(25) NULL,
    `popup_field` VARCHAR(25) NULL,
    `check_values` VARCHAR(10) NULL,
    `combo_values` VARCHAR(150) NULL,
    `auto_inc` ENUM(2) DEFAULT 'n' NOT NULL,
    `enabled` ENUM(2) DEFAULT 'y' NULL,
    `only_select` ENUM(2) DEFAULT 'n' NOT NULL,
    `best_fit` ENUM(2) DEFAULT 'n' NOT NULL,
    `grid_sum` ENUM(5) DEFAULT 'na' NOT NULL,
    `required` ENUM(2) DEFAULT 'n' NOT NULL,
    `width` INT DEFAULT 0 NOT NULL,
    `add_date` CHAR(8) NULL,
    `visible` ENUM(2) DEFAULT 'y' NOT NULL,
    `in_table` ENUM(2) DEFAULT 'y' NOT NULL,
    `visible_pos` ENUM(2) DEFAULT 'y' NOT NULL,
    PRIMARY KEY (`table_name`, `field_name`)
);

Steps To Reproducecommand: symadmin reload node 021
mariadb 10.0
Additional InformationGetting ENUM(2) instead of enum('y','n')

Activities

hanes

2018-10-17 16:13

developer   ~0001290

Recreated in 3.9.14

Issue History

Date Modified Username Field Change
2016-10-06 08:37 anouri New Issue
2018-10-17 16:13 hanes Status new => confirmed
2018-10-17 16:13 hanes Target Version => 3.10.0
2018-10-17 16:13 hanes Summary Mysql Enum issue - Enum(2) --> enum('y','n') => Create Table maps a column originally created as an ENUM('y','n') to a Enum(2)
2018-10-17 16:13 hanes Additional Information Updated View Revisions
2018-10-17 16:13 hanes Note Added: 0001290
2018-10-29 12:52 hanes Priority high => low
2018-12-05 14:57 hanes Priority low => normal