https://bugs.documentfoundation.org/show_bug.cgi?id=147657
Bug ID: 147657
Summary: Wrong behavior of the default value in a date field
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 178542
--> https://bugs.documentfoundation.org/attachment.cgi?id=178542&action=edit
Firebird embedded test database
In the table designer, when you create a date field and assign it a default
value, the assigned value is modified depending on the actions you do in the
designer. For example, if you select another field and return again to the date
field, the value assigned by default has been modified, it is also modified if
you save the table but do not close the table designer and also when you close
the designer.
In addition, the value that is inserted in the table when adding a record is
*completely different* from the value that remained in the designer when it was
closed.
Steps to reproduce:
1. Create or open a database
2. Create a new table
3. In the new table, create a field called ID, type INTEGER and AutoValue
(primary key).
4. Create a new field called e.g. Fecha of type DATE and set a default
date, for example 01/01/2022. Change the format fiel to date DD/MM/AAAA
5. Select the ID field
6. Select the Date field again, the default date will have changed to
03/01/2021 (or another value different from the original one).
7. Click on the Save icon, the date in the default value field will change
again with each click.
8. Save the table and assign a name to it, close the designer and open the
table to enter data.
9. Insert a record to see the date that is assigned by default, it will be
a completely different date from the one assigned by default in the table
designer (in my case, the last value in the designer was 09/01/2021 and the
date assigned by default was 02/01/0009).
Expected:
1. That the default date value is not modified whatever action is done in
the table designer.
2. That once the table is designed, when inserting records, the default
value assigned when designing the table is automatically entered in the date
field.
Tested with:
- Firebird embedded
- HSQLDB embedded
- MariaDB 10.6 Direct connection
on :Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
And tested with:
-HSQLDB emnbedded
on:
Version: 7.1.7.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.1.7-0ubuntu0.21.04.1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
