Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Pavel Cisar
Hi, May I suggest to add isc_info_* code to query the backup GUID via isc_database_info()? Parsing gstat output for it is very awful. New nbackup switches and options should be also handled by services API. best regards Pavel Cisar IBPhoenix

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Vlad Khorsun
24.03.2016 9:42, Pavel Cisar wrote: > Hi, > > May I suggest to add isc_info_* code to query the backup GUID via > isc_database_info()? Parsing gstat output for it is very awful. I have same idea. I suppose it is better to return GUID in text representation, not binary, agree ? > New nbackup sw

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Dmitry Yemanov
24.03.2016 11:33, Vlad Khorsun wrote: >> May I suggest to add isc_info_* code to query the backup GUID via >> isc_database_info()? Parsing gstat output for it is very awful. > > I have same idea. I suppose it is better to return GUID in text > representation, not binary, agree ? I'm not that sure

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Simonov Denis
Vlad Khorsun wrote Wed, 23 Mar 2016 17:43:23 +0300: > >Let me show how it works. It is very simplified example, of course. > > Create database source.fdb. > > Create level-0 backup, as usual: >nbackup -B 0 source.fdb source-0.nbk > > Restore level-0 backup, as usual: > nbackup -R targ

Re: [Firebird-devel] Firebird.pas for the windows build

2016-03-24 Thread Alex Peshkoff
On 03/23/2016 06:39 PM, preeves wrote: > Firebird.pas is generated in the posix builds but it is not generated > in the windows builds. Posix builds generate it via this target: > > $(API_PAS_FILE): $(IDL_FILE) $(PASCAL_SOURCES) $(TMP_FUNCS) > $(CLOOP) $(IDL_FILE) pascal $@ Firebird --uses Sys

[Firebird-devel] [FB-Tracker] Created: (CORE-5167) Automatic boolean values convertation with string concatenation

2016-03-24 Thread Alex Bekhtin (JIRA)
Automatic boolean values convertation with string concatenation --- Key: CORE-5167 URL: http://tracker.firebirdsql.org/browse/CORE-5167 Project: Firebird Core Issue Type: Bug Af

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Dimitry Sibiryakov
24.03.2016 9:56, Dmitry Yemanov wrote: > I'm not that sure. API is for programmers and it's intended to work with > binary data. Whoever able to call isc_database_info() may easily call > (or implement) a function to format it into text. +1. Especially if nbackup service will accept binary U

Re: [Firebird-devel] Firebird.pas for the windows build

2016-03-24 Thread Adriano dos Santos Fernandes
On 24/03/2016 06:35, Alex Peshkoff wrote: > How are we meant to do this in the windows build? > Paul, I see 2 alternatives. > 1. (correct) Build cloop and execute same command. > Is the Windows guys doing manual editing of the generated file after API changes? Adriano -

[Firebird-devel] [FB-Tracker] Created: (CORE-5168) Computed columns with implicit/explicit datatypes are not distinguishable

2016-03-24 Thread Arioch (JIRA)
Computed columns with implicit/explicit datatypes are not distinguishable - Key: CORE-5168 URL: http://tracker.firebirdsql.org/browse/CORE-5168 Project: Firebird Core Is

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread liviuslivius
Hi, > Implemented *but* stuck due to lack of comments ;-) if no one commented then i suppose you should choose - in your opinion the best choise and apply patch :) I can test this fix. > Are you prepared to lose the ability to migrate back if something goes > wrong? We go only forward ;-) >

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Adriano dos Santos Fernandes
On 08/03/2016 10:02, Dmitry Yemanov wrote: > All, > > The good thing is that the code internals are more or less ready to work > with context/stream number of any size, thanks to Claudio's refactoring. > So the issue is mostly about BLR. > > I see two possible solutions: > > 1) Bump BLR version,

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Dmitry Yemanov
24.03.2016 16:24, Adriano dos Santos Fernandes wrote: > > If we use the new version only when the object actually uses more than > 255 contexts, it's an object that cannot be really migrated backward. It's doable, just with minor tweaks - BLR version tag should be adjusted in-place after the whol

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Adriano dos Santos Fernandes
On 24/03/2016 10:53, Dmitry Yemanov wrote: > 24.03.2016 16:24, Adriano dos Santos Fernandes wrote: >> If we use the new version only when the object actually uses more than >> 255 contexts, it's an object that cannot be really migrated backward. > It's doable, just with minor tweaks - BLR version t

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Jim Starkey
On 3/24/2016 9:24 AM, Adriano dos Santos Fernandes wrote: > On 08/03/2016 10:02, Dmitry Yemanov wrote: >> All, >> >> The good thing is that the code internals are more or less ready to work >> with context/stream number of any size, thanks to Claudio's refactoring. >> So the issue is mostly about B

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Adriano dos Santos Fernandes
On 24/03/2016 11:41, Jim Starkey wrote: > On 3/24/2016 9:24 AM, Adriano dos Santos Fernandes wrote: >> On 08/03/2016 10:02, Dmitry Yemanov wrote: >>> All, >>> >>> The good thing is that the code internals are more or less ready to work >>> with context/stream number of any size, thanks to Claudio's

[Firebird-devel] Visual Studio 2015

2016-03-24 Thread Jim Starkey
Talking advantage of a discounted sale price, I recently bought a notebook to replace my elderly boat computer. Taking advantage of a deeply appreciation observation on this list, I download, among many other things, the "Community" version of Visual Studio 2015, and preceded to move a collect

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Jim Starkey
On 3/24/2016 10:50 AM, Adriano dos Santos Fernandes wrote: >>Creating a new BLR version number doesn't make sense since >> it is hoped that future versions of Firebird will treat BLR as at most a >> legacy interface. >> > So you suggest Java .class go away? Compile source code dynamically and r

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread liviuslivius
>>No, they don't. >>Dmitry Then i must look into Delphi code why this is important regards, Karol Bieniaszewski -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analyti

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Adriano dos Santos Fernandes
On 24/03/2016 13:01, Jim Starkey wrote: > On 3/24/2016 10:50 AM, Adriano dos Santos Fernandes wrote: >>>Creating a new BLR version number doesn't make sense since >>> it is hoped that future versions of Firebird will treat BLR as at most a >>> legacy interface. >>> >> So you suggest Java .class

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Ann Harrison
On Thu, Mar 24, 2016 at 7:52 AM, liviuslivius wrote: > > > I'm not sure I get you here. How number of columns does relate to number > > of contexts? > > > > this is because Array DML(in Delphi) use execute block with parameters > and all parameters/variables are counted as contexts > > PS. after

Re: [Firebird-devel] BLR contexts limit

2016-03-24 Thread Dmitry Yemanov
24.03.2016 14:52, liviuslivius wrote: > > this is because Array DML(in Delphi) use execute block with parameters > and all parameters/variables are counted as contexts No, they don't. Dmitry -- Transform Data into Oppo