[Firebird-devel] [FB-Tracker] Created: (CORE-5780) Server hangs when client tries to send too long DB encryption key(s)

2018-03-19 Thread Alexander Peshkov (JIRA)
Server hangs when client tries to send too long DB encryption key(s) Key: CORE-5780 URL: http://tracker.firebirdsql.org/browse/CORE-5780 Project: Firebird Core Issue Type:

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Vlad Khorsun via Firebird-devel
And, probably, we should add: (3) - NOT NULL is set and default value was set before Really, why? I don't see that as a change that would affect the existing index values. The question was about existing NULL values. After i tried it i see that NOT NULL will not be set in this case: SQL>

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
> >> And, probably, we should add: > >> (3) - NOT NULL is set and default value was set before > > > > Really, why? > > > > I don't see that as a change that would affect the existing index values. > >The question was about existing NULL values. After i tried it i see that > NOT > NULL will

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Vlad Khorsun via Firebird-devel
19.03.2018 12:21, Leyne, Sean wrote: And, probably, we should add: (3) - NOT NULL is set and default value was set before Really, why? I don't see that as a change that would affect the existing index values. The question was about existing NULL values. After i tried it i see that NOT N

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
> And, probably, we should add: > (3) - NOT NULL is set and default value was set before Really, why? I don't see that as a change that would affect the existing index values. Sean -- Check out the vibrant tech comm

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Vlad Khorsun via Firebird-devel
19.03.2018 11:55, Leyne, Sean wrote: Vlad, Looking at bug CORE-5774 i found very odd behavior of engine: it seems it rebuilds indices in many unneeded cases, when almost any property of the indexed field is changed. I understand that index should be rebuild in this cases only: (1) - fi

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
Vlad, >Looking at bug CORE-5774 i found very odd behavior of engine: it seems it > rebuilds indices in many unneeded cases, when almost any property of the > indexed field is changed. > >I understand that index should be rebuild in this cases only: > (1) - field data type is changed *and*

Re: [Firebird-devel] GDS_EPOCH_START constant

2018-03-19 Thread Alex Peshkoff via Firebird-devel
On 03/18/18 23:16, Adriano dos Santos Fernandes wrote: Is this constant correct? // Number of the first day of UNIX epoch in GDS counting enum { GDS_EPOCH_START = 40617 }; I see that for date 1970-01-01, Firebird stores it as 40587. When counting days and month it's very easy to mix first day