Re: [Firebird-devel] Usage of 2020-01-01 as date for some of the time with time zone conversions

2020-05-18 Thread Tony Whyman
I have also been having problems with the use of the TIME WITH TIME ZONE type and have been holding back on posting on the issue until I came up with a suitable proposal. I wrote down my thoughts on the issue a few weeks ago and have appended them to the end of this EMail - at the time of writi

[Firebird-devel] Varchar enforcing size limits when there are trailing spaces in MBCS

2020-05-18 Thread Ariel Álvarez
Hello, I have made small changes to jrt\cvt.cpp and common\cvt.cpp to correct the behavior of varchars not enforcing size limits when there are trailing spaces in the string and uses UTF-8 in FB 3.0 and 4.0. I would be very happy to share the changes if someone can take a look. It behaves correc

[Firebird-devel] [FB-Tracker] Created: (CORE-6309) fbsvcmgr can not decode information buffer returned by gfix list limbo service

2020-05-18 Thread Alexander Peshkov (JIRA)
fbsvcmgr can not decode information buffer returned by gfix list limbo service -- Key: CORE-6309 URL: http://tracker.firebirdsql.org/browse/CORE-6309 Project: Firebird Core

Re: [Firebird-devel] Usage of 2020-01-01 as date for some of the time with time zone conversions

2020-05-18 Thread Alex Peshkoff via Firebird-devel
On 2020-05-18 13:31, Adriano dos Santos Fernandes wrote: Do you have an alternative (that do not broke things), better than use fixed date (as Oracle does with 0001-01-01 and it even more broke behavior) or a recent date? Telling true I have bug desire to answer that error 'Invalid operation' s

Re: [Firebird-devel] Usage of 2020-01-01 as date for some of the time with time zone conversions

2020-05-18 Thread Adriano dos Santos Fernandes
On 18/05/2020 04:00, Alex Peshkoff via Firebird-devel wrote: > On 2020-05-16 05:22, Adriano dos Santos Fernandes wrote: >> On 15/05/2020 12:46, Mark Rotteveel wrote: >>> The decision to use 2020-01-01 as date for some of the time with time >>> zone conversion leads to, in my opinion, confusing beha

Re: [Firebird-devel] Usage of 2020-01-01 as date for some of the time with time zone conversions

2020-05-18 Thread Alex Peshkoff via Firebird-devel
On 2020-05-16 05:22, Adriano dos Santos Fernandes wrote: On 15/05/2020 12:46, Mark Rotteveel wrote: The decision to use 2020-01-01 as date for some of the time with time zone conversion leads to, in my opinion, confusing behaviour: select   time'13:25:32.1235 Europe/Amsterdam' at time zone 'ut