[Firebird-devel] IB OBDC driver released on github with fixes

[Carlos H. Cantu]

https://blogs.embarcadero.com/interbase-odbc-driver-on-github/

Can someone check if some of their fixes could be applied to the Firebird
driver? I remember people saying that our driver didn't work well with PowerBI,
and they are saying that this was fixed.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiled statement cache

[Carlos H. Cantu]

Maybe IBSurgeon can help with this, since HQBird monitor statements and they 
have lots of customers using it... probably an average can be calculated based 
on them.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 26.02.2022 17:14, Adriano dos Santos Fernandes wrote:
>> > I do want to define default cache size.
>> > I'm thinking in 2M.
>> > Comments?

DY> We need to start with something, so why not. However, it would be helpful 
to know what are the "common" statement sizes for tables, procedures, etc. Of 
course, table with one column much differs from table with 100 computed 
columns, as well as a one-liner procedure differs from a 1MB-BLR one. But maybe 
you have more or less real databases to get these estimations from.


DY> Dmitry


DY> Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Windows installer and ICU files

[Carlos H. Cantu]

I would go with the single option: Client install

What would be the reason to not distribute the "extra" DLLs? If it is
to save disk space, with Terabytes HDDs being the standard today, I
would not worry with that.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

PR> On Mon, 16 Aug 2021 17:34:09 +0300
PR> Alex Peshkoff via Firebird-devel
PR>  wrote:

>> 
>> One detail - this should not be called "minimum client install".
>> This should be called "default install",


PR> Or maybe just call it 'client install', or 'client libraries install' ?

>> and _minimum_ one should behave almost like now - but tzdata is also not
>> needed.

PR> But this also poses the question - do we even want to support wht is
PR> currently the minimum client install in the installer. Who could actually 
use
PR> such a minimal client with Firebird 4.0 and later ? It might just be better 
to
PR> document what the absolute minimum is rather than encourage it.


PR> Paul



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Windows installer and ICU files

[Carlos H. Cantu]

VK>Only by explicit user request, off by default.

Beside the ICU DLLs, I also agree with Adriano that zlib1.dll should
be installed during a Client install.

I would go further and install chacha.dll too. Currently installer
doesn't install chacha.dll during a Client install, and this doesn't
makes sense since chacha is the default wire encryption algorithm in
FB 4.

IMHO, default option would be to install all files needed to make a
complete client installation, meaning that user would be able to use
all official supported features (compression, chacha, etc) being sure
that everything will work as expected (ie: no risk to have any kind of
problem due to missing files).

If nobody objects, I'll open a ticket for this.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

VK> 14.08.2021 15:54, Carlos H. Cantu wrote:
>> Hi!
>> 
>> I see Firebird 4.0 Windows Installer does not copy the ICU dlls when
>> doing a client+tools or minimum client install. Speaking with Adriano,
>> it seems that having tzdata files are not enough to assure that all
>> time zones conversions will be handled correctly. For that, ICU dlls
>> are needed too.

VK>IIRC, ICU needed to fbclient only to correctly display tz names.
VK> I.e. not for conversions or something really important. If client
VK> app requires ICU for own needs, it is not our deal.

>> So, I think installer should install them during client installs.
>> 
>> Comments?

VK>Only by explicit user request, off by default.

VK> Regards,
VK> Vlad


VK> Firebird-Devel mailing list, web interface at
VK> https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Windows installer and ICU files

[Carlos H. Cantu]

Hi!

I see Firebird 4.0 Windows Installer does not copy the ICU dlls when
doing a client+tools or minimum client install. Speaking with Adriano,
it seems that having tzdata files are not enough to assure that all
time zones conversions will be handled correctly. For that, ICU dlls
are needed too.

So, I think installer should install them during client installs.

Comments?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 production release date?

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird 4 production release date?


I'm still thinking if I will release a migration guide for FB 4. The major steps migrating from older ODS are the same as migrating to FB 3, but there may be some gotchas not necessarily in the migration of the database itself, but regarding new datatypes, new GC and isolations, etc. that could affect applications.

Feel free to contact me in private if you have anything to add regarding a new guide, since it is probably offtopic here.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Thank you Carlos!   It should be pretty soon I think..
 
Will you be writing a FB3 to FB4 migration guide?  Or is this migration not as complex?
 
Best,
Mike Simmons
 
From: Carlos H. Cantu 
Sent: Friday, August 14, 2020 2:35 PM
To: For discussion among Firebird Developers 
Subject: Re: [Firebird-devel] Firebird 4 production release date?
 
Take a look here:
https://youtu.be/LgRoTwLQ6eA?t=1644

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br




Hi,
 
Is there any planned, targeted or estimated release date for the production version of Firebird 4?
 
Thanks,
Mike Simmons


 





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 production release date?

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird 4 production release date?


Take a look here:
https://youtu.be/LgRoTwLQ6eA?t=1644

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Hi,
 
Is there any planned, targeted or estimated release date for the production version of Firebird 4?
 
Thanks,
Mike Simmons





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6332) Get rid of FileSystemCacheThreshold parameter

[Carlos H. Cantu (JIRA)]

Get rid of FileSystemCacheThreshold parameter
-

 Key: CORE-6332
 URL: http://tracker.firebirdsql.org/browse/CORE-6332
 Project: Firebird Core
  Issue Type: Task
  Components: Engine
Affects Versions: 4.0 Beta 2
Reporter: Carlos H. Cantu


Since FileSystemCacheThreshold looks like an attempt to allow a kind of "per 
database" configuration for filesystem cache usage when there was no 
databases.conf, I suggest to get rid of it and create a more obvious per 
database parameter, ie: AllowFilesystemCache (boolean), in Firebird 4.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] gbak and non-native ODS

[Carlos H. Cantu]

LS> Given that system tables are no longer able to be directly
LS> manipulated, source SQL can no longer be deleted/removed.  I would
LS> propose that gbak should no longer backup BLR, only source SQL and
LS> have the SQL recompiled on restore.  If the recompile failed, the
LS> object would be marked as "Invalid"

It is still possible to erase source code of procedures and triggers
updating the system tables. This trick needs to exists until someone
find a better way to protect the source from spies.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Interbase vs Firebird by Embarcadero


Hi Holger,

I got curious on this: "Using nvme ssds on windows server OS without proper driver support always results in very poor performance"

I have Samsung EVO nvme ssd in my Windows 10 development machine and never noticed any bad performance accessing FB databases.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Sean,

on the machine i tested it and in the config i tested based on what i was able to find from their description
to have a similar test environment, yes, the resulting number that was reported  in the test was more or less
the same for both platforms, but i expect, that this was more or less a simple result of the maximum I/O
the machine was able to deliver and not really a real world useable database server test, since caches need
to be filled before the real test starts etc. Our benchmark does a much better real world result.

i do not remember real result and i already deleted the setup  but in fact on our machine it was even with
both platforms alsmost twice as high as the ones embarcadero showed in their interbase result and i had
no idea, what they were using to get the bad result for firebird. But one simple way is know: Using nvme ssds
on windows server OS without proper driver support always results in very poor performance, perhaps the
combination with journaling makes this advantage, since write I/O profile is for sure completly different,
but since we know how to make also nvme ssds in windows server os really fast, the test result is still b...s...

if you and others are interested in my setup, i will have a look if i can find the tpc setup again on one of my
dozens of tb on several nas systems, just let me know and i can prepare it again and firebird project can use
that for giving the answer to the embarcadero propaganda.

And in fact, the discussion about this was in August 2017 alread, that was the first time embarcadero was
announcing "their" tpc "results".

my resume in that discussion then was

"with forced writes on interbase was 0.5% faster, with forced writes off interbase was 2% slower. "

But as visible in network protocol this was tested with fb3 default otw encryption on which is not supported by interbase afaik
and when looking at the network packages with a sniffer, it was obvious that interbase protocol was not encrypted.
I did not retest it with other optimisations in firebird since i knew already published results from embarcadero
were manipulated or simply not honest.

and for everyone who is interested: feel free to use our benchmark db and its procedures with interbase database
encryption activated , but don´t expect the result to come fast ...

With a Firebird encryption module active (like the one we deliver in ibexpert full version), you see a big decrase
in performance when using very low cache buffer settings, but it is getting almost to full speed if large cache buffers
are used, since the firebird way is only affected on reading and writing pages, which is obviously not done
so often when data can stay in ram. In Interbase they definitly use another way, since our results showed
also with large cache buffers  the database operations remain much slower ...

and for Karol,

Delphi is definitly not a bad product, but please understand what my biggest criticism there is: Each new version
is not only update and work on, there are so many (perhaps intended) incompatibilities with each new version,
and things like late or missing 64bit android support for native platforms and other problems in the last years
with their mobile platform support and strange level of half linux support, and when they talk about multiplatform
but are not even able to have a 64bit Windows IDE, that is not what the customers want.

We stopped using delphi for all new projects about 6 years ago and switched to lazarus (with pas2js/tms webcore
for mobile platforms) and we will never go back again, but that decision is not so easy for existing projects (as
you might know, ibexpert has about 1.7 millions lines of pascal code and we still use delphi5 to compile and
develop it, even that about 75% of sourcecode is already compatible to lazarus, the remaing 25% is not
so easy converted in another 25% of time, but we are working on this ...

But in a lot of consulting jobs, we are still working in customer environments on newer delphi versions so i
know what we are talking about.  If anyone is happy with delphi, i have no problem with this, but i am
extremly happy with my in several thousands of hours used lazarus development environment which
i was able to learn in almost 0 time because pascal/lcl/vcl is almost exactly the same in both platforms
and i am too old and too lazy to learn new programming language. And the advantages of mobile apps
based on lazarus/pas2js/tms webcore is extremly helpful for what we need.




Mit freundlichen Grüßen / Kind regards
Holger Klemt


Am 02.03.202

Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird UDF compiled with Lazarus 2.0.0 and FPC 3.0.4


More than 15 years ago, I found that FPC didn't produce PIC code, and this made UDFs to crash the FB server.

When I was testing, it was really easy to reproduce the problem, specially with SuperServer: open two connections and run a SP that calls the UDF inside a big loop. You must do this in both connections at the same time. In my tests, it always crashed FB after a few seconds running.

I hope FPC has improved in this aspect and maybe now it can be safely used to create UDFs.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br






Thank you all guys, I finally managed to fix the issue:


There was an initialization section in one unit imported that set IsMultiThread = True
I removed the cthreads unit in the uses clause.

Does anybody have any clue what are the implications of these changes?



On Thu, Feb 27, 2020 at 1:41 PM liviuslivius  wrote:




Two things

1. What is calling convention should be cdecl.
2. How do you alloc memory for string?

Regards,
Karol Bieniaszewski

Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel








Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Inserts and FKs


Thank you!

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Behavior of Oracle 11 + Postgres 9.6.

Common DDL:
create table master (id number primary key);
create table detail (id number primary key, master number);
alter table detail add foreign key (master) references master(id) on delete cascade;

Oracle (2 sqlplus windows):
tx1:
set transaction isolation level read committed;
insert into master(ID) values(1);

tx2:
set transaction isolation level serializable;

tx1:
commit;

tx2:
insert into detail(ID, master) values(1, 1);

ERROR at line 1:
ORA-08177: can't serialize access for this transaction

Postgres (2 psql windows):
tx1:
begin transaction isolation level read committed;
insert into master(ID) values(1);

tx2:
begin transaction isolation level serializable;

tx1:
commit;

tx2:
insert into detail(ID, master) values(1, 1);

ERROR:  insert or update on table "detail" violates foreign key constraint "il_master_fkey"
DETAIL:  Key (master)=(1) is not present in table "master".

пт, 6 сент. 2019 г. в 22:38, Carlos H. Cantu <lis...@warmboot.com.br>:




Thanks Ann!

So far all the opinions are that the currently behavior is wrong (or
inconsistent, at last).

I'll be glad if someone who has other RDBMS installed can compare how
they behave with the exactly described scenario, and report the
results back here. Please pay attention in the transaction isolations
and make sure they are started/commit in the correct times.

Thanks!

Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


AH> Cheers,


AH> Ann

>> On Sep 6, 2019, at 8:24 AM, Mark Rotteveel <m...@lawinegevaar.nl> wrote:
>>
>>> On 6-9-2019 01:46, Carlos H. Cantu wrote:
>>> I understand that there are other scenarios where the currently FK
>>> behavior is correct and makes sense, for example, in the case of
>>> avoiding deleting a master record with "commited but not visible
>>> childs",

AH> Yes.  Unique, Primary Key, and Foreign Key constraints are
AH> handled in a special omniscient mode to avoid concurrent,
AH> incompatible changes. Triggers and check constraints operate in
AH> the mode of the user transaction.

>>> but for the reported example, the currently behavior looks
>>> incorrect, and for people with business logic implemented in triggers,
>>> it may/will lead to incorrect results.
>>
>> I think you're right. You should only be able to insert records that reference records that are visible to your transaction. Given Tx2 started before Tx1 committed, the effects from Tx1 aren't visible to your transaction. Your insert in Tx2 should fail as the master record from Tx1 doesn't exist from the perspective of Tx2.

AH> Interesting.  In the case of inserting a child, the master must
AH> be visible to the transaction doing the insert.  In the case of
AH> deleting a master, the existence of a child - even if uncommitted must block the delete.
>>
>>> Does anyone knows if this behavior is following the Standard?
>>
>> I don't think this behaviour is correct in view of the standard, but I haven't looked it up.
>>

AH> No, this behavior is not standard compliant.  

AH> Good luck,

AH> Ann



Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel








Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6138) Inconsistent behavior regarding visibility of master record on detail inserts

[Carlos H. Cantu (JIRA)]

Inconsistent behavior regarding visibility of master record on detail inserts
-

 Key: CORE-6138
 URL: http://tracker.firebirdsql.org/browse/CORE-6138
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 2.5.9, 3.0.4, 3.0.3, 3.0.2, 3.0.1, 3.0.0
Reporter: Carlos H. Cantu


During a master-detail insert using two different transactions, where the 
detail transaction is snapshot, FB allows the detail insert even when the 
master record is not visible for the detail transaction. It can be easily 
reproduced with the following steps:

Open two isql sessions (isql1 and isql2) connected to the same database, and 
follow the sequence of commands in this order:

isql1:
CREATE TABLE A
 (
 ID BIGINT NOT null PRIMARY KEY);

 CREATE TABLE B
 (
 ID BIGINT NOT null PRIMARY KEY,
 ID_A BIGINT NOT NULL
 );

 ALTER TABLE B ADD constraint FK_B__A FOREIGN KEY(ID_A) REFERENCES A(ID) ON 
UPDATE CASCADE ON DELETE CASCADE;

 commit;
 INSERT INTO A (ID) VALUES (1);

isql2:
 commit; -- to be sure that if there is active transaction, it will be ended now
 select * from a; -- just to be sure that snapshot transaction is started now

isql1:
 commit;

isql2:
 INSERT INTO B (ID, ID_A) VALUES (1, 1); -- This SHOULD break, since master is 
not visible for this transaction, but FB will accept it
 -- Any trigger based action against the master record will have null effect, 
but the detail insert will not fail!
 commit;

PS: For people with business rules on triggers, this behavior may lead to wrong 
results.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs

[Carlos H. Cantu]

Title: Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs


If you had understood the case, you would have noticed that the transaction in isql-1 doesn't matter. Either readcommited or snapshot will show the same result. That's why I didn't mind about running set transaction in my step-by-step instructions.

isql-2 must be snapshot, and this is the default isolation for isql transactions (so, no need for set transaction).

Point is: there is an inconsistency in the currently Firebird behavior that can be easily reproduced.

I'll open a ticket in the tracker. Since I have zero knowledge about FB code, I cannot fix it by myself. IMHO, this ia a serious problem that deserves attention.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br






Why do you think that one isql have transaction read commited but second have snapshot?
I do not see your transaction command.
If you depend on automatic transactions started by isql, then both are the same, no randomness...

Regards,
Karol Bieniaszewski





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs

[Carlos H. Cantu]

Let's go, based on Karol's previous example. 

Open two isql sessions (isql1 and isql2) connected to the same database, and 
follow the sequence of commands in this order:

isql1:
CREATE TABLE A
(
ID BIGINT NOT null PRIMARY KEY);

CREATE TABLE B
(
ID BIGINT NOT null PRIMARY KEY,
ID_A BIGINT NOT NULL
);

ALTER TABLE B ADD constraint FK_B__A FOREIGN KEY(ID_A) REFERENCES A(ID) ON 
UPDATE CASCADE ON DELETE CASCADE;

commit;
INSERT INTO A (ID) VALUES (1);

isql2:
commit; -- to be sure that if there is active transaction, it will be ended now
select * from a; -- just to be sure that snapshot transaction is started now

isql1:
commit;

isql2:
INSERT INTO B (ID, ID_A) VALUES (1, 1); -- This should break, since master 
should not be visible for this transaction, but FB will accept it
commit;

No errors at all! 

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DS> 06.09.2019 23:00, Carlos H. Cantu wrote:
>> Sending screenshots of the isql sessions will not help, since what really 
>> matters is the 
>> time of starting/commit the transactions.

DS>You don't need to send screenshots. Send script. Second instance of isql 
can be run in
DS> the right moment using command "shell".Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: ODP: ODP: Inserts and FKs

[Carlos H. Cantu]

Title: Re: ODP: [Firebird-devel] ODP:  ODP:  Inserts and FKs


You can use your own example (that you sent before), just follow the comments that I marked in red, and you will reproduce the problem.

Sending screenshots of the isql sessions will not help, since what really matters is the time of starting/commit the transactions.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Better show your commands in isql then we can reproduce problem.
 
Regards,
Karol Bieniaszewski





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

Thanks Ann!

So far all the opinions are that the currently behavior is wrong (or
inconsistent, at last).

I'll be glad if someone who has other RDBMS installed can compare how
they behave with the exactly described scenario, and report the
results back here. Please pay attention in the transaction isolations
and make sure they are started/commit in the correct times.

Thanks!

Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


AH> Cheers,


AH> Ann

>> On Sep 6, 2019, at 8:24 AM, Mark Rotteveel  wrote:
>> 
>>> On 6-9-2019 01:46, Carlos H. Cantu wrote:
>>> I understand that there are other scenarios where the currently FK
>>> behavior is correct and makes sense, for example, in the case of
>>> avoiding deleting a master record with "commited but not visible
>>> childs",

AH> Yes.  Unique, Primary Key, and Foreign Key constraints are
AH> handled in a special omniscient mode to avoid concurrent,
AH> incompatible changes. Triggers and check constraints operate in
AH> the mode of the user transaction. 

>>> but for the reported example, the currently behavior looks
>>> incorrect, and for people with business logic implemented in triggers,
>>> it may/will lead to incorrect results.
>> 
>> I think you're right. You should only be able to insert records that 
>> reference records that are visible to your transaction. Given Tx2 started 
>> before Tx1 committed, the effects from Tx1 aren't visible to your 
>> transaction. Your insert in Tx2 should fail as the master record from Tx1 
>> doesn't exist from the perspective of Tx2.

AH> Interesting.  In the case of inserting a child, the master must
AH> be visible to the transaction doing the insert.  In the case of
AH> deleting a master, the existence of a child - even if uncommitted must 
block the delete.
>> 
>>> Does anyone knows if this behavior is following the Standard?
>> 
>> I don't think this behaviour is correct in view of the standard, but I 
>> haven't looked it up.
>> 

AH> No, this behavior is not standard compliant.  

AH> Good luck,

AH> Ann



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: ODP: Inserts and FKs

[Carlos H. Cantu]

Title: Re: ODP: [Firebird-devel] ODP:  Inserts and FKs


If you wanna test, please use isql... I don't know how flamerobin deals with transactions internally.

I just tested with FB 3 and it is the same (wrong, imho) behavior as FB 2.5.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





>>tx1 starts (read commited)
>>tx1 INSERT INTO A (ID) VALUES (1);
>>tx2 starts (snapshot isolation) - How did you started tx2? If you are in isql, you need at last to run some statement, like a select, to actually start a transaction. For example, run this on the >>second isql section:
>>commit; -- making sure that if there is a transaction started, it will be closed now
>>select * from a; -- Doing this you are actually starting a transaction (tx2)
>>tx1 commits
>>tx2 INSERT INTO B (ID, ID_A) VALUES (1, 1);
>>tx2 commits – i have an error here! violation of FOREIGN KEY constraint "FK_B__A" on table "B" Foreign key reference target does not exist Problematic key value is ("ID_A" = 1)
>>or transaction wait if i specifi wait for locks.
>>I tested your steps (following my comments above) and get no error (FB 2.5).
 
 
I have tested this by 2 instances of Flamerobin.
But i have tested this under FB3 (WI-V3.0.4.32989 Firebird 3.0) not 2.5.
I have not 2.5 installed as i have migrated all to FB3.
 
Regards,
Karol Bieniaszewski





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Inserts and FKs

[Carlos H. Cantu]

Title: Re: ODP: [Firebird-devel] Inserts and FKs


tx1 starts (read commited)
tx1 INSERT INTO A (ID) VALUES (1);
tx2 starts (snapshot isolation) - How did you started tx2? If you are in isql, you need at last to run some statement, like a select, to actually start a transaction. For example, run this on the second isql section:
commit; -- making sure that if there is a transaction started, it will be closed now
select * from a; -- Doing this you are actually starting a transaction (tx2)
tx1 commits
tx2 INSERT INTO B (ID, ID_A) VALUES (1, 1);
tx2 commits – i have an error here! violation of FOREIGN KEY constraint "FK_B__A" on table "B" Foreign key reference target does not exist Problematic key value is ("ID_A" = 1)
or transaction wait if i specifi wait for locks.

I tested your steps (following my comments above) and get no error (FB 2.5).

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





I have tested this and i got an error all the time or i get waiting for lock depending on transaction settings.
I do the following:
 
CREATE TABLE A
(
ID BIGINT NOT null PRIMARY KEY
);
 
CREATE TABLE B
(
ID BIGINT NOT null PRIMARY KEY,
ID_A BIGINT NOT NULL
);
 
ALTER TABLE B ADD constraint FK_B__A FOREIGN KEY(ID_A) REFERENCES A(ID) ON UPDATE CASCADE ON DELETE CASCADE;
 
tx1 starts (read commited)
tx1 INSERT INTO A (ID) VALUES (1);
tx2 starts (snapshot isolation)
tx1 commits
tx2 INSERT INTO B (ID, ID_A) VALUES (1, 1);
tx2 commits – i have an error here! violation of FOREIGN KEY constraint "FK_B__A" on table "B" Foreign key reference target does not exist Problematic key value is ("ID_A" = 1)
or transaction wait if i specifi wait for locks.
 
I have also create empty triggers but no change
I suppose you do someting different. Please describe exact steeps to reproduce this.
 
Regards,
Karol Bieniaszewski





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

Thanks Mark! I really wish that FB could be improved to avoid that
situation.

Let's see what our friends thinks about it.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

MR> On 6-9-2019 01:46, Carlos H. Cantu wrote:
>> I understand that there are other scenarios where the currently FK
>> behavior is correct and makes sense, for example, in the case of
>> avoiding deleting a master record with "commited but not visible
>> childs", but for the reported example, the currently behavior looks
>> incorrect, and for people with business logic implemented in triggers,
>> it may/will lead to incorrect results.

MR> I think you're right. You should only be able to insert records that 
MR> reference records that are visible to your transaction. Given Tx2 
MR> started before Tx1 committed, the effects from Tx1 aren't visible to 
MR> your transaction. Your insert in Tx2 should fail as the master record 
MR> from Tx1 doesn't exist from the perspective of Tx2.

>> Does anyone knows if this behavior is following the Standard?

MR> I don't think this behaviour is correct in view of the standard, but I
MR> haven't looked it up.

MR> Mark



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

APvFd> What I wanted to suggest is even more ugly ;)

:-)

Anyway, do you know if the described behavior fits in the SQL
Standard?

Do you think FB can be improved to avoid the described "flaw"?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

MA> If you do master and detail in separate transaction then tx2
MA> should not be started before tx1, tx2 start MUST wait for tx1
MA> SUCCESSFUL commit, otherwise your business logis FLAWED.

Tx2 wasn't start before tx1. Read again my first email.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

APvFd> Certainly you can repeat search for master record in trigger but IMHO
APvFd> that's not beautiful solution.

Not sure if I understand what you mean with "repeat search for master
record".

The only workaround that I can think of, to not break the business
logic, would be checking rows_affected after the update and if it
zero, raise an exception. This would need to be done in all triggers
with such logic, and I see it as an ugly workaround, not a real
solution.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

APvFd> On 06.09.2019 14:14, Carlos H. Cantu wrote:
>> Re: [Firebird-devel] Inserts and FKs
>>
>>   Hi
>>
>> "tx2 inserts a detail record in TableB
>>     Trigger on TableB tries to update master record,
>>     since the record is still not visible for this snapshot,
>>     update has null effect"
>>
>> I do not understand this point. If table B i detail it can only insert 
>> record for visible to it record in master. Or do you in your trigger 
>> you update whole table master not only master record of this detail?
>>
>>
>> Trigger updates only the master record. The problem is exactly the 
>> fact that the insert of the detail record doesn't fail, because FK is 
>> out of transaction control so it can see the master record (but the 
>> update can't see it).

APvFd> Certainly you can repeat search for master record in trigger but IMHO 
APvFd> that's not beautiful solution.



APvFd> Firebird-Devel mailing list, web interface at
APvFd> https://lists.sourceforge.net/lists/listinfo/firebird-devel



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Inserts and FKs







Hi

"tx2 inserts a detail record in TableB
    Trigger on TableB tries to update master record,
    since the record is still not visible for this snapshot,
    update has null effect"

I do not understand this point. If table B i detail it can only insert record for visible to it record in master. Or do you in your trigger you update whole table master not only master record of this detail?



Trigger updates only the master record. The problem is exactly the fact that the insert of the detail record doesn't fail, because FK is out of transaction control so it can see the master record (but the update can't see it).

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Inserts and FKs

[Carlos H. Cantu]

Recently I had a real situation that drove me crazy for several days
while trying to find what actually happened. After lots of thinking,
checking the auditing logs and chatting with Vlad, the only scenario
that could explain what happened is:

TableA (master)
TableB (detail)
There is FK between TableB and TableA

tx1 starts
tx1 inserts master record in TableA
tx2 starts (snapshot isolation)
tx1 commits
tx2 inserts a detail record in TableB
Trigger on TableB tries to update master record,
since the record is still not visible for this snapshot,
update has null effect
tx2 commits (no error)

The detail insert does not fail with broken FK because FK checking is
out of transaction control, but the update ran by the trigger had no
effect because the master record was not visible for the update.

>From the consistency point of view, in this example, if the trigger
could not see the record and modify it, the FK validation should fail
too. IMHO, if the transaction isolation doesn't allow the record to be
seen (at trigger level) it should not be seen at the FK validation
level too.

I understand that there are other scenarios where the currently FK
behavior is correct and makes sense, for example, in the case of
avoiding deleting a master record with "commited but not visible
childs", but for the reported example, the currently behavior looks
incorrect, and for people with business logic implemented in triggers,
it may/will lead to incorrect results.

Does anyone knows if this behavior is following the Standard?

Any comments?

[]s
Carlos
http://www.firebirdnews.org



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6036) Adjust comment of DummyPacketInterval in fb.conf

[Carlos H. Cantu (JIRA)]

Adjust comment of DummyPacketInterval in fb.conf


 Key: CORE-6036
 URL: http://tracker.firebirdsql.org/browse/CORE-6036
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 4.0 Beta 1, 3.0.4, 3.0.3
Reporter: Carlos H. Cantu


# NOTE. This option may hang or crash Windows NT4 or Windows 2000 pre SP3 
# on the client side as explained here: 
# http://support.microsoft.com/default.aspx?kbid=296265.
# or may not prevent eventual inactive client disconnection for other OS.

Firebird 3 can't run on Windows NT and Windows 2000 (MSVC 10 is not support in 
those Windows versions), so it doesn't make sense to have such comment in 
fb.conf. Please remove it for the next releases/subreleases.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

[Carlos H. Cantu]

>> Multi-row INSERTs - also marked as NO, but actually you can do insert
>> from select in Firebird.

MR> AFAIK, they mean insert with a values list (table value constructor) 
MR> instead of a single values set.

Maybe... I based my answer on the "hint" displayed for that feature in
the table.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases


Seems that there are some incorrect information, ie:

Duplicate NULL values in unique index - Firebird is marked as NO, but actually you can have several NULL keys in a Unique index contraint (not in PK).

Multi-row INSERTs - also marked as NO, but actually you can do insert from select in Firebird.

Maybe there are more incorrect information...

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Last updated: 2018-11-06
http://www.sql-workbench.eu/dbms_comparison.html





Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

[Carlos H. Cantu]

I dream about the day that "arithmetic exception, numeric overflow, or
string truncation" will be replaced by more specific errors.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

APvFd> On 17.06.2018 13:17, Mark Rotteveel wrote:
>> I don't agree with this ticket getting closed. I raised an objection 
>> to the current solution in the comments that I think needs to be 
>> addressed.
>>
>> The current solution causes a divergence in errors between 
>> decimals(p,s) with p <=18 and 18 < p <=34, which is confusing and 
>> leaks implementation details to the user. In the same situation it 
>> should raise the same errors.
>>

APvFd> Error 'arithmetic exception, numeric overflow, or string truncation' is
APvFd> too widely used here & there in our codebase. Therefore it was suggested
APvFd> by Dmitry Emanov to avoid that error when dealing with decimal float 
APvFd> digits, use instead exact native error codes. I do not remember where 
APvFd> and how was it discussed, we often talk privately but sometimes discuss
APvFd> such thing on forums too.

APvFd> Must say that if we take some decision changing this particular message
APvFd> I suppose it will be better to review all related errors related with 
APvFd> decimal floats. On my mind if we decide to do it better do sooner than
APvFd> later - beta release is hopefully coming soon.

APvFd> A.


APvFd> 
--
APvFd> Check out the vibrant tech community on one of the world's most
APvFd> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
APvFd> Firebird-Devel mailing list, web interface at
APvFd> https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5742) Incorrect error message in iSQL when trying to create database with wrong password

[Carlos H. Cantu (JIRA)]

Incorrect error message in iSQL when trying to create database with wrong 
password
--

 Key: CORE-5742
 URL: http://tracker.firebirdsql.org/browse/CORE-5742
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 3.0.3
Reporter: Carlos H. Cantu


Imagine a new user, just created as TESTE password 1234. 

isql -user teste -pas 123 [PASSWORD IS INTENCIONALLY WRONG]
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:d:\teste.fdb';
Statement failed, SQLSTATE = 42000
SQL error code = -104
-Token unknown
-teste

The error message "token unknown teste" has nothing to do with the real reason 
of the error, and makes no sense.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] About support for embed into iOS/Android

[Carlos H. Cantu]

Title: Re: [Firebird-devel] About support for embed into iOS/Android






@ Carlos H. Cantu




Personally, I'm very disappointed that those people who asked me about an Android port, seems to be ignoring it.



And you notified them that is available? And in conferences talk about this?



Most of them I don't have the personal contact, because it was just talks during the FDD conferences. And yes, in the last FDD (2017) we had a entire session about "FB for Android". No feedback so far, as far as I'm aware of.

Anyway, I think in modern times, it is important to have Android and iOS builds available. Probably this is one of the things people consider when searching for DB alternatives.





You can totally believe that most of the things I wish to have or have asked before I forget the next day.  Without feedback how you know what is the true interest of people? Is like insert a record on a table and never select it and hopping to somehow return back :)



I asked for feedback at last 2 times, in firebirdnews.org.





But at least, consider more seriously how improve your marketing strategy. Certainly FB deserve a much better position of the RDBMS market that it have!



Agreed.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] About support for embed into iOS/Android

[Carlos H. Cantu]

Title: Re: [Firebird-devel] About support for embed into iOS/Android


Speaking about Android port:

I pushed Alex a lot to make a Android port of Firebird. Not because I would need to use it (I still don't), but because I was questioned about its availability by several people, in conferences and in FireBase discussion lists.

Finally, he was able to put a beta version out and, after some months, it was also listed in the Firebird official site, so everybody can be aware of such build.

BUT, it looks like nobody is using it. At last, we got no feedback from real users.

I think main reasons are:

1) Lack of documentation about how to "install it" on Android
2) Lack of documentation about how to use such build in their apps (examples needed?)
3) None of the Delphi data access component writes (IBO, FIBPlus, Zeos, etc) seems to have worried to adapt their components to work in Android (I guess it would not be a hard work)
4) Or maybe people prefers to use other databases, even InterBase (which has an interesting feature for mobile usage, called Change Views).

