Dmitry Yemanov a pensé très fort :
> 21.03.2014 20:32, Dmitry Yemanov wrote:
>
>> Obviously a bug. Working on it, thanks.
>
> Fixed now, please test.
LI-T6.3.0.30892 test ok :-)
thank you
Norbert
--
..
TetraSys
http://www.tetrasys.eu
---
21.03.2014 20:32, Dmitry Yemanov wrote:
> Obviously a bug. Working on it, thanks.
Fixed now, please test.
Dmitry
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to
21.03.2014 19:31, Norbert wrote:
>
> WI-T6.3.0.30932 Firebird 3.0 Alpha 2
>
> on CENTOS 6.5 and W7
>
> create table test (
> id integer generated by default as identity primary key,
> siteid integer not null);
>
>
> create index ix_test_siteid on test (siteid);
>
> insert into test
On 21/03/2014 13:18, Leyne, Sean wrote:
>
>> Sub-objects (parameters, columns, constraints) and attributes (say, routine
>> source) are not tracked directly.
>>
>> You should read system tables and compare (in before and after triggers).
> How?
>
> Yes I can create a trigger, but I can't read the b
21.03.2014 17:18, Leyne, Sean wrote:
> So, you can't see what sub-objects have changed. Which is the limitation I
> am trying to highlight.
You always can add feature request to tracker: BEFORE CREATE/DROP/ALTER
FIELD triggers
and NEW/OLD contexts in them for accessing changed field's prope
On 3/21/2014 12:18 PM, Leyne, Sean wrote:
>
>> Sub-objects (parameters, columns, constraints) and attributes (say, routine
>> source) are not tracked directly.
>>
>> You should read system tables and compare (in before and after triggers).
> How?
>
> Yes I can create a trigger, but I can't read the
> Sub-objects (parameters, columns, constraints) and attributes (say, routine
> source) are not tracked directly.
>
> You should read system tables and compare (in before and after triggers).
How?
Yes I can create a trigger, but I can't read the before/after views of the
system table from a t
On 21/03/2014 13:03, Leyne, Sean wrote:
> So, I can find out which object (Trigger, Procedure, View and Table) has
> changed, great!
>
> How do I find out column/field has changed for ALTER TABLE ADD ?
>
> (I didn't find anyway based on the link that Carlos cited)
>
>
Sub-objects (parameters,
> -Original Message-
> From: Claudio Valderrama C. [mailto:cva...@usa.net]
> Sent: Thursday, March 20, 2014 9:19 PM
> To: 'For discussion among Firebird Developers'
> Subject: Re: [Firebird-devel] RFC: stop fiddling with sys tables
>
> > -Original Message-
> > From: Leyne, Sean [
On 03/21/14 19:39, Dimitry Sibiryakov wrote:
> 21.03.2014 16:35, Mark Rotteveel wrote:
>> With field length I mean the declared length (for single byte character
>> sets) or 4*declared length for UTF8), eg VARCHAR(500): declared length is
>> 500, not 502.
> This is data limit in chars and in mo
21.03.2014 16:35, Mark Rotteveel wrote:
> With field length I mean the declared length (for single byte character
> sets) or 4*declared length for UTF8), eg VARCHAR(500): declared length is
> 500, not 502.
This is data limit in chars and in most of other APIs it is returned
separately from
le
On Fri, 21 Mar 2014 16:23:38 +0100, Dimitry Sibiryakov
wrote:
> 21.03.2014 14:29, Mark Rotteveel wrote:
>> AFAIK the length is the maximum length (in bytes) of the field, not of
>> the
>> buffer.
>
>What do you call "field length"? In ODS (AFAIK) VARCHAR is kept with
>these two extra
> by
Salut,
WI-T6.3.0.30932 Firebird 3.0 Alpha 2
on CENTOS 6.5 and W7
create table test (
id integer generated by default as identity primary key,
siteid integer not null);
create index ix_test_siteid on test (siteid);
insert into test ( siteid ) values (3);
insert into test ( sitei
21.03.2014 14:29, Mark Rotteveel wrote:
> AFAIK the length is the maximum length (in bytes) of the field, not of the
> buffer.
What do you call "field length"? In ODS (AFAIK) VARCHAR is kept with these
two extra
bytes as well, so maximum length of filed on disk and in memory is two bytes
big
Carlos,
> LS> OK, but since DDL Triggers don't yet exist -- what should be supported in
> the meantime?
>
> DDL triggers are already available at FB 3:
> http://tracker.firebirdsql.org/browse/CORE-2310
Thanks for the link, help a lot.
Sean
I was thinking about your mutex protected linked list when it occurred
to me that Firebird might benefit from a piece of technology I call
"cycle lock." Here is a description of the motivation and the technique.
Falcon, NuoDB, and AmorphousDB all use a hash table to map transaction
ids into tr
consistency check in MERGE with more data
-
Key: CORE-4369
URL: http://tracker.firebirdsql.org/browse/CORE-4369
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions:
On 03/21/14 00:51, Claudio Valderrama C. wrote:
> Hello, I have an empty x.fdb in FB3. I created some user "caspian". I start
> firebird.exe with
> -ma flags (multi + application). Now I can connect through TCP with that
> user but not with sysdba:
>
> F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\
On 03/21/14 07:47, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Claudio Valderrama C. [mailto:cva...@usa.net]
>> Sent: Jueves, 20 de Marzo de 2014 16:51
>>
>> F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql
>> localhost:x.fdb
>> -user sysdba -pass masterkey
>> Sta
On Fri, 21 Mar 2014 14:18:07 +0100, Dimitry Sibiryakov
wrote:
> Hello, All.
>
>In new API data length returned for SQL_VARYING still two bytes
smaller
>than real
> buffer requirement. Does it have a justification other than "make
> everything the same way
> as it was in old API"?
AFAIK
Hello, All.
In new API data length returned for SQL_VARYING still two bytes smaller than
real
buffer requirement. Does it have a justification other than "make everything
the same way
as it was in old API"?
--
WBR, SD.
---
On Fri, 21 Mar 2014 14:39:31 +0400, Alex Peshkoff
wrote:
> On 03/21/14 14:23, Mark Rotteveel wrote:
>> Under which conditions is the error 335544572 (isc_dsql_cursor_err)
>> Invalid cursor reference returned for a fetch call?
>
> Typically if non-select operator was executed.
As far as I can tel
On 03/21/14 14:23, Mark Rotteveel wrote:
> Under which conditions is the error 335544572 (isc_dsql_cursor_err)
> Invalid cursor reference returned for a fetch call?
Typically if non-select operator was executed.
--
Learn
Under which conditions is the error 335544572 (isc_dsql_cursor_err)
Invalid cursor reference returned for a fetch call?
I am trying to come up with an answer for
http://stackoverflow.com/questions/22555377/firebird-sql-error-code-504-invalid-cursor-reference
but the abstraction used on Jaybird of
Provide name of TABLE / VIEW when some statement violates CHECK.
Key: CORE-4368
URL: http://tracker.firebirdsql.org/browse/CORE-4368
Project: Firebird Core
Issue Type: Improvem
Extend SELECT FIRST nn clause with ability to obtain all records with equal RANK
Key: CORE-4367
URL: http://tracker.firebirdsql.org/browse/CORE-4367
Project: Firebird Cor
On 03/21/14 01:38, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Alex [mailto:peshk...@mail.ru]
>> Sent: Miércoles, 19 de Marzo de 2014 3:09
>>
>>
>> On 03/19/2014 10:40 AM, Claudio Valderrama C. wrote:
>>> Alex said:
Main idea was to be able to generate programs for olde
27 matches
Mail list logo
