[Libreoffice-bugs] [Bug 117867] New: Firebird: migration: Auto Timestamp in HSQLDB not tranfered to firebird

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117867

            Bug ID: 117867
           Summary: Firebird: migration: Auto Timestamp in HSQLDB not
                    tranfered to firebird
           Product: LibreOffice
           Version: 6.1.0.0.beta1+
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rwestein at planet.nl

Description:
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.


Actual Results:  
Auto Timestamp setting in the date field is not converted to the firebird table

Expected Results:
Auto Timestamp should work in an migrated DB.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101
Firefox/60.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180529/9fb4db1b/attachment.html>