Personally, I'm very disappointed that those people who asked me about an Android port, seems to be ignoring it.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





> But since nobody seemed to want it, I stopped work on it.
Its not a simple exercise

I understand. But *must* be a market for this, Embarcadero have it with interbase, https://realm.io/ is kind of popular (as many other NoSql options).

The problem is that I found this only because:

1- I know Firebird exist
2- And know it have a embebed version
3- I was looking for options for sqlite (https://duckduckgo.com/?q=sqlite+alternatives+ios). If you read, everyone point to a NoSql backend, or sqlite. The other posibilities are commercial (http://greenrobot.org/news/mobile-databases-sqlite-alternatives-and-nosql-for-android-and-ios/)

Firebird have a very poor marketing execution, IMHO, and this not help. Even more certain about potential features that are only know on mailing-list (is a know fact that customer mostly care for things that at least can be demoed :) ). But I think the high levels of apps that need both a data store for mobile and servers is matter to make clear that FB could fit the bill.

Do you have a $$ target? What about do a crow-sourcing in kick-starter, indiegogo or similar? And *do some marketing around*?

Maybe this could be as with mono before: Them have a free desktop/server version and provide a renew stream with the mobile offerings. 

And if this provide a sync capabilities I'm certain this will pick the interest of a lot of enterprise users. In fact, my project is based around this (I will implement sync with a event-sourcing, log-replay on top of sqlite).



2018-01-18 3:59 GMT-05:00 Paul Beach :




Mario,

<
I'm using sqlite for iOS/Android/Job connectors on desktops and plan to use PG for the servers. However, I wish to use some features common in RDBMS (like stored procedures, decimal types and more) that are not available in Sqlite and demand to recode for it.
However, I see on https://www.mail-archive.com/firebird-devel@lists.sourceforge.net/msg14559.html that exist a experimental build for iOS/Android.
If I could use a single RDBMS across all this, it could cut a lot of extra work and simplify my work!
So, how much close is the release for this? I could help on test stuff. I plan to release a MVP for my project in 3 months, and probably need to work on this for more than a year.
I only need support fairly recent devices (iOS >= 8 and Android Api >= 24).>>

You are the first and only person to date who has expressed any interest in this.
I managed to build Firebird 2.x on IOS, and got as far as getting the 3.x libfbclient to
cross compile for IOS. But since nobody seemed to want it, I stopped work on it.
Its not a simple exercise. Mind you if somebody wanted to help subsidise the
work, I would be prepared to continue

Paul.


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel





-- 
Mario A.Montoya
Gerente
http://www.elmalabarista.com

Haz pedidos & facturas con tu iPhone: http://www.elmalabarista.com/bestseller





--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Meltdown and Spectre

[Carlos H. Cantu]

I saw a performance comparison (using comercial benchmarks tools, not
specific for databases) and the most impact seems to be on Disk (even
SSD), followed by RAM and CPU. The only area that isn't impacted seems
to be GPU.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 10.01.2018 18:43, Leyne, Sean пишет:
>> 
>>> Tests are different, so results cannot be compared "as is".
>> 
>> I appreciate that the tests are different, I was commenting on the relative 
>> performance impact.

DY> Slowdown mostly depends on % of syscalls. R/O vs R/W tests would show 
DY> different relative impact due to different lock contention. Big page 
DY> cache (thus less I/O calls, even if resolved by the filesystem cache) vs
DY> small page cache - also different relative impact. Different workloads -
DY> also different relative impact.

DY> Dmitry


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5603) Allow change of field type to similar domain, even when there are associated constraints

[Carlos H. Cantu (JIRA)]

Allow change of field type to similar domain, even when there are associated 
constraints


 Key: CORE-5603
 URL: http://tracker.firebirdsql.org/browse/CORE-5603
 Project: Firebird Core
  Issue Type: Improvement
Affects Versions: 3.0.2, 2.5.7, 3.0.1, 2.5.6, 3.0.0, 4.0 Initial, 2.5.5, 
2.5.4, 2.5.3 Update 1, 2.1.7, 2.5.3, 2.5.2 Update 1, 2.5.2, 2.5.1, 2.5.0
Reporter: Carlos H. Cantu


Firebird does not allow changing the field type when there are pks, fks, 
indexes, in that field. This is a known limitation and a real pain.
But I can't see why it doesn't allow changing to a domain with the same type, 
ie:
Field was created as integer not null, and you want to change it to an existing 
domain, which is also declared as integer not null.
In this case, there is no change to the underlying stored data, so why do not 
allow it?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Changing numerics scale

[Carlos H. Cantu]

Ok, so we do not follow the standard in our currently implementation,
but we follow the standard in the DDL checking... this is a bit messy 

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 10.08.2017 21:57, Carlos H. Cantu wrote:

>> DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 
>> 6).
>> 
>> Are you sure? I can store such value both in (15, 4) as well in (15, 6).

DY> Formally, it cannot be stored inside (15, 6). But historically, FB 
DY> ignores the declared precision and always uses the maximum for the 
DY> underlying storage. This is buggy (from the SQL spec POV) and I expect
DY> to have it fixed/improved one day.


DY> Dmitry


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Changing numerics scale

[Carlos H. Cantu]

DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6).

Are you sure? I can store such value both in (15, 4) as well in (15, 6).

The range of accepted values for (15, 6) and (17, 6) is the same:
-9223.372.036.854,775808 to 9223.372.036.854,775807

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 10.08.2017 20:29, Carlos H. Cantu wrote:
>> 
>> Can someone explain why I can't change a field from numeric (15,4) to
>> numeric (15,6) [error is "New scale specified for column TESTE must be
>> at most 4."], but can change it to numeric (17,6) ?

DY> Because (15, 6) provides less integral precision (9 digits instead of 
DY> 11) and theoretically some existing values may not fit, making those 
DY> records unreadable.

DY> e.g. 1234567890.1234 is a valid (15, 4) but cannot be converted to (15, 6).


DY> Dmitry

DY> 
--
DY> Check out the vibrant tech community on one of the world's most
DY> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
DY> Firebird-Devel mailing list, web interface at
DY> https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Changing numerics scale

[Carlos H. Cantu]

Hi!

Can someone explain why I can't change a field from numeric (15,4) to
numeric (15,6) [error is "New scale specified for column TESTE must be
at most 4."], but can change it to numeric (17,6) ?

Internally, all the variations uses the same bigint 64bits and
accepts the same range of values, so why the change to numeric (15,6)
is not accepted by Firebird?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Where is Android port?

[Carlos H. Cantu]

Thanks Dmitry, I hope it will not take too long to publish it...
probably we will have a lot of people visiting the download page in
the next days.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DY> 23.03.2017 05:19, Carlos H. Cantu wrote:

>> I see two mentions in the 3.02 ReleaseNotes about Android port
>> [(CORE-3885) and (CORE-5332)], but I can't find any Android link in
>> the download page.
>>
>> This needs to be fixed.

DY> To be published, I'd want it to be rebuilt from the 3.0.2 codebase. The
DY> latest Android binaries are v3.0.0, not something to be put on the 
DY> v3.0.2 download page.


DY> Dmitry


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Where is Android port?

[Carlos H. Cantu]

I see two mentions in the 3.02 ReleaseNotes about Android port
[(CORE-3885) and (CORE-5332)], but I can't find any Android link in
the download page.

This needs to be fixed.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Announcing the first SHA1 collision

[Carlos H. Cantu]

FYI:
https://security.googleblog.com/2017/02/announcing-first-sha1-collision.html

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

[Carlos H. Cantu]

No improvements regarding blob transfer?

Even with the enhancements in 3.0, transferring blobs is still slow
compared to other datatypes.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

VK> 19.12.2016 19:51, Mark Rotteveel wrote:
>> Are there any wire protocol changes in Firebird 4 (or planned for
>> Firebird 4). And if so, where can I find information on those changes?

VK>I could remember the only small change, bug fix for CORE-5296 by Alex
VK> (commit 056164ab95c0ae52c970ab6603cf54d18fbc152f).

VK>I plan to introduce little change to pass statement timeout (op_execute,
VK> op_execute2). Details will be published soon.

VK> Regards,
VK> Vlad


VK> 
--
VK> Developer Access Program for Intel Xeon Phi Processors
VK> Access to Intel Xeon Phi processor-based developer platforms.
VK> With one year of Intel Parallel Studio XE.
VK> Training and support from Colfax.
VK> Order your platform today.http://sdm.link/intel
VK> Firebird-Devel mailing list, web interface at
VK> https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today.http://sdm.link/intel
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] CORE-3885 can be closed : Android port is done

[Carlos H. Cantu]

Title: Re: [Firebird-devel] CORE-3885 can be closed : Android port is done


I wonder when the download will be published in the official site, so we could attract more users.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





CORE-3885 can be closed : Android port is done

http://tracker.firebirdsql.org/browse/CORE-3885





--
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphiFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Android x86/arm64/x86_64 scripts and ports

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Android x86/arm64/x86_64 scripts and ports


Can someone also take a look at this:

http://tracker.firebirdsql.org/browse/WEB-146 

[]s
Carlos H. Cantu
eBook Guia de Migração para o FB 3 - www.firebase.com.br/guiafb3.php
www.FireBase.com.br - www.firebirdnews.org - blog.firebase.com.br





I have added the makefile needed for Android x86/arm64/x86_64

Please review and merge 

https://github.com/FirebirdSQL/firebird/pull/59

I will add them to master also 





--
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive. 
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerikFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB 3 source code analisys

[Carlos H. Cantu]

FYI:
http://www.viva64.com/en/b/0396/

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0 Is Available Now

[Carlos H. Cantu]

Congratulations to everyone involved!

Dream coming true!

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

sic> Firebird 3.0 Is Available Now - with major improvements in performance,
sic> security and SQL features


--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5194) Invalid computed by definition generated by isql -x

[Carlos H. Cantu (JIRA)]

Invalid computed by definition generated by isql -x
---

 Key: CORE-5194
 URL: http://tracker.firebirdsql.org/browse/CORE-5194
 Project: Firebird Core
  Issue Type: Bug
  Components: ISQL
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu
Priority: Critical


This came from Alexandre B. Smith... isql -x from FB 3 RC2 is generated invalid 
sql script when computed by fields exists. The test works fine in FB 2.5:

create database "c:\sp\test.fdb";


CREATE TABLE T (A TIMESTAMP,
B COMPUTED BY (current_timestamp - a));


commit;


exit;


isql -user sysdba -password masterkey test.fdb -x > test.sql


The result is:
-
SET SQL DIALECT 3; 


CREATE DATABASE 'test.fdb' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;




COMMIT WORK;


/* Table: T, Owner: SYSDBA */
CREATE TABLE T (A TIMESTAMP,
B NUMERIC(0, 9) COMPUTED BY (NULL));


/* Computed fields */


ALTER TABLE T 
ALTER B TYPE NUMERIC(0, 9) COMPUTED BY (current_timestamp - a);


-


Note the type of Column B defined as *NUMERIC(0,9)*


