Summary: | Field length changes unintentionally when defining a composite key made of multiple non-consecutive fields | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | algonzal |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | minor | CC: | j.lopes.teixeira, robert |
Priority: | medium | ||
Version: | 6.4.6.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Short demo showing the bug |
Description
algonzal
2020-11-15 16:22:27 UTC
Created attachment 167313 [details]
Short demo showing the bug
Have tested this one with internal HSQLDB and LO 7.0.3.1 on OpenSUSE 15.1 64bit rpm Linux. Could confirm the buggy behavior. The GUI will set the value for length from the last field of the chosen primary key fields. So if you want to get the right length you have to set the VARCHAR-field as last field in this group or you have to change the length after saving the table. Could be this is a bug inherited from OOo … |