Issue 127993 - Change datatype in a Primary Key with int autoincrement to varchar
Summary: Change datatype in a Primary Key with int autoincrement to varchar
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.5
Hardware: PC Windows 10
: P5 (lowest) Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-02 15:57 UTC by Adrian Sanchez
Modified: 2019-01-02 15:57 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Data with its ID corrupted. (2.35 KB, image/png)
2019-01-02 15:57 UTC, Adrian Sanchez 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Adrian Sanchez 2019-01-02 15:57:43 UTC 
Created attachment 86598 [details]
Data with its ID corrupted.

After creating a simple table as (id, nombre) being id a int with autoincrement primary key and nombre with varchar 255 as type, when we decide to change the datatype of the id for Varchar, it doesn't warn or display any errors/warnings; when we save the changes it just corrupt all the rows contained in.

In the attachment you will se data with an empty non-usable value of its primary key.