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.