Re: [Firebird-devel] ODP: FB3.0.1 - Impossible to alter table

2016-10-13 Thread Adriano dos Santos Fernandes
Em 13/10/2016 20:19, Slavomir Skopalik escreveu: > Hi, > > I was tested FB3.0.1 Windows 64 with different result. > > DaviceData is table with several millions of rows. > > alter table DeviceData add a integer default 7 not null; > > This is fast, just few ms. > > But commit was taken several

Re: [Firebird-devel] ODP: FB3.0.1 - Impossible to alter table

2016-10-13 Thread Slavomir Skopalik
Hi, I was tested FB3.0.1 Windows 64 with different result. DaviceData is table with several millions of rows. alter table DeviceData add a integer default 7 not null; This is fast, just few ms. But commit was taken several minutes with high disk activities. Also I made another test. 1. alter

Re: [Firebird-devel] ODP: FB3.0.1 - Impossible to alter table

2016-10-13 Thread Adriano dos Santos Fernandes
Em 13/10/2016 17:39, Slavomir Skopalik escreveu: > Big disadvantages of default is: > > 1. Immediately update all rows in table. > > Interesting only if all or most already existed rows will use this value. > No. DEFAULT is a constant expression and is stored in table metadata and associated wi

Re: [Firebird-devel] ODP: FB3.0.1 - Impossible to alter table

2016-10-13 Thread Slavomir Skopalik
Big disadvantages of default is: 1. Immediately update all rows in table. Interesting only if all or most already existed rows will use this value. 2. Less readable, this is important for me. I prefer this scenario: ALTER TABLE ... ADD null able; COMMIT; UPDATE ... COMMIT; ALTER TABLE ...

Re: [Firebird-devel] ODP: FB3.0.1 - Impossible to alter table

2016-10-13 Thread Jiří Činčura
> 1.add field with "default" Which you can later remove. -- Mgr. Jiří Činčura Independent IT Specialist -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.l

[Firebird-devel] Built error Firebird 3.0.1 Source. win32

2016-10-13 Thread Mueller, Roland (GE87)
Hello i have downloaded Firebird 3.0.1 Source. When i run make_boot.bat there are some Errors. The file: "C:\Programme\Microsoft Visual Studio 9.0\Common7\Tools\\..\..\VC\vcvarsall.bat" x86 has already been executed. Setting Environment Variables thus... vs_ver=msvc9 platf

Re: [Firebird-devel] Code readability

2016-10-13 Thread Alex Peshkoff
On 10/13/16 15:35, Dimitry Sibiryakov wrote: > 13.10.2016 14:28, Alex Peshkoff wrote: >> That's an answer. > Could you explain how difference in one character makes "beautiful and > sensitive" code > "ugly and non-sense"? If you do not understand the simple fact that's clear to others - sorry

Re: [Firebird-devel] Code readability

2016-10-13 Thread Dimitry Sibiryakov
13.10.2016 14:28, Alex Peshkoff wrote: > That's an answer. Could you explain how difference in one character makes "beautiful and sensitive" code "ugly and non-sense"? For me both these lines are ugly. > Rework your patch please. As you wish. -- WBR, SD. ---

Re: [Firebird-devel] Code readability

2016-10-13 Thread Alex Peshkoff
On 10/13/16 15:25, Dimitry Sibiryakov wrote: > 13.10.2016 14:04, Adriano dos Santos Fernandes wrote: >> This line is ugly and non-sense. > That's not an answer to what I asked about. > > That's an answer. Rework your patch please. -

Re: [Firebird-devel] Code readability

2016-10-13 Thread Dimitry Sibiryakov
13.10.2016 14:04, Adriano dos Santos Fernandes wrote: > This line is ugly and non-sense. That's not an answer to what I asked about. -- WBR, SD. -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] Code readability

2016-10-13 Thread Adriano dos Santos Fernandes
On 13/10/2016 07:50, Dimitry Sibiryakov wrote: > Arg::Num(index) << (string("IMessageMetadata::") += method)).copyTo(status); > This line is ugly and non-sense. Adriano -- Check out the vibrant tech community on one

Re: [Firebird-devel] Code readability

2016-10-13 Thread Alex Peshkoff
On 10/13/16 13:50, Dimitry Sibiryakov wrote: > Hello, All. > > Is here a person, who can read and understand this line: > >Arg::Num(index) << (string("IMessageMetadata::") + method)).copyTo(status); > > but cannot understand this line: > >Arg::Num(index) << (string("IMessageMeta

[Firebird-devel] Code readability

2016-10-13 Thread Dimitry Sibiryakov
Hello, All. Is here a person, who can read and understand this line: Arg::Num(index) << (string("IMessageMetadata::") + method)).copyTo(status); but cannot understand this line: Arg::Num(index) << (string("IMessageMetadata::") += method)).copyTo(status); -- WBR, SD. -