if you run it on isql you will get:
-
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'test2.fdb' PAGE_SIZE 8192 DEFAULT CHARACTER SET NONE;
SQL>
SQL>
SQL> COMMIT WORK;
SQL>
SQL> /* Table: T, Owner: SYSDBA */
SQL> CREATE TABLE T (A TIMESTAMP,
CON> B NUMERIC(0, 9) COMPUTED BY (NULL));
Statement failed, SQLSTATE = HY104
Dynamic SQL Error
-SQL error code = -842
-Precision must be from 1 to 18
SQL>
SQL> /* Computed fields */
SQL>
SQL> ALTER TABLE T
CON> ALTER B TYPE NUMERIC(0, 9) COMPUTED BY (current_timestamp - a);
Statement failed, SQLSTATE = HY104
Dynamic SQL Error
-SQL error code = -842
-Precision must be from 1 to 18
SQL>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5162) SEC$ tables and tag/attributes

[Carlos H. Cantu (JIRA)]

SEC$ tables and tag/attributes
--

 Key: CORE-5162
 URL: http://tracker.firebirdsql.org/browse/CORE-5162
 Project: Firebird Core
  Issue Type: Bug
  Components: Engine
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu


FB 3 allows to have users with the same name, if they are created by different 
plugins. But if you set a tag/attribute to the user A with plugin SRP, this 
tag/attribute stay visible to  user A of LegacyAuth plugin, when you select 
from the sec$ virtual tables.
PS: Initial report by Ann Harrison.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5129) FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected

[Carlos H. Cantu (JIRA)]

FB 3 RC2 installer is displaying "empty texts" when Portuguese is selected
--

 Key: CORE-5129
 URL: http://tracker.firebirdsql.org/browse/CORE-5129
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 3.0 RC2
Reporter: Carlos H. Cantu


When Portuguese (Portugal) is choose during installation, installer is not 
displaying the text (docs) in two screens:
1) Screen right after the license (supposed to display installation_readme.txt)
2) Screen after the files are copied (content should be the readme.txt, = 
leia-me.txt)
In previous versions, the installer displayed the contents in English (since no 
portuguese translation was available). I suggest to do the same with FB 3 
installer.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

[Carlos H. Cantu]

>> Anyway, my point is just to show that those 2 systems can still be
>> widely used in some parts of the world, and this should be taken into
>> the math when taking any decision.

JČ> Just out of curiosity. Are these systems going to be upgraded to
JČ> Firebird 4?

You need to ask the Oracle :)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br




--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

[Carlos H. Cantu]

MR> Let me make my position clear: I don't see the need to support a 14
MR> year old OS that has had no updates (including security updates) since
MR> April 2014. If you're in business with such systems, you are operating
MR> irresponsibly and I see no need to support such behavior. Also if you 
MR> are using such outdated systems, how likely is that you update to a 
MR> newer Firebird version; I think that is unlikely, so again why would we
MR> need or want to support that.

When you say "you", I hope you are referring the message reader, and
not myself, since I don't use XP or Win2003, but I have a Firebird
dedicated portal with +72.000 registered people and I can assure you
that those 2 systems are still being used in Brazil (who, btw, has the
biggest Firebird user base in the world). So, I'm here just to show
the scenario, not to fight for my personal needs (specially when they
do not apply in this case).

About outdated, insecure environments, you have no idea about what you
can find here, and I will not even speak about this :D

Anyway, my point is just to show that those 2 systems can still be
widely used in some parts of the world, and this should be taken into
the math when taking any decision.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

[Carlos H. Cantu]

>> However, I seriously question the need to support Windows XP and
>> Windows Server 2003 for Firebird 4.

LS> I completely agree!
LS> There comes a time when some OSs/installs need to be recognized as *legacy*.
LS> Systems based on those platforms need to recognize that they
LS> can't be running the latest/greatest software.  In the FB case, v3
LS> will still run on/be supported for those platforms for several more years.
LS> Sean


Afaiu, there is a problem with some specific version of MSVC that
generate code that doesn't work on WinXP/2003 so, you guys are now
talking about dropping support to such Windows versions, so this
compiler could be used.

Question: Does this problem would also affect the compiled client
library? Or do you guys also think nobody using Win XP/2003 will needs
to connect to Firebird? 

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Adding firebird.pas to windows build

[Carlos H. Cantu]

Currently Firebird.pas can be found only in the linux builds.
That's what Alex is talking about. It should be on Windows builds too.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

NSG> Alex Peshkoff a écrit :
>> Taking into an account that pascal interface appears to be stable enough 
>> and people start to experiment with it I suggest to add build of that 
>> unit to windows build and package it in windows packages. For linux this 
>> unit is built (using cloop) and placed into binary package.
>>
>> Alex,

NSG> Hi,

NSG> Program create;

NSG> uses Sysutils, Firebird;  <-- Firebird unit ??? Where can you find it?

NSG> var
NSG> .


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Adding firebird.pas to windows build

[Carlos H. Cantu]

+1

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AP> Taking into an account that pascal interface appears to be stable enough
AP> and people start to experiment with it I suggest to add build of that 
AP> unit to windows build and package it in windows packages. For linux this
AP> unit is built (using cloop) and placed into binary package.

AP> Alex,


--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5068) gbak with invalid parameter crashes FB

[Carlos H. Cantu (JIRA)]

gbak with invalid parameter crashes FB
--

 Key: CORE-5068
 URL: http://tracker.firebirdsql.org/browse/CORE-5068
 Project: Firebird Core
  Issue Type: Bug
Affects Versions: 2.5.5
Reporter: Carlos H. Cantu


Typo in gbak's command line parameter causes Firebird process to crash, ie:

gbak -c -v -se service_mgr -user_all_space d:\backup.gbk d:\bd.fdb
gbak:unknown switch "USER_ALL_SPACE"
gbak: ERROR:connection lost to database
gbak:Exiting before completion due to errors


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Literals in CASE expression

[Carlos H. Cantu]

I start wondering if nowadays, saying that a RDBMS "complies to the SQL
Standard" is seem by the users as a "plus".

Most of the time, I saw this as a good way to say: "Ok, Firebird is
Standard compliant, so you can move easily from another RDBMS to it".
But seems that all the others RDBMS don't care much about following
the SQL Standard, so I wonder if trying to follow it is of any good
nowadays.

Regarding your suggestion, I would vote for using VARCHAR too.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

PC> Hi all,

PC> We have an annoying little problem. The visible manifestation is that 
PC> literals in CASE expressions could be padded with spaces.

PC> Here is simplified example:

PC> set term ^;
PC> create procedure tmp_sp(pParam integer)
PC> returns (selectionIf varchar(40), selectionCase varchar(40))
PC> as
PC>declare variable color varchar(10);
PC> begin
PC>if (pParam=1) then color='red';
PC>else if (pParam=2) then color='yellow';
PC>selectionIf='You have selected '||:color||' bag';

PC>color=case :pParam when 1 then 'red' when 2 then 'yellow' end;
PC>selectionCase='You have selected '||:color||' bag';
PC>suspend;
PC> end
PC> ^
PC> set term ;^

PC> select * from tmp_sp(1);

PC> SELECTIONIF SELECTIONCASE
PC> === 
PC> You have selected red bag   You have selected redbag

PC> drop procedure tmp_sp;
PC> commit;

PC> ---

PC> Padding with spaces is not a bug! Spaces are there because string 
PC> literals are CHARs, NOT VARCHARs. This is required by SQL standard.

PC> Relevant except from SQL standard:

PC> 5 Lexical elements

PC> 5.3 
PC> Syntax Rules
PC> ...
PC> 15) The declared type of a  is fixed-length
PC> character string. The length of a  is the
PC> number of s that it contains.

PC> ...

PC> 6 Scalar expressions

PC> 6.11 
PC> Syntax Rules
PC> ...
PC> 7) The declared type of a  is determined by applying
PC> Subclause 9.3, ‘‘Data types of results of aggregations’’, to the declared
PC> types of all s in the .


PC> 9 Additional common rules

PC> 9.3 Data types of results of aggregations
PC> Syntax Rules
PC> ...
PC> 3) Case:
PC> a) If any of the data types in DTS is character string, then:
PC> ...
PC> iii) Case:
PC> 1) If any of the data types in DTS is character large object string,
PC> then the result data type is character large object string with
PC> maximum length in characters equal to the maximum of the lengths in
PC> characters and maximum lengths in characters of the data types in DTS.

PC> 2) If any of the data types in DTS is variable-length character string,
PC> then the result data type is variable-length character string with
PC> maximum length in characters equal to the maximum of the lengths in
PC> characters and maximum lengths in characters of the data types in DTS.

PC> 3) Otherwise, the result data type is fixed-length character string with
PC> length in characters equal to the maximum of the lengths in characters
PC> of the data types in DTS.

PC> 

PC> To sum it up, standard dictates that literals are CHARs, aggregated 
PC> values has length of longest one and because CHARs are padded with 
PC> spaces to declared length, we have such stupid output in CASE. Sure, it
PC> could be easily "fixed" with CAST or TRIM, but it's extremely annoying
PC> to do so. And if there is any real world case when CHAR is the right 
PC> type for literals and VARCHAR the wrong one, I can't see it and would be
PC> glad to be enlightened by someone else.

PC> You may ask why I'm raising this issue here when Firebird's policy is to
PC> follow SQL standard whenever possible (even with stupid requirements),
PC> so annoying or not, we have to live with it. BUT... other databases are
PC> not so strict here, break the stupid standard requirement and use 
PC> VARCHAR instead CHAR, for example:

PC> MS SQLServer 2012:

PC> SELECT 'a'+case 1 when 1 then '1 ' when 2 then '222' end+'b' 
PC> FROM [SCM].[dbo].[SERVERID]
PC> 
PC> a1 b
PC> (1 row(s) affected)


PC> mySQL 5.6:

PC> select concat('a', case 1 when 1 then '1 ' when 2 then '222' 
PC> end, 'b') from tmp;
PC> | concat('a', case 1 when 1 then '1 ' when 2 then '222' end, 'b') |
PC> |---|
PC> |  a1 b |


PC> oracle (not sure which version, provided by sqlZoo.net):

PC> SELECT 'a'||case 1 when 1 then '1 ' when 2 then '222' end||'b'
PC> FROM world
PC> 'A'||CASE1WHE..
PC> a1 b
PC> ...


PC> PostgreSQL (not sure which version, provided by sqlZoo.net):

PC> select concat('a', case 1 when 1 then '1 ' when 2 then '222' 
PC> end, 'b') from   world
PC> concat
PC> a1 b
PC> ...


PC> db2 (not sure which version, provided by sqlZoo.net):

PC> SELECT 'a'||case 1 when 1 then '1 ' when 2 then '222' end||'b'
PC> FROM world
PC> 1
PC> a1 b
PC> ...


PC> So Firebird stands

Re: [Firebird-devel] march switch in posix build for x86 architecture

[Carlos H. Cantu]

DS> 29.12.2015 21:37, James Starkey wrote:
>> Why?   For all practical purposes they're the same architecture.  There is 
>> no upside to
>> the project and only down side for users.

