[Firebird-devel] [FB-Tracker] Created: (CORE-3429) Part of gbak messages from services is lost before error message

2011-04-04 Thread Yurij (JIRA)
Part of gbak messages from services is lost before error message - Key: CORE-3429 URL: http://tracker.firebirdsql.org/browse/CORE-3429 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] Crash in boot build, VC9

2011-04-04 Thread Claudio Valderrama C.
> Claudio, please try this patch. It should fix this bug. > And can you please also provide full stacktrace for this case? For me > cleanup member was never left uninitialized cause all modules > were doing > setCleanup(). I wonder what module caused this. Ok, here's the full call stack: >

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Frank Schlottmann-Goedde
On 04.04.2011 12:45, Thomas Steinmaurer wrote: > Vlad, >> >> First, try to insert 1mln *random* INTs, i.e. not in sequential order. >> Else you compare apples (sequential numbers) with oranges (random numbers) :) > > Good one. This makes a difference. Will put that in a list for a > possible

Re: [Firebird-devel] FB3. CREATE OR ALTER TRIGGER

2011-04-04 Thread Dmitry Yemanov
04.04.2011 21:05, Adriano dos Santos Fernandes wrote: > It's *CREATE OR* ALTER, and it's a DML trigger, so the table name is > required. But the error message sounds misleading. In fact, the *type* of the trigger hasn't been changed. Dmitry

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Frank Schlottmann-Gödde
On 04.04.2011 12:45, Thomas Steinmaurer wrote: > Vlad, >> >> First, try to insert 1mln *random* INTs, i.e. not in sequential order. >> Else you compare apples (sequential numbers) with oranges (random numbers) :) > > Good one. This makes a difference. Will put that in a list for a > possible

Re: [Firebird-devel] FB3. CREATE OR ALTER TRIGGER

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 13:37, Kovalenko Dmitry wrote: > Hi > > SQL Script > > set transaction; > create table TEST_36187 (ID INTEGER); > create trigger BI_TEST_36187 for TEST_36187 before insert as declare > variable x integer; begin select count(*) from TEST_36187 into :x; end; > CREATE OR ALTER trigge

[Firebird-devel] FB3. CREATE OR ALTER TRIGGER

2011-04-04 Thread Kovalenko Dmitry
Hi SQL Script set transaction; create table TEST_36187 (ID INTEGER); create trigger BI_TEST_36187 for TEST_36187 before insert as declare variable x integer; begin select count(*) from TEST_36187 into :x; end; CREATE OR ALTER trigger BI_TEST_36187 active after insert position 1 as declare varia

[Firebird-devel] [FB-Tracker] Created: (CORE-3428) Alter column size not possible when column used in Constraint

2011-04-04 Thread sqldba (JIRA)
Alter column size not possible when column used in Constraint - Key: CORE-3428 URL: http://tracker.firebirdsql.org/browse/CORE-3428 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] SF.net SVN: firebird:[52620] firebird/trunk/src

2011-04-04 Thread Alex Peshkoff
On 04/04/11 18:12, Adriano dos Santos Fernandes wrote: > On 04-04-2011 10:10, Alex Peshkoff wrote: >> On 04/04/11 16:40, Adriano dos Santos Fernandes wrote: >>> On 04-04-2011 09:20, Alex Peshkoff wrote: What about always start functions with status parameter - I do not agree, because it

Re: [Firebird-devel] SF.net SVN: firebird:[52620] firebird/trunk/src

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 10:10, Alex Peshkoff wrote: > On 04/04/11 16:40, Adriano dos Santos Fernandes wrote: >> On 04-04-2011 09:20, Alex Peshkoff wrote: >>> What about always start functions with status parameter - I do not >>> agree, because it's not required for upgradeInterface(). >>> >> It's required f

Re: [Firebird-devel] SF.net SVN: firebird:[52620] firebird/trunk/src

2011-04-04 Thread Alex Peshkoff
On 04/04/11 16:40, Adriano dos Santos Fernandes wrote: > On 04-04-2011 09:20, Alex Peshkoff wrote: >> What about always start functions with status parameter - I do not >> agree, because it's not required for upgradeInterface(). >> > It's required for correct usage of things by user. Errors must b

Re: [Firebird-devel] Reference counters in API

2011-04-04 Thread Dimitry Sibiryakov
04.04.2011 14:58, Adriano dos Santos Fernandes wrote: > Let's stop to waste our time. > > I'll never agree with your used approach to fix *real user mistakes* > adding methods to our API, nor even seems to be enough interested > persons to make things better. > > In the end, the community has what

Re: [Firebird-devel] Reference counters in API

2011-04-04 Thread Adriano dos Santos Fernandes
Alex, Let's stop to waste our time. I'll never agree with your used approach to fix *real user mistakes* adding methods to our API, nor even seems to be enough interested persons to make things better. In the end, the community has what it deserves in the final product, and developers will need

Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, "SET TRANSACTION"

2011-04-04 Thread Kovalenko Dmitry
> Fixed. Thanks. Please, append in source code the comment for this fix. Because in each new version (begin from 2.0) this feature is broken :) Regards, Dmitry Kovalenko. -- Create and publish websites with WebMatrix U

Re: [Firebird-devel] Reference counters in API

2011-04-04 Thread Alex Peshkoff
On 04/02/11 01:34, Adriano dos Santos Fernandes wrote: > On 01-04-2011 07:14, Alex Peshkoff wrote: >> On 03/31/11 19:13, Adriano dos Santos Fernandes wrote: >>> On 31-03-2011 07:49, Alex Peshkoff wrote: >>> > People would like to detach a parent and not care about statements > created but

Re: [Firebird-devel] isc_dsql_prepare, NULL tr_handle, "SET TRANSACTION"

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 08:34, Kovalenko Dmitry wrote: > Hi > > [04.04.2011 15:03:45] [info] Server Name :Firebird > [04.04.2011 15:03:45] [info] Server Version :3.0.0.29259 > [04.04.2011 15:03:45] [info] Client Name :Firebird SQL Server > [04.04.2011 15:03:45] [info] Client Version :3.0.0.29259 > > The la

Re: [Firebird-devel] SF.net SVN: firebird:[52620] firebird/trunk/src

2011-04-04 Thread Adriano dos Santos Fernandes
On 04-04-2011 09:20, Alex Peshkoff wrote: > > What about always start functions with status parameter - I do not > agree, because it's not required for upgradeInterface(). > It's required for correct usage of things by user. Errors must be reported consistently, with the status parameter. Suppos

Re: [Firebird-devel] SF.net SVN: firebird:[52620] firebird/trunk/src

2011-04-04 Thread Alex Peshkoff
On 04/01/11 19:01, Adriano dos Santos Fernandes wrote: > On 01-04-2011 07:22, Alex Peshkoff wrote: >> On 04/01/11 06:53, Adriano dos Santos Fernandes wrote: >>> On 31-03-2011 10:44, alexpeshk...@users.sourceforge.net wrote: Revision: 52620 http://firebird.svn.sourceforge.net/f

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Geoff Worboys
Hi Thomas, >> Please benchmark ... Just a quick thought... You could try benching marking what it takes to save the UUID as a CHAR(32) ASCII field. It may help to narrow the field a little bit. -- Geoff Worboys Telesis Computing --

[Firebird-devel] isc_dsql_prepare, NULL tr_handle, "SET TRANSACTION"

2011-04-04 Thread Kovalenko Dmitry
Hi [04.04.2011 15:03:45] [info] Server Name :Firebird [04.04.2011 15:03:45] [info] Server Version :3.0.0.29259 [04.04.2011 15:03:45] [info] Client Name :Firebird SQL Server [04.04.2011 15:03:45] [info] Client Version :3.0.0.29259 The latest build of Firebird 3 can't prepare "SET TRANSACTION" (thr

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Thomas Steinmaurer
Vlad, >>> Currently, I re-run the test case mentioned in my initial email. Still >>> running. I then will also run a test case where inserting GUIDs into a >>> non-indexed column will happen. Perhaps adjusting the index tree for >>> GUIDs is slow. >> >> Inserting into a table with a GUID column as

[Firebird-devel] [FB-Tracker] Created: (CORE-3427) Server crashing with UTF8 blobs

2011-04-04 Thread ceeam (JIRA)
Server crashing with UTF8 blobs --- Key: CORE-3427 URL: http://tracker.firebirdsql.org/browse/CORE-3427 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation, Engine Affects Versions:

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Vlad Khorsun
>> Currently, I re-run the test case mentioned in my initial email. Still >> running. I then will also run a test case where inserting GUIDs into a >> non-indexed column will happen. Perhaps adjusting the index tree for >> GUIDs is slow. > > Inserting into a table with a GUID column as primary key

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Thomas Steinmaurer
>>> any ideas why inserting 1 million records with a GUID primary key using >>> the built-in GEN_UUID() function takes WAY longer than with an integer >>> primary key. My finding: >>> >>> I ran a VERY simple test case on Firebird 2.5 SuperClassic on a normal >>> desktop, so no fancy IO etc. with a

Re: [Firebird-devel] Crash in boot build, VC9

2011-04-04 Thread Alex Peshkoff
On 04/02/11 08:33, Claudio Valderrama C. wrote: > At this time, I assume isql is invoked by the batch process, since I only > see a screen to select the debugger. When I select VC9, I go into > PluginManager.cpp and the problematic line is signaled below: > > ~PluginModule() >

Re: [Firebird-devel] GEN_UUID() performance?

2011-04-04 Thread Thomas Steinmaurer
Hi Adriano, >> any ideas why inserting 1 million records with a GUID primary key using >> the built-in GEN_UUID() function takes WAY longer than with an integer >> primary key. My finding: >> >> I ran a VERY simple test case on Firebird 2.5 SuperClassic on a normal >> desktop, so no fancy IO etc.