You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2019/01/02 15:57:43 UTC
[Issue 127993] New: Change datatype in a Primary Key with int
autoincrement to varchar
https://bz.apache.org/ooo/show_bug.cgi?id=127993
Issue ID: 127993
Issue Type: DEFECT
Summary: Change datatype in a Primary Key with int
autoincrement to varchar
Product: Base
Version: 4.1.5
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: code
Assignee: issues@openoffice.apache.org
Reporter: adri09ian@gmail.com
Target Milestone: ---
Created attachment 86598
--> https://bz.apache.org/ooo/attachment.cgi?id=86598&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the issue.