DS>Using of i386 command set limits optimization possibilities for 
compilers.
DS>And, frankly, can you imagine that nowadays someone run database server 
on Intel
DS> Pentium or AMD K5?

Let's try to see the case from another angle:

On Windows, Firebird 3.0 uses VC 2010 runtime. From MS site, the
minimum requirements of this runtime are:

Windows XP SP3 (SP3 was released in 2008) 
Computer with 900 MHz or faster processor
128 MB RAM

In 2008, there was still new Celerons, Athlons, Pentiums, etc. being
released:
http://www.cpu-world.com/Releases/Desktop_CPU_releases_(2008).html

So, personally speaking, I would not install Firebird 3 in a Pentium,
but probably there are such environments still being used in
"micro-business", like very small shop, bar, etc. specially in "third
world" countries (don't ask me if they will upgrade to FB 3). Probably
this scenario is even more common if you look at Linux instead of
Windows, since it was always more capable of running in limited/cheap
hardware.

Anyway, I think the real question is: how much performance increase
this would bring, in real world environment? Do you have this number?
If you tell me +25%, I would vote to drop i386 support :)

[]s
Carlos H. Cantu
www.FireBase.com.br - www.firebirdnews.org
www.warmboot.com.br - blog.firebase.com.br


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5053) changeServerMode.sh can mess with configuration

[Carlos H. Cantu (JIRA)]

changeServerMode.sh can mess with configuration
---

 Key: CORE-5053
 URL: http://tracker.firebirdsql.org/browse/CORE-5053
 Project: Firebird Core
  Issue Type: Bug
  Components: Installation
Affects Versions: 3.0 RC2
 Environment: Linux Ubuntu 14.04 and 15.03
Reporter: Carlos H. Cantu
Priority: Critical


When trying to change a fresh installed Firebird 3.0 RC1 in a Gnome Linux 
Ubuntu (both 14.04 and 15.03) virtual machine (downloaded from osboxes.org), it 
fails or just behave incorrectly:

With GUbuntu 15.03 - script fails (error: 1560: [: classic: unexpected operator)
With GUbuntu 14.04 - script runs with no errors, but incorrectly sets the 
servermode parameter (ie: I asked for classic, but it set as super)... maybe it 
mess with other things too.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird #.## msg file

[Carlos H. Cantu]

>> PS: I do not code in C/C++, so I participate in this list mostly as a 
>> listener.

AP> It's SQL - not C ;)

I was speaking "generally", justifying why he should not direct his doubts
to me in fb-devel ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

>> select 1.0 / 1.00 from rdb$database

DY> I suppose this particular case (and maybe some others of the same kind)
DY> can be worked around. Perhaps we could truncate intermediate results to
DY> fit the maximum supported bitness if and only if the trailing bytes are
DY> insignificant zeroes.

DY> But I really doubt this would be enough as a generic solution.

Agreed. It may help in some cases, but will not help in the case where
all members of the equation are fields or variables.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird #.## msg file

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird #.## msg file


Mario,

I'll let any core developer to answer you, since I don't know the reason for the two files.

PS: I do not code in C/C++, so I participate in this list mostly as a listener. So, directing your messages to me, here, probably is not a good idea ;-)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Cantu

I already downloded the sources from the link you provided. I went to the  src/msgs folder, and i found  2 transmsg_fr_FR.sql and  transmsg_fr_FR2.sql, for example.
As far as i realiseThey are diferente files and abou diferente messages.
I copy them to the transmsg_pt_PT.sql and  transmsg_pt_PT2.sql and start the job. It w'll take a while.
However i'de like to understand why 2 files? Don't they correspond to a unique msg file?
Best regards

Atentamente

Com os meus melhores cumprimentos
O Secretário Geral da ACRA
Mário Agostinho  Reis

Esta mensagem contém informação de natureza confidencial e é
exclusivamente dirigida ao(s) destinatário(s) indicado(s). Se, por engano,
receber este email agradecemos que não o copie nem o reenvie e que nos
notifique do ocorrido através do email de resposta.

No dia 7 de dezembro de 2015 às 00:05, Carlos H. Cantu <lis...@warmboot.com.br> escreveu:
Mario,

You can download FB source here:
https://sourceforge.net/p/firebird/code/HEAD/tree/ 

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Cantu,

Na minha opinião, traduz-se o ficheiro. mostrei-me disponivel para participar.
Quem quiser e achar que ajuda, usa-o que não quiser não usa.
É verdade que os utilizadores não sabem o que é uma FK mas certamente já ouviram falar de uma chave estrangeira
e que é a forma como no ficheiro de moradas validam se certo código postal existe ou não na tabela de codigos postais e bem assim em todas as tabelas de referencia.
A questão que coloquei é de onde posso baixar as sources do Firebird.


Atentamente

Com os meus melhores cumprimentos
O Secretário Geral da ACRA
Mário Agostinho  Reis

Esta mensagem contém informação de natureza confidencial e é
exclusivamente dirigida ao(s) destinatário(s) indicado(s). Se, por engano,
receber este email agradecemos que não o copie nem o reenvie e que nos
notifique do ocorrido através do email de resposta.

2015-12-06 23:01 GMT-01:00 Carlos H. Cantu <lis...@warmboot.com.br>:
DK> As you said, errors from firebird.msg understandable by developers,
DK> not users. For example, what purpose of localized
DK> "foreign key violation" error, if user anyway do not understand
DK> what is "foreign key" in any language?

http://tracker.firebirdsql.org/browse/CORE-736

This ticket is around since 2003... I hope it will be implemented
sometime.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel






--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

MR> The SQL Standard - intentionally - does not specify behavior for
MR> division. When dialect 3 was implemented, Borland opted to use the same
MR> rules as the SQL standard specifies for multiplication.

Thanks Borland 

MR> I'm not so sure this is so easy to do. You either have additional space
MR> requirements for the calculation, or you lose precision by converting to
MR> a double precision for intermediary results.

I'm sure there is no easy solution, otherwise, it would probably be
already implemented.

MR> I don't think we should introduce yet another configuration option for
MR> backwards compatibility, nor have the parser apply some fuzzy logic 
MR> which will only lead to hard to diagnose bugs.

I'm hearing...

MR> I'd prefer if anything is changed, this is not done without resorting
MR> hackish solutions that will just create another set of confusion, but 
MR> instead by using generally accepted arbitrary precision decimal 
MR> calculation rules from standards like ANSI X3.274-1996 or IEEE 754R, or
MR> alternatively by looking at what Java's BigDecimal does, or maybe what
MR> other database engines do (although there it seems as confusing as with
MR> Firebird).

Idea is to discuss available solutions to find the better (possible to
be implemented) one. I never imposed any solution, and I'm sure it
will not be me who will hit the hammer. I leave this for the core
developers.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

SS> OK, can you make example how engine (with you extension) will handle this:

SS> select 1.0 / 1.00 from rdb$database
SS> select 0.1 / 9.00 from rdb$database
SS> select 1.1 / 0.01 from rdb$database

There is no such thing like "my extension". I point out a problem to
see what people think and to see suggestions about how to solve it. I
didn't propose a complete solution, nor a way to implement it, just
throw some ideas in the air, in the hope that discussion will lead to
a good solution. The link sent by Geoff can be a good starting point
for implementation.

SS> I don't understand your situation from practical point of view.
SS> If you can accept losses during computing, why can't you accept DOUBLE
SS> PRECISION?

Because I need accuracy in the stored data, something that double
precision doesn't guarantee. Fields are declared as numeric/decimal,
and I don't think casting all the formulas is an elegant solution. I
also cannot agree that FB just refuses to do a calculation because the
sum of the member's scales is higher than 18. If the result of the
calculation is being stored in a numeric/decimal field/variable, it
already tells how many digits the user really cares about in the
result.


[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

SS> Yes, but now you have to told to FB explicitly which part of number have
SS> to be discarded.

And you still could do this, as you wish :) You remain with full
control, if/when you prefer to have it. I guess the proposed
enhancement will be useful for 99% of the cases, when user don't care
about loosing some accuracy in the middle of the calculation, but
still cares about accuracy of stored data (what you store is exactly
what you get when you retrieve it). For the other 1%, user still has
full control doing his own casts as desired.

SS> Can you give me real example with decimal casting?

What do you mean?

SS> The final solution will be support for high precision arithmetics.
SS> https://en.wikipedia.org/wiki/Arbitrary-precision_arithmetic

Maybe. But will someone implement it in Firebird? A proposed solution
becomes a solution only if it gets implemented, otherwise, it is
just a nice theory.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

SS> I have several points against this idea:

You opinion is welcome :)

SS> 1. Decimal or Numeric is used for to keep exact accuracy.
SS>If you don't need this accuracy use float point data types.

You didn't get the point. There is no loss of accuracy. The data types
will continue working as is. Remember, as I said, today you already have to cast
if you want to make the formula work, so, you are already "loosing"
digits.


SS> 2. System that will produce unpredictable results in math is really hard
SS> to use.
SS>   Some numbers will rounded, truncated or modified.
SS>   There will lot of risk in financial calculation because real result
SS> will depend
SS>   on server config.

What risks? As I said, currently formulas will keep working in the
exact same way. About server config, personally, I think that
parameter is not needed.

SS>  From my point of view, this auto casting will generate more problems 
SS> than helps.

Do you have a better solution for the proposed problem?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Enhancement for numbers calculations

[Carlos H. Cantu]

I know there are plans to support long numbers in Firebird. I have no
idea what is the schedule for its implementation or how much this
subject has been discussed before. Anyway, this email is not to
discuss long numbers implementation, although the subject can be more
or less related.

I want to discuss an implementation/enhancement to avoid "unnecessary"
overflow errors with calculations using currently exact types
(numeric, decimal - dialect 3).

With currently logic, the result of multiplications or divisions will
have Scale = Sum of the scale of its members. This cause nonsense
situations like the following:

select 1.0 / 1.00 from rdb$database

resulting in:
Arithmetic overflow or division by zero has occurred. arithmetic
exception, numeric overflow, or string truncation. numeric value is
out of range.

Even if currently logic is defined by the SQL Standard, for the end
user, this is usually a pain.

My suggestion is to implement a "smarter" logic to be used in
calculations, to avoid such glitches whenever it is possible, without
the need to create new data types.

In short, the idea would be: do the calculation without worrying about
scale limits, and cast the final result to fit in the desired data
type.

At a first though, I would propose that for the internal calculation
(meaning Firebird doing its internal math to give the formula result),
it should not limit the scale at all. Use the maximum possible scale
(cast/round/truncate when needed), or maybe use an IEEE format in the
intermediate calcs, to avoid overflow errors due to scale limit being
reached. If final value generated a scale that cannot fit in the
desired field/variable data type, it will be automatically casted to
it.

