Bug 147657

Created attachment 178542 [details]
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