[Firebird-devel] [FB-Tracker] Created: (CORE-5451) New database trigger "before Statement"

2017-01-12 Thread Holger Klemt (JIRA)
New database trigger "before Statement" - Key: CORE-5451 URL: http://tracker.firebirdsql.org/browse/CORE-5451 Project: Firebird Core Issue Type: Improvement Components: Engine Affects V

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Leyne, Sean
> As far as I understand it is specifically for backwards compatibility (eg > tools > that expect/depend on the max 31 characters **and** max 31 > bytes) limit OK, that's a reasonable answer. But does that mean that it needs to be configurable? It would seem that the better answer would be "D

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
12.01.2017 18:00, Mark Rotteveel wrote: > > As far as I understand it is specifically for backwards compatibility > (eg tools that expect/depend on the max 31 characters **and** max 31 > bytes) limit Then IMO it should be a boolean, not a numeric limit. Dmitry -

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
12.01.2017 17:33, Leyne, Sean wrote: > > Why is a configuration setting for this required? > > This seems like a fix/complication for a problem that doesn't really exist. That was my opinion too. Dmitry -- Developer Ac

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 12-1-2017 15:57, Jiří Činčura wrote: >> Maximum is 63 characters. IIRC, configuration allows to lower this limit. > > What would be the scenario for lowering this limit? Does it make sense > to have configurable? > As far as I understand it is specifically for backwards compatibility (eg tools

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Jiří Činčura
> Maximum is 63 characters. IIRC, configuration allows to lower this limit. What would be the scenario for lowering this limit? Does it make sense to have configurable? -- Mgr. Jiří Činčura Independent IT Specialist --

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Leyne, Sean
> > Is there a maximum length, or can I theoretically use a length of say > > 8191 characters for an identifier? > > Maximum is 63 characters. IIRC, configuration allows to lower this limit. Why is a configuration setting for this required? This seems like a fix/complication for a problem that

Re: [Firebird-devel] Maybe is time for full ICU set in installer for national collations ?

2017-01-12 Thread Mark Rotteveel
On 14-12-2016 10:11, marius adrian popa wrote: > http://stackoverflow.com/questions/41120437/firebird-2-5-6-romanian-collation-for-utf8-charset > > > -- > Check out the vibrant tech community on one of the world's most > en

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 12-1-2017 13:38, Dmitry Yemanov wrote: > 06.01.2017 17:53, Mark Rotteveel wrote: > >> I just noticed that in Firebird 4 the identifier length limits are >> configurable. >> >> Is there a maximum length, or can I theoretically use a length of say >> 8191 characters for an identifier? > > Maximum

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dmitry Yemanov
06.01.2017 17:53, Mark Rotteveel wrote: > I just noticed that in Firebird 4 the identifier length limits are > configurable. > > Is there a maximum length, or can I theoretically use a length of say > 8191 characters for an identifier? Maximum is 63 characters. IIRC, configuration allows to lower

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Dimitry Sibiryakov
12.01.2017 13:27, Mark Rotteveel wrote: >> I just noticed that in Firebird 4 the identifier length limits are >> configurable. >> >> Is there a maximum length, or can I theoretically use a length of say >> 8191 characters for an identifier? >> >> Is there a quick and easy way to determine the maxim

Re: [Firebird-devel] Firebird 4 identifier limits

2017-01-12 Thread Mark Rotteveel
On 6-1-2017 15:53, Mark Rotteveel wrote: > I just noticed that in Firebird 4 the identifier length limits are > configurable. > > Is there a maximum length, or can I theoretically use a length of say > 8191 characters for an identifier? > > Is there a quick and easy way to determine the maximum ide

Re: [Firebird-devel] SQL:2016 was released a month ago

2017-01-12 Thread Roman Simakov
Anybody have a recent draft? :) 2017-01-12 14:54 GMT+03:00 marius adrian popa : > SQL:2016 was released a month ago: > http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63556 > New: - Row pattern matching - JSON - polymorphic table functions - > CAST(FORMAT) > >

[Firebird-devel] SQL:2016 was released a month ago

2017-01-12 Thread marius adrian popa
SQL:2016 was released a month ago: http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=63556 New: - Row pattern matching - JSON - polymorphic table functions - CAST(FORMAT) --

Re: [Firebird-devel] op_exit/op_disconnect in aux connection

2017-01-12 Thread Jiří Činčura
>interface.cpp - is a client code. Server code is at >remote/server/server.cpp > Look at rem_port::disconnect and take into account this comment > > // For WNET and XNET we should send dummy op_disconnect packet > // to wakeup async port handling events on client side. >

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Vlad Khorsun
12.01.2017 12:10, Alex Peshkoff wrote: > On 01/12/17 13:00, Vlad Khorsun wrote: >> 12.01.2017 10:24, Alex Peshkoff wrote: >>> On 01/11/17 23:35, Vlad Khorsun wrote: >>> >> I do it easily. AST thread is blocked at >> Database::Sync::lock on syncMutex.enter() despite of a lot of checkouts >>

Re: [Firebird-devel] op_exit/op_disconnect in aux connection

2017-01-12 Thread Vlad Khorsun
12.01.2017 12:25, Jiří Činčura пишет: > Hi *, > > I'm looking at > https://github.com/FirebirdSQL/firebird/blob/master/src/remote/client/interface.cpp#L6007 > and wondering whether the server can ever send op_exit/op_disconnect on > aux connection? Is that possible? And I can somehow do it (for tes

[Firebird-devel] op_exit/op_disconnect in aux connection

2017-01-12 Thread Jiří Činčura
Hi *, I'm looking at https://github.com/FirebirdSQL/firebird/blob/master/src/remote/client/interface.cpp#L6007 and wondering whether the server can ever send op_exit/op_disconnect on aux connection? Is that possible? And I can somehow do it (for testing)? -- Mgr. Jiří Činčura Independent IT Spec

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Alex Peshkoff
On 01/12/17 13:00, Vlad Khorsun wrote: > 12.01.2017 10:24, Alex Peshkoff wrote: >> On 01/11/17 23:35, Vlad Khorsun wrote: >> > I do it easily. AST thread is blocked at > Database::Sync::lock on syncMutex.enter() despite of a lot of checkouts > in worker > thread. Hmm... From p

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Vlad Khorsun
12.01.2017 10:24, Alex Peshkoff wrote: > On 01/11/17 23:35, Vlad Khorsun wrote: > I do it easily. AST thread is blocked at Database::Sync::lock on syncMutex.enter() despite of a lot of checkouts in worker thread. >>> Hmm... From posix POV that's a bug but certainly windows call

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Alex Peshkoff
On 01/11/17 23:35, Vlad Khorsun wrote: >>> I do it easily. AST thread is blocked at >>> Database::Sync::lock on syncMutex.enter() despite of a lot of checkouts in >>> worker >>> thread. >> Hmm... From posix POV that's a bug but certainly windows calls may have >> different rules. May be it makes