For those afraid of "legacy" formulas starting to return different
results, the parser can be smart enough to apply new logic only when
needed, otherwise it would use the old (currently) logic. For
"paranoics", there could be even a parameter in fb.conf to disable new
logic at all (although, personally, I don't think this is needed).

Currently users already need to use "workarounds" to be able to work
with those situations, meaning that some degree of accuracy is already
being lost. Usually, they will split the formula in "groups" and use
casts. Those "legacy" formulas would still work as designed, producing
the same result, since parser would use old logic.

Comments? Ideas? Suggestions? Bashing? :)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird #.## msg file

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird #.## msg file


Mario,

You can download FB source here:
https://sourceforge.net/p/firebird/code/HEAD/tree/ 

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Cantu,

Na minha opinião, traduz-se o ficheiro. mostrei-me disponivel para participar.
Quem quiser e achar que ajuda, usa-o que não quiser não usa.
É verdade que os utilizadores não sabem o que é uma FK mas certamente já ouviram falar de uma chave estrangeira
e que é a forma como no ficheiro de moradas validam se certo código postal existe ou não na tabela de codigos postais e bem assim em todas as tabelas de referencia.
A questão que coloquei é de onde posso baixar as sources do Firebird.


Atentamente

Com os meus melhores cumprimentos
O Secretário Geral da ACRA
Mário Agostinho  Reis

Esta mensagem contém informação de natureza confidencial e é
exclusivamente dirigida ao(s) destinatário(s) indicado(s). Se, por engano,
receber este email agradecemos que não o copie nem o reenvie e que nos
notifique do ocorrido através do email de resposta.

2015-12-06 23:01 GMT-01:00 Carlos H. Cantu <lis...@warmboot.com.br>:
DK> As you said, errors from firebird.msg understandable by developers,
DK> not users. For example, what purpose of localized
DK> "foreign key violation" error, if user anyway do not understand
DK> what is "foreign key" in any language?

http://tracker.firebirdsql.org/browse/CORE-736

This ticket is around since 2003... I hope it will be implemented
sometime.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird #.## msg file

[Carlos H. Cantu]

DK> As you said, errors from firebird.msg understandable by developers,
DK> not users. For example, what purpose of localized
DK> "foreign key violation" error, if user anyway do not understand
DK> what is "foreign key" in any language?

http://tracker.firebirdsql.org/browse/CORE-736

This ticket is around since 2003... I hope it will be implemented
sometime.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB 3 installer - survey results

[Carlos H. Cantu]

Since my first attempt to send this to the list failed due to attached
file being "too big", I'm posting again, this time, with a link to the
PDF:

I ran a survey for 2 weeks, asking people about some aspects of the FB
3 installer.

Purpose was to help Paul Reeves about what people expect from the
Windows installation process, specially regarding fbclient location,
control panel applet, etc.

The result of the survey, that got almost 500 participants, can be
seen here: http://www.firebirdnews.org/fb-3-installer-survey-results/

I hope it helps! Enjoy!

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5021) Extend the "update conflict" message

[Carlos H. Cantu (JIRA)]

Extend the "update conflict" message


 Key: CORE-5021
 URL: http://tracker.firebirdsql.org/browse/CORE-5021
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Reporter: Carlos H. Cantu


Currently only the conflicting transaction number is reported. If would be nice 
if there was some way to know in what table the update conflict happened.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] On-disk Encryption

[Carlos H. Cantu]

Title: Re: [Firebird-devel] On-disk Encryption






I'm curious about how important people consider on-disk encryption to be.  I have two questions.

First question: On a scale from 1 (don't care, wouldn't use it) to 5 (I need it yesterday) how important to us is the ability to encrypt database files.  Assume a bobust encryption scheme and a moderately civilized key management system.  Please feel free to explain your answer either way.



Judging by all the comments I have been hearing in the past years from FB users, who are afraid of having data stolen because SYSDBA (from another server installation) is be able to access anything in the database file, 5.





Second question: If you would consider in-disk database encryption, on a scale of 1 to 5 how important is unattended startup, i.e. no human to enter a password, given that it's probably impossible to make such a system robustly secure?



5

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Windows snapshots builds broken?

[Carlos H. Cantu]

The last snapshot build for Windows is dated 16-July.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3, execution modes

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Firebird 3, execution modes


Btw, seems that firebird.conf from today's snapshot doesn't has SharedCache and SharedDatabase parameters anymore. Instead, you will find just a new parameters name "ServerMode".

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Reading the excellent (as usual) document of Helen Borrie: Firebird 3.0 Release Notes (for Firebird 3.0 Beta 2) I have some doubts:

First, it says that for choicing the working modes (models) I need to put values 0 or 1 at SharedCache and SharedDatabase. Ok with that.

But then it says that the execution modes depends (on Windows) of a -m switch.

So, really if I want a determinated working mode I need to do 2 things:
1. Execute FIREBIRD.EXE with or without the -m switch
2. Put values at the entries SharedCache and SharedDatabase

¿Am I right?

Besides it, if I want Database1 using Classic and Database2 using SuperClassic, it is impossible with just one instance of FIREBIRD.EXE

¿Am I right?

Greetings.





--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

DY>> It was already explained:
DY>> gsec -add sysdba -pw masterkey -user sysdba

I just downloaded today's Win32 FB 3 snapshot
(Firebird-3.0.0.31940-0_Win32.7z) and extracted it to an empty
directory.

When I try "gsec -add sysdba -pw masterkey -user sysdba" (no Firebird
process running), the command prompt never return.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

DY> 12.07.2015 04:19, Carlos H. Cantu wrote:
>>
>> Ok, I tried it with lastest snapshot. It works if I start firebird.exe
>> with -a, but it fails if I start it with -a -m:

DY> It should be run with Firebird being *not started*.

I hope next release notes will have all this information ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

DY> 12.07.2015 04:19, Carlos H. Cantu wrote:
>>
>> Ok, I tried it with lastest snapshot. It works if I start firebird.exe
>> with -a, but it fails if I start it with -a -m:

DY> It should be run with Firebird being *not started*.

I hope next release notes will have all this information ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

DY>> It was already explained:
DY>> gsec -add sysdba -pw masterkey -user sysdba

Ok, I tried it with lastest snapshot. It works if I start firebird.exe
with -a, but it fails if I start it with -a -m:

C:\test\fb3>firebird -a -m
C:\test\fb3>gsec -add sysdba -pw masterkey -user sysdba
unable to open database
I/O error during "CreateFile (open)" operation for file 
"C:\TEST\FB3\SECURITY3.FDB"
Error while trying to open file
The process cannot access the file because it is being used by another process.

Is this expected?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

DY> It was already explained:
DY> gsec -add sysdba -pw masterkey -user sysdba

DY> Looks weird but works.

Should be in release notes at last. I'll try it later.

What about the other errors I listed? Are all of them related to the
fact that I wasn't using the above syntax?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Problems with fresh install and gsec

[Carlos H. Cantu]

I'm trying to test FB 3 Beta2... using the zip-kit and also the
installer of Beta2, since both gave me problems due to missing
\programdata\firebird directory.

This machine is a remote Win2008R2, and seems that never had FB
running before.

Installing currently snapshot (31931) is showing the following error:

C:\test\fb3>firebird -a -m

C:\test\fb3>gsec
*** gsec is deprecated, will be removed soon ***

GSEC> display
Install incomplete, please read the Compatibility chapter in the release notes 
for this version
GSEC> add sysdba -pw masterkey
An error occurred while attempting to add the user.
unsuccessful metadata update
CREATE TABLE PLG$SRP failed
There is no privilege for this operation
GSEC> quit

This was an attempt to reproduce previous errors that I had in the
previous attempts, like:

GSEC> display
Install incomplete, please read the Compatibility chapter in the release notes 
for this version
GSEC> quit; <- typo
invalid switch specified
error in switch specifications
GSEC> add SYSDBA -pw masterkey
GSEC> quit; <- typo
invalid switch specified
error in switch specifications
GSEC> display < prompt never returned after this, and I had to kill 
firebird.exe

and another one:

C:\test\fb3>gsec
*** gsec is deprecated, will be removed soon ***
GSEC> display
unable to open database
I/O error during "CreateFile (open)" operation for file 
"C:\TEST\FB3\SECURITY3.FDB"
Error while trying to open file
The process cannot access the file because it is being used by another process.

and another one:

C:\test\fb3>gsec -database localhost:c:\test\fb3\security3.fdb
use gsec -? to get help
Client attempted to attach unencrypted but wire encryption is required
unable to open database


I wonder how many people is actually testing FB 3 Beta2, since I
didn't see any discussions in lists about the problem with missing
ProgramData\Firebird directory (that makes users unable to go ahead
and do any other tests).

IMHO, Beta2 should be repacked and re-released asap, otherwise, people
will just quit testing after initial frustration.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Learning the wire protocol

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Learning the wire protocol


I can't help with this, but I know that the .NET provider and Jaybird are pure drivers (don't depend on fbclient), so if you understand Java or C#, you can take a look at their code and try to help from them.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br






Hello,

I'm looking at the wire protocol because I'd like to create a client library for PureBasic that doesn't require any middleware. Unfortunately the documentation looks a little sparse and even though I've downloaded protocol.h my limited understanding of C means I still need help. I hope some of you wont mind helping me with my newbie questions.

My first step is simply to try to connect, disconnect and read any confirmation/errors from the server's response.

My first question concerns the Indentification call and in particular the Database Path string, would I be right in thinking that should be a null terminated ascii string?

Then we have the user identification buffer, can I just skip that and include the user data in the following Attachment call?

Then we move on to the Attachment call and in particular the Database Parameter Buffer.

