[Firebird-devel] Backup padding

2020-09-01 Thread Dimitry Sibiryakov
Hello, All. In all Firebird versions up to current backup content is padded up to 512 bytes buffer size but does it have any meaning nowadays? I'm asking because this padding causes a little problem during restore from client side using services and "stdin": logical end of backup comes

Re: [Firebird-devel] [FB4.0] Statement failed when COALESCE(TIMESTAMPCOLUMN, CURRENT_TIMESTAMP)

2020-09-01 Thread Adriano dos Santos Fernandes
On 31/08/2020 15:03, Eliezer Riani wrote: > > Hi, > > > Take a look at these steps (https://snipboard.io/Tzkq47.jpg) that > produces an error like that: > > "Statement failed, SQLSTATE = HY000 > > message length error (encountered 12, expected 16)" > > > I'm looking into this problem. Adriano

[Firebird-devel] [FB-Tracker] Created: (CORE-6397) Message length error with COALESCE and TIME/TIMESTAMP WITHOUT TIME ZONE and WITH TIME ZONE

2020-09-01 Thread Adriano dos Santos Fernandes (JIRA)
Message length error with COALESCE and TIME/TIMESTAMP WITHOUT TIME ZONE and WITH TIME ZONE -- Key: CORE-6397 URL: http://tracker.firebirdsql.org/browse/CORE-6397

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 17:23, Dimitry Sibiryakov wrote: Hello, All.   In all Firebird versions up to current backup content is padded up to 512 bytes buffer size but does it have any meaning nowadays?   I'm asking because this padding causes a little problem during restore from client side using serv

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Dimitry Sibiryakov
01.09.2020 18:15, Alex Peshkoff via Firebird-devel wrote: And what's a  problem with it? Is database restored? Yes. Is gbak service finished? No. Application fall to endless loop on isc_service_query() waiting for data request from server. -- WBR, SD. Firebird-Devel mailing list,

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 19:18, Dimitry Sibiryakov wrote: 01.09.2020 18:15, Alex Peshkoff via Firebird-devel wrote: And what's a  problem with it? Is database restored?   Yes. Is gbak service finished?   No. Application fall to endless loop on isc_service_query() waiting for data request from server

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Vlad Khorsun
01.09.2020 17:23, Dimitry Sibiryakov wrote:   Hello, All.   In all Firebird versions up to current backup content is padded up to 512 bytes buffer size but does it have any meaning nowadays? Sure Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.ne

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Dimitry Sibiryakov
01.09.2020 18:24, Alex Peshkoff via Firebird-devel wrote: Can you send me problematic backup? No backup file exists. This application uses the service this way on both sides. A piece come from one server - the piece is sent to the other. I didn't try hard to reproduce it so far. -- WBR,

Re: [Firebird-devel] [FB4.0] Statement failed when COALESCE(TIMESTAMPCOLUMN, CURRENT_TIMESTAMP)

2020-09-01 Thread Adriano dos Santos Fernandes
On 31/08/2020 15:03, Eliezer Riani wrote: > > Hi, > > > Take a look at these steps (https://snipboard.io/Tzkq47.jpg) that > produces an error like that: > > "Statement failed, SQLSTATE = HY000 > > message length error (encountered 12, expected 16)" > > Fixed: http://tracker.firebirdsql.org/browse/

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 19:34, Dimitry Sibiryakov wrote: 01.09.2020 18:24, Alex Peshkoff via Firebird-devel wrote: Can you send me problematic backup?   No backup file exists. This application uses the service this way on both sides. A piece come from one server - the piece is sent to the other. I did

Re: [Firebird-devel] [FB4.0] Statement failed when COALESCE(TIMESTAMPCOLUMN, CURRENT_TIMESTAMP)

2020-09-01 Thread Eliezer Riani
> Fixed: http://tracker.firebirdsql.org/browse/CORE-6397 Thanks a lot! It's all fine now. Take a look: https://prnt.sc/u9vdls regards, -- Eliezer Riani Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Replication table matcher

2020-09-01 Thread Dimitry Sibiryakov
Hello All. Why is the matcher created for each attachment separately? Isn't one per database enough?.. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel