[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

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 managed

[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

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, it's

[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 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 recreating the

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 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 create a bug ticket.

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