Once again are the database name, user name and password ascii strings? Would I be right in thinking the data to be added to the buffer would be formatted like this (hopefully PureBasic's syntax is so easy you'll get this even if you don't know PureBasic):

nLength = StringByteLength(myPassword$,#PB_Ascii)
*buffer = AllocateMemory(nLength + 2)
PokeS(*buffer,Chr(#isc_dpb_password),1,#PB_Ascii)
PokeS(*buffer,Chr(nLength),1,#PB_Ascii)
PokeS(*buffer,myPassword$,nLength,#PB_Ascii)

Obviously this is cut down and I'd need to include database, user name, etc... in the buffer but I really just want to know if I'm on the right track.

Thanks for any help you can offer (and I'm afraid I'll likely be back with more questions when I get to statements).

Steve.





--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Matéria sobre portarias virtuais

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Matéria sobre portarias virtuais


Ops, yep, sorry for that ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





wrong list i guess :)





--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SFFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Matéria sobre portarias virtuais

[Carlos H. Cantu]

Segue matéria do MaisVocê sobre Portarias Virtuais:

http://globotv.globo.com/rede-globo/mais-voce/v/condominios-passam-a-aderir-ao-servico-de-portaria-a-distancia/4091798/

A empresa mostrada na reportagem é essa aqui:
http://www.betronic.com

Para o futuro, se decidirmos controlar o acesso da entrada principal,
creio que devemos estudar essa possibilidade.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Commits visible in our main page.

[Carlos H. Cantu]

DS>May be something like SF statistics "XX commits last week" could be 
enough?..

Looks good too. I think the web designer may decide what fits better
the currently layout.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Commits visible in our main page.

[Carlos H. Cantu]

I agree that it would help to make people aware that something is
happening behind the scenes, but I think the content must be short,
for example, showing only the last 5 commits (with its dates, and
titles trimmed when need). Clicking in a link could send the visitor
the the full sourceforge list of commits.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

CVC> People, maybe you're going to say that this would be ugly, but at
CVC> www.firebirdsql.org 
CVC> after the PROJECT NEWS I would like to see information about latest 
commits,
CVC> maybe this whole page inside a frame:
CVC> http://sourceforge.net/p/firebird/code/commit_browser

CVC> While some readers may feel it's too nerdy, I think it's of utmost
CVC> importance to show the project is alive. Currently we are like the magma: 
we
CVC> are moving but under the surface... then nobody cares and a lot of people
CVC> think the project stagnated years ago.

CVC> C.
CVC> ---
CVC> Claudio Valderrama C.
CVC> Consultant, SW developer.


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

What I meant is that the reaction for the event is at the client.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

DS> 27.02.2015 15:08, Carlos H. Cantu wrote:
>> Firebird events needs a listening client.

DS>No. It is not Oracle.


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Proposal of new feature: Event triggers


What I said before is: for that single example that I gave, I could achieve a similar result using currently events implementation, if it could be trusted 100%, but I would consider such solution as a workaround.

If a single client miss the event, the consistency is lost and the solution is useless since it cannot be trusted. All the times that I asked core developers about currently events implementation, the answer was that its implementation is weak. I cannot describe what weak means (I have no knowledge of the source), but I guess the problems that I already faced are related with this weak implementation.

With the new proposed feature, there is no client involved, so no events missed at all, and since everything would be run inside the server, it is much more reliable. But there are other points that would need to be addressed, like the isolation, etc.

PS: I don't use NuoDB ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





No, I don't see.  What you want to do, and you agreed, could be done with the existence ng event mechanism if yiu could figure out why sometimes it appeared that events weren't being delivered.  Instead, your proposing a whole new class of trigger that would require yet another interface, a mechanism to activate and deactivate them, and a secod asynchronous mechanism to modify session variable.

It doesn't sound to me like a generally useful mechanism.  There are lots of ways to implement asynchronous notification that should be explored before undertaking an overhaul of the existing mechanisms.  The one in NuoDB is particularly interesting, and would be a far better solution to your problem.





--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Proposal of new feature: Event triggers


Jim, as I said before, I'm not proposing a substitute for the currently Firebird events. It is a new feature. Of course, if current events implementation is weak and/or bugged, it would be nice to have it improved or fixed, but this is independent of what I'm proposing.

Firebird events needs a listening client. The new feature would not need a client at all.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





Carlos, again, why not figure out why events aren't working at your site.  It is a mechanism designed from the beginning to do what you want, e.g. notify other connections of a database state change.

What you are suggesting will introduce far more problems than it purports to solve.

If there is is a Firebird bug, isolate it so somebody can fix it.  If it is your bug, fix it yourself.

If it's a firewall problem (the original code was written long before firewalls were invented), change re secondary connection mechanism to use the primary port.

On Friday, February 27, 2015, Carlos H. Cantu <lis...@warmboot.com.br> wrote:
AP> And this may play bad jokes from stability POV - imagine having old
AP> values in the beginning of some complex request but new one in the end.

Exactly. I have no idea about how context variables was implemented
internally, but do you think there is a chance to make them respect
the isolation of its transaction when retrieving the values?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AP> On 02/26/15 21:04, Dmitry Yemanov wrote:

>>> But your point raised a doubt here: what is the "isolation" of a
>>> USER_SESSION context variable regarding active snapshot transactions?
>> Context variables are outside the transaction control, so the new values
>> are available immediately.
>>



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel


-- 
Jim Starkey





--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

AP> And this may play bad jokes from stability POV - imagine having old
AP> values in the beginning of some complex request but new one in the end.

Exactly. I have no idea about how context variables was implemented
internally, but do you think there is a chance to make them respect
the isolation of its transaction when retrieving the values?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AP> On 02/26/15 21:04, Dmitry Yemanov wrote:

>>> But your point raised a doubt here: what is the "isolation" of a
>>> USER_SESSION context variable regarding active snapshot transactions?
>> Context variables are outside the transaction control, so the new values
>> are available immediately.
>>



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DY> How fast do you need them to refresh? Immediately is a wrong asnwer, as
DY> events are asynchronous. Is it OK to see outdated context variables for
DY> some [supposedly short but generally unpredictable] time?

Since everything would be done inside the server, I suppose the delay
would be really short, so acceptable.

But your point raised a doubt here: what is the "isolation" of a
USER_SESSION context variable regarding active snapshot transactions?
Would those transactions see the value of the variable as it was when
transaction was started, or the new value?

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DY> Simple test shows that context variables are 2x faster on v2.5 and 4x
DY> faster in v3.0.

Good to know! Thanks for sharing this information.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Proposal of new feature: Event triggers






If there's a bug, the correct response to to fix it, not invent yet another feature to work around the bug.



I never intended the new proposed feature to substitute the currently events mechanism. It would work in a different way, and would avoid the client in the whole process, so it is a complete different beast.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DS>IIRC, tests by Pavel Zotov shown that using of context variables is, 
actually, slower
DS> that reading from a single row table.

If so, I would say something seems to be really wrong.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DS>I can tell you why: a bug in event handling code in your application. It 
took me quite
DS> a few time to realize how event notification works and write event handling 
code properly,
DS> but since then I received only one or two reports about problems with them. 
Nevertheless,
DS> if your application works over Internet, then you are right not using 
events because of
DS> firewall issues.

Maybe it is/was a bug in the way IBO implemented the events listening.
I remember Jason did some recent re-factoring in this area. The
problem is that I never was able to reproduce the problem in my own
environment, so it is hard to test.

Anyway, let's try to not pollute this topic with this subject for now.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Proposal of new feature: Event triggers






Could you describe what you are actually trying to do rather than how a possible solution might work?  It's a lot easier to work from an actual problem than to reverse engineer from a murky proposal.



Hi Jim!

Already did in previous messages ;)

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br




--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

Adriano,

I never measured, but I assume it should be fast, specially if the
page is in the cache. But reading the same thing endless times in a
batch operation looks like a waste of resources. I'm sure reading a
context variable is much simpler/fast than the whole mechanism
involved in running a select.

Please note that I just listed one specific use for such feature. I'm
sure there are others that may not involve just updating context
variables. Others may comment.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AdSF> On 26/02/2015 11:18, Carlos H. Cantu wrote:
>> I'll give you a real example that could justify this need:
>>
>> In my ERP, I store some global configuration data in a config table.
>> In several triggers, I need to keep reading this config table to get
>> some values and use in IF's, etc. For batch operations, triggers will
>> be executed several times. A much better/efficient approach would be
>> to store some of the config data in session context variables, so
>> there would be no need to keep reading the config table every time.
>>
>>
AdSF> Is it really fast?

AdSF> If your config table has a single row with each "variable" as a column,
AdSF> it should be frequently cached.

AdSF> How much you loose reading it directly?


AdSF> Adriano


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DS> 26.02.2015 15:18, Carlos H. Cantu wrote:
>> PS: I could do something similar at the client side, using the
>> currently Firebird events, but unfortunately, they cannot be trusted.

DS>What do you mean?

In my practical experience with the currently implementation of FB
events (I use them for internal messenger in my ERP), it happened
several times that some attachments didn't get notified when the event
was fired. It is like, in the same local network, some machines
received the event and some others not. Don't ask me why.

There is another situation that I had in the past, when registering
interest for events, when the database connection was done by
internet, simply hanged the client forever. For this reason, I had to
disable event listening when the connection is done over Internet. I'm
not sure if this was fixed in recent builds.

In other words: I don't trust the currently event implementation
because it seems that it doesn't work 100% of the time.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br



--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

DY> 26.02.2015 16:55, Adriano dos Santos Fernandes wrote:

>> For example, there is example UDR who waits for an event, blocking the
>> calling.

DY> I don't think Carlos wants to block the caller.

Yep, no blocking at all.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

I'll give you a real example that could justify this need:

In my ERP, I store some global configuration data in a config table.
In several triggers, I need to keep reading this config table to get
some values and use in IF's, etc. For batch operations, triggers will
be executed several times. A much better/efficient approach would be
to store some of the config data in session context variables, so
there would be no need to keep reading the config table every time.

When any user changes some sensitive config data, I would like that
all the attachments to "refresh" its session context variables, to
reflect the new values.

PS: I could do something similar at the client side, using the
currently Firebird events, but unfortunately, they cannot be trusted.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br

AdSF> On 26/02/2015 10:29, Carlos H. Cantu wrote:
>>
>> Those special triggers would be associated to an EVENT, not to a
>> TABLE. When the associated event is fired in any of the active
>> attachments, all the active attachments "interested" in that event
>> would run the trigger.
>>
>>
AdSF> But this intrigues me. Why would you want more than one attachment to
AdSF> respond to an event?

AdSF> Won't they will cause a race condition?


AdSF> Adriano


AdSF> 
--
AdSF> Dive into the World of Parallel Programming The Go Parallel Website, 
sponsored
AdSF> by Intel and developed in partnership with Slashdot Media, is your hub 
for all
AdSF> things parallel software development, from weekly thought leadership 
blogs to
AdSF> news, videos, case studies, tutorials and more. Take a look and join the
AdSF> conversation now. http://goparallel.sourceforge.net/
AdSF> Firebird-Devel mailing list, web interface at
AdSF> https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Proposal of new feature: Event triggers

[Carlos H. Cantu]

I would like to start a discussion to propose the implementation of
"Event triggers" (for the lack of a better name for now).

Those special triggers would be associated to an EVENT, not to a
TABLE. When the associated event is fired in any of the active
attachments, all the active attachments "interested" in that event
would run the trigger.

My personal example of use for such feature, would be to force the
update of global context variables in all active attachments, when
the EVENT is fired.

Of course there are questions to be discussed, for example: the
trigger would ran in what transaction context? Should it be forced to
be ReadOnly (making things simpler, but much more limited)?

This would be for FB 3.x or 4. If you guys thinks this is not the
right moment to talk about it, I can just open a ticket and leave it
in the tracker waiting for the right time.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wire compression and zlib on Windows

[Carlos H. Cantu]

Title: Re: [Firebird-devel] Wire compression and zlib on Windows


Afaik, it will be available starting from Beta 2.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br





How can I enable wire compression? I downloaded Firebird today, and not found any documentation about that (That I can found).
Thanks.





--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Wire compression and zlib on Windows

[Carlos H. Cantu]

AP> What pages? That's about _wire_ compression, not database. It's turned
AP> off by default, and it's supposed that reasonable people use it only for
AP> WAN connections where reducing size (and specially number) of packages
AP> is expected to lead to better performance.

Alex, can we enable/disable this option at DPB/connection level? For
example, I may want to have compression enabled when I'm connecting to
remote database over internet, but keep it disabled when connecting to
local database.

[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel