[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Lars Jødal  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

--- Comment #7 from Lars Jødal  ---
Update to my previous comment: The migration of both TIMESTAMP and DOUBLE works
in the daily build of 6.4.0.0.alpha0+

Furthermore, in 6.3.2.1 (RC1 version of upcoming 6.3.2), migration is suggested
only if experimental features are chosen, so (unlike 6.3.0 and 6.3.1) normal
users will not experience the bug.

Thus, the bug appears resolved.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

--- Comment #6 from Lars Jødal  ---
The small database in attachment 135786 (originally created for bug 112023) may
be used as a test case. These data were created in the CET timezone. Upon
migration, the TIMESTAMP data are moved 1 hour backwards in time.

(At the same time, migration completely corrupts the DOUBLE data in the base,
which I have further commented in bug 126268.)

These problems are still present in LO version 6.3.1.2

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 CC||l...@rn.dk

--- Comment #5 from Xisco Faulí  ---
*** Bug 126408 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

--- Comment #4 from Alex Thurgood  ---
Take a look at Lionel's opening comments in bug 67763 under "Timezone"

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=67
   ||763

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=12
   ||2863

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

--- Comment #3 from Terrence Enger  ---
Responding to comment 2 ...

If I am reading

(commit 330650c4, 2018-07-18) correctly, behaviour (2) may "just
work".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

--- Comment #2 from Terrence Enger  ---
[1] says that Firebird 4.0 Beta1 will have TIME WITH TIMEZONE and
DATETIME WITH TIMEZONE.  Firebird 4.0 is still alpha, and I have not
found a schedule for its advancement from that state.  The latest
"daily" build of 4.0, [2], was on 2018-11-25, which is earlier than
the commit in question.

I wonder whether this promise from Firebird should change our plans
with respect to this bug and bug 117732?

In the long run, I expect that we can most nearly maintain the
behaviour that users are familiar with by:
(1) Our conversion from HSQLDB converts to fields with-timezone-GMT.
(2) We translate data retrieved from the database to local time and we
convert data writtem to the database to GMT.

Do we expect to do that?  Should this change our plans with respect to
always offering the conversion from embedded HSQLDB to embedded
Firebird?

Of course, after doing (2), it will be tempting to give the user
access to additional functionality by optionally--or, optionally if
the .odb was converted from embedded HSQLDB--giving the user some
explicit access to timezone data.  I do not know what this might look
like.  Do we have anything like this in our connection to a database
already offering with-timezone?

references
--
[1]

[2] 

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #1 from Alex Thurgood  ---
Seems a fair enough request to me. Confirming.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Blocks||116968
 CC||xiscofa...@libreoffice.org


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116968
[Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 119675] Firebird: Migration: User dialog to set treatment of datetime and time values during migration

[bugzilla-daemon]

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

Drew Jensen  changed:

   What|Removed |Added

Summary|Migration Assistant: User   |Firebird: Migration: User
   |dialog to set treatment of  |dialog to set treatment of
   |datetime and time values|datetime and time values
   |during migration|during migration

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs