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

2015-12-30 Thread Michal Kubecek
On Tue, Dec 29, 2015 at 10:13:26PM -0500, James Starkey wrote: > On Tuesday, December 29, 2015, Michal Kubecek wrote: > > > On Tue, Dec 29, 2015 at 07:43:37PM -0500, James Starkey wrote: > > > Could you explain to us what optimization a are possible on 686 that > > > are not on

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

2015-12-30 Thread Mark Rotteveel
On Tue, 29 Dec 2015 19:43:37 -0500, James Starkey wrote: > Could you explain to us what optimization a are possible on 686 that are > not on the 386? Look at https://en.wikipedia.org/wiki/X86_instruction_listings#Added_with_80486 and go down. Instructions added (not all

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

2015-12-30 Thread Dmitry Yemanov
29.12.2015 19:56, Dimitry Sibiryakov wrote: > > Isn't it a good time to drop support of 20 years old processors and raise > -march value > from i386 to i686? Maybe I'm missing something, but I see in both v2.5 and v3.0: OPTIMIZE_FLAGS=-O3 -march=i586 -mtune=i686 -fno-omit-frame-pointer Dmitry

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

2015-12-30 Thread Mark Rotteveel
On Tue, 29 Dec 2015 22:04:52 -0200, "Carlos H. Cantu" wrote: > 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) >

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

2015-12-30 Thread Dimitry Sibiryakov
30.12.2015 10:26, Dmitry Yemanov wrote: > Maybe I'm missing something, but I see in both v2.5 and v3.0: > > OPTIMIZE_FLAGS=-O3 -march=i586 -mtune=i686 -fno-omit-frame-pointer You are right. I'm sorry. -- WBR, SD.

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

2015-12-30 Thread James Starkey
Putting aside the questions of when these instructions were added, under what circumstances could / would a compiler optimize something with a conditional move (cmov)? The new operations are supported by compiler intrinsics at best, but often require inline assembler. Even now, the cpuid

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

2015-12-30 Thread Dimitry Sibiryakov
29.12.2015 18:16, Dmitry Yemanov wrote: > I didn't speak about Hash.h, but about other three copies that are the same. I have found two: one in HashJoin.cpp and other in lck.cpp. Can't find third one. Where it is? -- WBR, SD.

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

2015-12-30 Thread Dimitry Sibiryakov
30.12.2015 14:43, Dmitry Yemanov wrote: > The first one is in lock.cpp and you've found two others, three in total. Ok, then it is done now. Should I prepare a patch for Firebird 3 or leave it in Avalerion and let you adopt it at will? -- WBR, SD.

[Firebird-devel] [FB-Tracker] Created: (CORE-5058) "ADMIN ROLE" should automatically GRANT ALL PRIVILEGES for DDL

2015-12-30 Thread Lukas Eder (JIRA)
"ADMIN ROLE" should automatically GRANT ALL PRIVILEGES for DDL -- Key: CORE-5058 URL: http://tracker.firebirdsql.org/browse/CORE-5058 Project: Firebird Core Issue Type: Bug

[Firebird-devel] [FB-Tracker] Created: (CORE-5059) BIN_AND() wrong result

2015-12-30 Thread F.D.Castel (JIRA)
BIN_AND() wrong result -- Key: CORE-5059 URL: http://tracker.firebirdsql.org/browse/CORE-5059 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.5 Environment: Windows