Code create error

zdma's profile image zdma posted 4 years ago in General Permalink

The value (22,0) is added to the DOUBLE field definition. In MySql, the definition of DOUBLE(22,0) means that the precision of the number is limited to 0 decimal places. Meanwhile, these values are not sent to the database when a new field is added and are transferred when the field is copied by the option "Copy selected columns".

ansgar's profile image ansgar posted 4 years ago Permalink

You should update to HeidiSQL's latest build, as I recently fixed some related stuff.

zdma's profile image zdma posted 4 years ago Permalink

Thanks. Now the Boolean field default value like 'b\'0\' doesn't work. During update the name of Boolean field with default value you obtain an exception...

ansgar's profile image ansgar posted 4 years ago Permalink

Can you please post the exception's callstack here (can be stored by click on "save bugreport")

zdma's profile image zdma posted 4 years ago Permalink

ALTER TABLE app_users_views CHANGE COLUMN AUV_MAIN_VIEW AUV_MAIN_VIE BIT(1) NOT NULL DEFAULT 'b\'0\'' COMMENT 'Główny widok' AFTER AUV_GRID_SETTINGS; / Błąd SQL (1067): Invalid default value for 'AUV_MAIN_VIE' /

ansgar's profile image ansgar posted 4 years ago Permalink

I thought you meant an exception, but that's an SQL error here. However, I will have a look at that.

Please login to leave a reply, or register at first.