Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Change datatype in a Primary Key with int autoincrement to varchar | ||||||
---|---|---|---|---|---|---|---|
Product: | Base | Reporter: | Adrian Sanchez <adri09ian> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | UNCONFIRMED --- | QA Contact: | |||||
Severity: | Major | ||||||
Priority: | P5 (lowest) | ||||||
Version: | 4.1.5 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows 10 | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
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.