Re: [Firebird-devel] icudt52.dll FB3

10.07.2017 11:11, D. Kruise пишет: ... I installed in the exe directory FBclient.dll firebird.msg ib_util.dll icudt52.dll icuin52.dll icuuc52.dll Seems you missed icudt52l.dat. Also, make sure, you used 64-bit DLL's And into subdir intl fbintl.conf fbintl.dll And into subdir plugins

Re: [Firebird-devel] icudt52.dll FB3

Thanks Vlad, Adding icudt52l.dat solved the problem. Flamerobin 32 bit works now on 32 bit and 64 bit windows OS. I think adding icudt52l.dat for embedded use i (only for 64 bit WINDOWS 10 OS) is not well documented but Von: Vlad Khorsun via Firebird-devel

Re: [Firebird-devel] sse3 host x64 linux

It's weird that package from ppa (3.0.2) works LI-V3.0.2.32703 Firebird 3.0 https://launchpad.net/~mapopa/+archive/ubuntu/firebird3.0/+build/12568442 On Mon, Jul 10, 2017 at 5:44 PM, marius adrian popa wrote: > The same it crashes > > On Mon, Jul 10, 2017 at 4:00 PM,

Re: [Firebird-devel] sse3 host x64 linux

gcc 6.3.0 on a modern sse4.2 host here is the build log https://launchpadlibrarian.net/319223134/buildlog_ubuntu-zesty-amd64.firebird3.0_3.0.2.32703.ds4-1ubuntu1_BUILDING.txt.gz binaries generated on that host work on nonsse4 ones (machine described above) On Mon, Jul 10, 2017 at 7:16 PM,

Re: [Firebird-devel] sse3 host x64 linux

On 10.07.2017 19:08, marius adrian popa wrote: It's weird that package from ppa (3.0.2) works LI-V3.0.2.32703 Firebird 3.0 https://launchpad.net/~mapopa/+archive/ubuntu/firebird3.0/+build/12568442 What version

Re: [Firebird-devel] Optimisation of where afield = coalesce(value1, value2 )

10.07.2017 12:17, Paul Reeves пишет: On Fri, 7 Jul 2017 18:07:55 +0300 Dmitry Yemanov wrote 07.07.2017 17:51, Paul Reeves wrote: I understand that evaluating COALESCE(?, e.emp_no ) at prepare time may require a circular logic and is thus impractical It cannot be done at runtime either

Re: [Firebird-devel] Optimisation of where afield = coalesce(value1, value2 )

On Mon, 10 Jul 2017 12:31:43 +0300 Dmitry Yemanov wrote > > > The other question I asked was... > > > > why can't I force the plan... > > > >PLAN (E INDEX (RDB$PRIMARY7)) > > Because it's invalid in this case. > I can understand that this plan might appear to be invalid

Re: [Firebird-devel] Optimisation of where afield = coalesce(value1, value2 )

On Fri, 7 Jul 2017 18:07:55 +0300 Dmitry Yemanov wrote > 07.07.2017 17:51, Paul Reeves wrote: > > > But that doesn't answer all my questions... > > > > Given > > > >where e.EMP_NO = COALESCE(?, e.emp_no ) > > > > and that there is an index on EMP_NO, why doesn't the optimiser > > default

[Firebird-devel] Result set from where afield = afield

While I was studying this sort of query: SELECT * FROM employee e WHERE e.EMP_NO = coalesce ( ?, e.EMP_NO) it became obvious that if the parameter is null it resolves to this sort of query: SELECT * FROM employee e WHERE e.EMP_NO = e.EMP_NO which produces the same result set as

Re: [Firebird-devel] sse3 host x64 linux

On Mon, Jul 10, 2017 at 03:04:12PM +0300, marius adrian popa wrote: > > ./autogen.sh --prefix=/opt/firebird3.x > > /home/mariuz/Work/firebird/firebird/gen/Release/firebird/bin/gpre_current -m > -z > -n /home/mariuz/Work/firebird/firebird/src/yvalve/blob.epp /home/mariuz/Work/ >

Re: [Firebird-devel] sse3 host x64 linux

Issue is still present Fresh download from github (git clone) git checkout B3_0_Release ./autogen.sh --prefix=/opt/firebird3.x /home/mariuz/Work/firebird/firebird/gen/Release/firebird/bin/gpre_current -m -z -n /home/mariuz/Work/firebird/firebird/src/yvalve/blob.epp

Re: [Firebird-devel] sse3 host x64 linux

gcc version 6.3.0 20170406 (Ubuntu 6.3.0-12ubuntu2) That looks first of all as a known but still not fixed issue with gcc6. -- Check out the vibrant tech community on one of the world's most engaging tech sites,

Re: [Firebird-devel] Optimisation of where afield = coalesce(value1, value2 )

10.07.2017 14:20, Paul Reeves wrote: I can understand that this plan might appear to be invalid from the perspective of the optimiser. But surely the whole point of adding the PLAN clause is because I think I know better than the optimiser what I want. Unless the engine physically cannot

Re: [Firebird-devel] Result set from where afield = afield

10.07.2017 15:11, Paul Reeves wrote: I've also seen, in stored procedures, this sort of construct... where (( e.EMP_NO = :AEMP_NO ) OR ( :AEMP_NO IS NULL)) which, if the input parameter AEMP_NO is NULL will also behave as if a full result set was requested. ie, the stored procedure will

Re: [Firebird-devel] Result set from where afield = afield

On 10/07/2017 09:11, Paul Reeves wrote: > While I was studying this sort of query: > > SELECT * FROM employee e > WHERE e.EMP_NO = coalesce ( ?, e.EMP_NO) > > it became obvious that if the parameter is null it resolves to this > sort of query: > > SELECT * FROM employee e > WHERE

[Firebird-devel] icudt52.dll FB3

Hi i upgraded from embedded FB 2.5 to 3 (Firebird-3.0.2.32703-0_Win32.zip) On Windows 10 32 bit no problem but on Windows 10 64 bit icw Flamerobin i get the error couldn't find acceptable icu library the icudt52.dll (3kb) seems to be the problem because the original icudt52.dll from IBM

Re: [Firebird-devel] sse3 host x64 linux

The same it crashes On Mon, Jul 10, 2017 at 4:00 PM, Michal Kubecek wrote: > On Mon, Jul 10, 2017 at 03:04:12PM +0300, marius adrian popa wrote: > > > > ./autogen.sh --prefix=/opt/firebird3.x > > > > /home/mariuz/Work/firebird/firebird/gen/Release/firebird/bin/gpre_current > -m