Re: [Firebird-devel] (possible) Database header

2022-08-24 Thread Tommi Prami
at 12:14 AM Tommi Prami mailto:tommi.pr...@suonentieto.fi>> wrote: Hello, I was thinking that if there is some kind of header (simple enough) in Firebird Databases and/or backup files, maybe some one could point me into the right direction. I would preferably need (mainly for installer)

Re: [Firebird-devel] (possible) Database header

2022-08-24 Thread Tommi Prami
same to use our own utility, gstat needs client libraries as well as our own, so we do not gain anything. Thanks for info. -Tee- -Original Message- From: Tommi Prami Sent: Wednesday, August 24, 2022 10:21 AM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel

Re: [Firebird-devel] (possible) Database header

2022-08-24 Thread Tommi Prami
Dang... Try to use GStat instead. -Tee- -Original Message- From: Dimitry Sibiryakov Sent: Tuesday, August 23, 2022 1:11 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] (possible) Database header Tommi Prami wrote 23.08.2022 5:40: > I was think

[Firebird-devel] (possible) Database header

2022-08-22 Thread Tommi Prami
Hello, I was thinking that if there is some kind of header (simple enough) in Firebird Databases and/or backup files, maybe some one could point me into the right direction. I would preferably need (mainly for installer) small tool that would check the ODS version of the DB before I try to

[Firebird-devel] [FB-Tracker] Created: (CORE-5709) new Client 2.5.8 to server 2.5.7 server caused problem

2018-01-14 Thread Tommi Prami (JIRA)
: API / Client Library Affects Versions: 2.5.8 Environment: Windows 10 Reporter: Tommi Prami Priority: Minor We accidentally updated 2.5.8 client to environment where is older 2.5.7 server. With field defined as CREATE DOMAIN CMN_BOOLEAN AS SMALLINT

[Firebird-devel] [FB-Tracker] Created: (CORE-5622) Extend SEQUENCE SEQUENSE syntact with CURRENT

2017-09-22 Thread Tommi Prami (JIRA)
Reporter: Tommi Prami Priority: Minor Would be nice to do this SELECT CURRENT VALUE FOR CUSTOMER_SEQUENCE FROM RDB$DATABASE Would be logical (Not sure would it be standard) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly

[Firebird-devel] [FB-Tracker] Created: (CORE-5621) Extend ALTER SEQUENCE syntax with SELECT

2017-09-21 Thread Tommi Prami (JIRA)
Environment: any Reporter: Tommi Prami Priority: Minor ALTER SEQUENCE RESTART WITH (SELECT MAX(ID) FROM CUSTOMER); Sometimes the select is not that start forward, but anyways would do good to be able to fetch new value with select, Would make easier to reset the Sequences

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-20 Thread Tommi Prami
I've said I can provide the DB and needed data if it is kept secret :) -Tee- On Tue, Sep 20, 2016 at 3:55 PM, Vlad Khorsun <hv...@users.sourceforge.net> wrote: > 19.09.2016 14:06, Tommi Prami wrote: > > Weird part was that I actually pumped the data to the empty database a

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-19 Thread Tommi Prami
Weird part was that I actually pumped the data to the empty database and it behaved the same. This is more than less puzzling. And the Backup and restore did not help,. which also, I think, should recreate the indexes and so on... -Tee- On Thu, Sep 15, 2016 at 10:58 AM, Thomas Steinmaurer

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-15 Thread Tommi Prami
2016 9:39, Tommi Prami wrote: > > Foreign key references are present for the record > > Problematic key value is ("TOSITEID" = 945) > > > > Data is there, it can be selected but the delete fails on this DB > >Delete fails exactly because data is there. You m

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-15 Thread Tommi Prami
selected but the delete fails on this DB (Hope this helps) On Thu, Sep 15, 2016 at 10:26 AM, Alex Peshkoff <peshk...@mail.ru> wrote: > On 15.09.2016 10:14, Tommi Prami wrote: > > Whole story here : > > > > https://plus.google.com/105626

[Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-15 Thread Tommi Prami
Whole story here : https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA Copy of message - - - - - - - - - - - - - - - - Is there a tool (or way) to debug database step by step. Now we have weird situation where delete from one database fails, on foreign key error, which sounds

Re: [Firebird-devel] Lock manager's hash calculations

2015-12-29 Thread Tommi Prami
I stumbled upon quite evesome Hash-algorithm xxHash. There are lightning fast implementations. https://github.com/Cyan4973/xxHash Noted that usually the Hash algorithm is not the bottleneck, but still pretty interesting... -Tee- On Tue, Dec 29, 2015 at 6:05 PM, Dimitry Sibiryakov

Re: [Firebird-devel] Crypto Algoritm Performance

2015-09-07 Thread Tommi Prami
The Hardware AES uses differend MAgic constant (Seed?) that many popular software implementations (If I recall, reading from somewhere). So the initial state of non HW accelerated implementation should match the HW one, that's all. PS: Can't remember the details just pumped into this one, that I

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

2015-03-17 Thread Tommi Prami
If you use {$A+} all fields should appear to aligned to 8 byte boundaries (The default). I think would be easier to make it controllable, to use packed record and add some Foo Bar padding variables if needed. If the original structure is continuous then packed record with correct field sizes