Re: [Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Thomas Beckmann
Hi Adriano, with my latest snapshot 3.0-server, I've been able to compile the procedure, though. I don't mind if this is the bug, but as Dimitri stated, it would be weird if the behavior of packaged and non-packaged procedures would be different. So, you get the error with the standalone procedure

Re: [Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Adriano dos Santos Fernandes
On 09-07-2013 15:09, Adriano dos Santos Fernandes wrote: > On 09-07-2013 14:31, Thomas Beckmann wrote: >> Ok, Dimitri, >> >> I'm sorry for this quite unhandy example - but it does what it's >> supposed to do... >> > > The standalone procedure is raising the same "sort record size". > Please creat

Re: [Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Adriano dos Santos Fernandes
On 09-07-2013 14:31, Thomas Beckmann wrote: > Ok, Dimitri, > > I'm sorry for this quite unhandy example - but it does what it's > supposed to do... > The standalone procedure is raising the same "sort record size". Please create a bug ticket. Adriano --

Re: [Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Thomas Beckmann
Ok, Dimitri, I'm sorry for this quite unhandy example - but it does what it's supposed to do... Regards, Thomas >> I get this error >> >> Statement failed, SQLSTATE = 2F000 >> sort record size of 187704 bytes is too big >> -Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR >> >> on recrea

[Firebird-devel] [FB-Tracker] Created: (CORE-4142) Server crashes while preparing a query with DISTINCT and ORDER BY

2013-07-09 Thread Dmitry Yemanov (JIRA)
Server crashes while preparing a query with DISTINCT and ORDER BY - Key: CORE-4142 URL: http://tracker.firebirdsql.org/browse/CORE-4142 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Dmitry Yemanov
09.07.2013 18:35, Thomas Beckmann wrote: > > I get this error > > Statement failed, SQLSTATE = 2F000 > sort record size of 187704 bytes is too big > -Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR > > on recreating the package body. It has nothing to do with the package/procedure size,

[Firebird-devel] Procedure size in package limited?

2013-07-09 Thread Thomas Beckmann
I get this error Statement failed, SQLSTATE = 2F000 sort record size of 187704 bytes is too big -Error while parsing procedure PKG$.P_SOMEPROCEDURE's BLR on recreating the package body. Creating the procedure outside a package works fine. Is this an error or am I exceeding package size in addin

Re: [Firebird-devel] FB30: What is table SEC$USERS for?

2013-07-09 Thread Thomas Beckmann
>> I'm still struggling with getting my user priviledges set up the proper >> way in FB3.0, and stumbled across table SEC$USERS - can someone give me >> a hint what this is for or where I can find some informations about it? > > It's a virtual (read-only) table that shows users allowed to be mana

Re: [Firebird-devel] FB30: What is table SEC$USERS for?

2013-07-09 Thread Dmitry Yemanov
09.07.2013 12:27, Thomas Beckmann wrote: > I'm still struggling with getting my user priviledges set up the proper > way in FB3.0, and stumbled across table SEC$USERS - can someone give me > a hint what this is for or where I can find some informations about it? It's a virtual (read-only) table t

[Firebird-devel] FB30: What is table SEC$USERS for?

2013-07-09 Thread Thomas Beckmann
I'm still struggling with getting my user priviledges set up the proper way in FB3.0, and stumbled across table SEC$USERS - can someone give me a hint what this is for or where I can find some informations about it? Thank you! Regards, Thomas -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-