If in a HSQLDB table a date field is defined to have an auto Timestamp when new record is created (created by alter table "Table1" alter COLUMN "Date" TIMESTAMP default now) this will not be transferred to the firebird DB
Steps to Reproduce:
1. Create a table in HSQLDB add date field
2. set 'alter table "Table1" alter COLUMN "Date" TIMESTAMP default now' to the date field.
3. Create a new record the date should be filled automatically
4. run the migration assistant.
5. create a new record in the migrated db.
Auto Timestamp setting in the date field is not converted to the firebird table
Auto Timestamp should work in an migrated DB.
User Profile Reset: No
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0
Created attachment 142367 [details]
HSQLDB with table and auto-timestamp-field
Could confirm the buggy behavior. Added an attachment which has a table and default for the timestamp set to NOW.
CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-05-23_22:35:09
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
I tried to mimic https://cgit.freedesktop.org/libreoffice/core/commit/?id=b18953565b68e46289ad85927d79f5978a51078b but I don't understand the difference between:
(In reply to Julien Nabet from comment #2)
> I tried to mimic
> ?id=b18953565b68e46289ad85927d79f5978a51078b but I don't understand the
> difference between:
> - dbaccess/source/filter/hsqldb/fbcreateparser.cxx
> - dbaccess/source/filter/hsqldb/parseschema.cxx
> - dbaccess/source/filter/hsqldb/createparser.cxx
The last one isn't in the patch but allows to parse hsqldb too.
In HSQLDB I get 29.05.18 07:49 while in Firebird i get 29.05.18 05:49, which is the UTC time
Tamas Bunth committed a patch related to this issue.
It has been pushed to "master":
tdf#117867 dbahsql: Migrate default values
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.