[Firebird-devel] Oldest transaction don't move

2015-03-14 Thread arnaud le roy
Hello, i have a strange thing with a superver 2.5.2 on windows. when i do a request on a table and after ask for db stat the Oldest transaction counter don't up i'm sure that the transcation is no longer here because 1) select count(1) from mon$transactions => 0. 2) and i don't have any attache

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-14 Thread liviuslivius
>>Karol, I also created an UDR demo for a selectable stored procedure. >>https://github.com/asfernandes/fbstuff/commit/161e1bb98f6321cff87afe24ca1050a23b8a2e10 >>You should build it and copy the pascaludr.dll file to >>/plugins/udr >>Then declare in the database: >>And use: >>select * from gen_

Re: [Firebird-devel] Time to update our headers.

2015-03-14 Thread James Starkey
Indeed. The GPL is pathological. Sun developed a fantastic file system called ZFS and released under a Sun open source license that requires, like the Firebird licenses, that modifications be available under the same license. But Linux integration would require some mods, the mods would have to

Re: [Firebird-devel] Time to update our headers.

2015-03-14 Thread Mark Rotteveel
On 13-3-2015 20:09, Jim Starkey wrote: > MPL should never be used for Firebird code. It gives specific rights to > Netscape. I have skimmed the MPL 1.0, 1.1 and 2.0 but as far as I can tell it never assigns specific rights to Netscape or Mozilla. Could you point out where it does this? > I can

Re: [Firebird-devel] Oldest transaction don't move

2015-03-14 Thread Mark Rotteveel
On 14-3-2015 08:40, arnaud le roy wrote: > Hello, > > i have a strange thing with a superver 2.5.2 on windows. > > when i do a request on a table and after ask for db stat the Oldest > transaction counter don't up i'm sure that the transcation is no longer > here because > 1) select count(1) from m

Re: [Firebird-devel] Explained plan limited size also in MON$STATEMENTS?

2015-03-14 Thread Dmitry Yemanov
14.03.2015 02:03, liviusliv...@poczta.onet.pl wrote: > > I read that to get unlimited text of explained plan i should look into > TMP$STATEMENTS > > but i got limited text in MON$EXPLAINED_PLAN in MON$STATEMENTS for some big > query > it end after 14 808 bytes as > "Select Expression > -" > n

[Firebird-devel] Retrieving plan using new mon$explained_plan field (FB3 beta )

2015-03-14 Thread Robbert-Jan
Hi, I’m trying to retrieve the explain plan of the last prepared query, using the mon$explained_plan field, introduced in FB3 beta. I used: SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id = CURRENT_TRANSACTION This seems to give me however the plan of the first prepared s

Re: [Firebird-devel] Retrieving plan using new mon$explained_plan field (FB3 beta )

2015-03-14 Thread Dmitry Yemanov
14.03.2015 15:38, Robbert-Jan wrote: > > I’m trying to retrieve the explain plan of the last prepared query, > using the mon$explained_plan field, introduced in FB3 beta. > I used: > SELECT mon$explained_plan FROM mon$statements WHERE mon$transaction_id = > CURRENT_TRANSACTION Wrong. You should us

[Firebird-devel] [FB-Tracker] Created: (CORE-4708) content of MON$EXPLAINED_PLAN in MON$STATEMENTS is limited to 14 808 bytes

2015-03-14 Thread Karol Bieniaszewski (JIRA)
content of MON$EXPLAINED_PLAN in MON$STATEMENTS is limited to 14 808 bytes -- Key: CORE-4708 URL: http://tracker.firebirdsql.org/browse/CORE-4708 Project: Firebird Core

Re: [Firebird-devel] Explained plan limited size also inMON$STATEMENTS?

2015-03-14 Thread liviuslivius
-Oryginalna wiadomość- From: Dmitry Yemanov Sent: Saturday, March 14, 2015 1:38 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] Explained plan limited size also inMON$STATEMENTS? 14.03.2015 02:03, liviusliv...@poczta.onet.pl wrote: > > I read that to get unl

Re: [Firebird-devel] Time to update our headers.

2015-03-14 Thread Ann Harrison
> On Mar 14, 2015, at 8:00 AM, Mark Rotteveel wrote: > > I have skimmed the MPL 1.0, 1.1 and 2.0 but as far as I can tell it > never assigns specific rights to Netscape or Mozilla. Could you point > out where it does this? In 1.0, the problems come in section 6. I haven't checked 1.1. V2.0

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-14 Thread Adriano dos Santos Fernandes
On 14-03-2015 06:56, liviusliv...@poczta.onet.pl wrote: > > few problems > didive library file into two files (initialization is not allowed in library > file itself - only in unit) > change PChar to PAnsiChar > and change 2 declarations of functions and implementation > function open(status: St

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-14 Thread liviuslivius
>>What Delphi version are you using? I use Delphi XE7 Ent but if you need i can test it on any (i have licenses down to Delphi 5) > and what i should do to tell Firebird to use this dll? > when i try to declare it > >>Copy the generated DLL to /plugins/udr/pascal udr.dll >>Or adapt the declaratio