Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Paul Reeves
ain and the whole exercise will be largely useless. Shipping a complete kit guarantees that everything will match up and can be uninstalled easily. But I agree with Dimitry - we should take care to distinguish kits containing debug symbols from actual 'Debug' builds. Paul -- Paul Reeves h

[Firebird-devel] Cleaning up Visual Studio detection during build and packaging.

2022-06-17 Thread Paul Reeves
can create a work branch for review. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Status of 3.0.10

2022-04-13 Thread Paul Reeves
it manually. For now, all I can suggest is that we remove the option to set legacy auth support in the Fb3 installer. This option has already been removed in Fb 4.0. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] set_build_target dot bat in HEAD

2021-12-23 Thread Paul Reeves
On Wed, 22 Dec 2021 13:14:43 -0300 Adriano dos Santos Fernandes wrote: > On 22/12/2021 10:12, Paul Reeves wrote: > > > > Is there any reason why set_build_target only tests for VS150COMNTOOLS ? > > > > Looks like no. > I've been looking into this more c

Re: [Firebird-devel] set_build_target dot bat in HEAD

2021-12-23 Thread Paul Reeves
On Wed, 22 Dec 2021 15:32:41 +0100 Dimitry Sibiryakov wrote: > Paul Reeves wrote 22.12.2021 14:12: > > Is there any reason why set_build_target only tests for VS150COMNTOOLS ? > > > > I'd like to add tests for VS160COMNTOOLS and VS170COMNTOOLS, unless there &

[Firebird-devel] set_build_target dot bat in HEAD

2021-12-22 Thread Paul Reeves
Is there any reason why set_build_target only tests for VS150COMNTOOLS ? I'd like to add tests for VS160COMNTOOLS and VS170COMNTOOLS, unless there are any objections. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface

Re: [Firebird-devel] Build environments with Docker

2021-12-09 Thread Paul Reeves
he MSM module, as well as WiX. But there are also some changes required to the WiX projects as well as BuildExecutableInstall.bat and the innosetup script. I'm working on the fixes now. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web int

Re: [Firebird-devel] Windows installer and ICU files

2021-08-16 Thread Paul Reeves
ght just be better to document what the absolute minimum is rather than encourage it. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Duplicated boost in Windows v4 RC1 kits

2021-05-21 Thread Paul Reeves
've located the cause of the problem. I'll commit the fix once I'm sure. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Paul Reeves
On Tue, 2 Feb 2021 13:31:10 +0300 Alex Peshkoff via Firebird-devel wrote: > On 2/2/21 12:16 PM, Paul Reeves wrote: > > I doubt that our user base for 32-bit ARM is really very significant but > > 32-bit ARM chips probably have a good future ahead of them. > > Not sure. I

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Paul Reeves
elf the question about x86 quite frequently. I can see a reason for maintaining support in the code base but I find it hard to justify producing official x86 binaries for new versions of Firebird. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mail

[Firebird-devel] Builds with USE_VALGRIND fail

2020-11-26 Thread Paul Reeves
aka long unsigned int (*)(long unsigned int)}’ to binary ‘operator-’ size = length - (VALGRIND_REDZONE + GUARD_BYTES); Similar errors appear when building B3_0_Release. Should I log this as a bug? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mail

Re: [Firebird-devel] [firebird-admins] Re: [Firebird-admins] v3.0.7 release

2020-10-21 Thread Paul Reeves
On Wed, 21 Oct 2020 15:13:07 +0200 Mark Rotteveel wrote: > On 21-10-2020 12:50, Paul Reeves wrote: > > The new packages are now in the pre-release area. I've bumped the package > > number, so the previous URLs will probably no longer work. But I think > > this is necessary t

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-19 Thread Paul Reeves
On Wed, 19 Aug 2020 05:47:59 +0300 Norbert Saint Georges wrote: > Paul Reeves a écrit : > > > > > Does anyone have any thoughts on this? > > > > > > Paul > > First of all, thanks for your code, it's nicer to read than c ++ :-) > > Just a

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-18 Thread Paul Reeves
d like to include those files because I have found they solve quite a few problems. And I would appreciate any suggestions you have. > It is desirable that the examples can be compiled in both FPC and Delpli. They are just .pas files and a makefile. Paul -- Paul Reeves http://www.ibphoenix.com S

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-18 Thread Paul Reeves
cations in any language that supports the new api. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-18 Thread Paul Reeves
and .Net examples distributed. And any others languages that can connect to Firebird. Why not, for example, have 03.select.java that demonstrates the minimum required to do a select in java AND produces identical results to 03.select.cpp? Paul -- Paul Reeves http://www.ibphoenix.com Supporting

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-17 Thread Paul Reeves
VCL is overkill. :-) Actually I should have written RTL. But your comment made me think more clearly. Thanks. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] OO API examples for Object Pascal

2020-08-17 Thread Paul Reeves
he base classes are declared. There is no need for the VCL at all. (Thank goodness.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] OO API examples for Object Pascal

2020-08-17 Thread Paul Reeves
should probably integrate the examples into the VCL. And that might be a step too far. Does anyone have any thoughts on this? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

Re: [Firebird-devel] ../examples/include/example.h

2020-08-17 Thread Paul Reeves
Peshkoff via Firebird-devel wrote: > On 2020-08-12 19:32, Paul Reeves wrote: > > I'm working on re-creating the makefile for the api examples. I don't know > > how, but it seems to have got lost a long while ago. > > > > Almost everything still compil

[Firebird-devel] ../examples/include/example.h

2020-08-12 Thread Paul Reeves
but as long as we continue to ship the these examples in the kits they should build and there should be a makefile to build them.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

Re: [Firebird-devel] Building 05.user_metadata.cpp

2020-08-12 Thread Paul Reeves
that the makefile is not the problem. I'll commit the makefile as everything else builds without error. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Building 05.user_metadata.cpp

2020-08-12 Thread Paul Reeves
:IReferenceCountedImplFirebird::ThrowStatusWrapper, Base>Firebird::InheritFirebird::ThrowStatusWrapper, Base>Firebird::Inherit > > >] virtual unsigned Base>getAlignedLength(StatusType* status) = 0; ^~~~ Is this an error in the code or in my makefile? Paul -- Paul Reeves http:

Re: [Firebird-odbc-devel] ODBC/JDBC

2020-07-10 Thread Paul Reeves
ith JDBC as far as I am aware. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird ___ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] Source repository

2020-06-05 Thread Paul Reeves
On Fri, 5 Jun 2020 16:49:33 +0200 Dimitry Sibiryakov wrote: >Hello, All. > >What is the official driver's source repository? Github or still > Sourceforge? > Everything should now be on github. https://github.com/FirebirdSQL/firebird-odbc-driver/commits/master

Re: [Firebird-devel] Page size 32K in FB4

2020-05-26 Thread Paul Reeves
CONNECT or CREATE DATABASE to specify a database > SQL> CREATE DATABASE 'test32.fdb' PAGE_SIZE 32768; > SQL> show db; > Database: test32.fdb >     Owner: SYSDBA > PAGE_SIZE 32768 > > Try specifying a charset :-) Paul -- Paul Reeves http://www.

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Paul Reeves
situation with Windows? I find it hard to believe that Microsoft aren't on the ball with this. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Paul Reeves
d updates how will a server installation know to look for them? A task scheduler of some sort would need to check. We don't have one built in to Firebird so it would mean adding something platform specific. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Installing the ICU Files under Windows

2020-04-28 Thread Paul Reeves
eing updated for Beta 2, and it is likely to change frequently over the next few days. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Introduction of EXTENDED TIME/TIMESTAMP WITH TIME ZONE?

2020-03-10 Thread Paul Reeves
solve the underlying problem. Another aspect, which is more personal, is that like most Anglophones I don't really need the character support provided by icu. And living in a country with a single time zone I don't need the time zone support either. For me icu spells Aaargh!!! :-) Paul -- Paul Ree

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 16:48:29 +0100 Dimitry Sibiryakov wrote: > 26.02.2020 15:39, Paul Reeves wrote: > > Been there, looked at that :-) > > > > AFAICT it is for InterBase 2020 which is only available for Windows at the > > moment. The tests in the article were done wit

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
buffers. My reading of that is that there is only one cache writer, and journal writes are queued in the memory cache until they are finally written out to disc. The only different to Firebird's asynchronous writes that I can see is that journalling uses its own cache instead of the filesystem cache. Paul

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 14:23:32 +0100 Dimitry Sibiryakov wrote: > 26.02.2020 13:46, Paul Reeves wrote: > > If anyone can let me have a copy of InterBase XE7 I would be happy to run > > some proper comparisons on our test rig. > >Developers Edition is free to download

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
On Wed, 26 Feb 2020 16:28:38 +0300 Alex Peshkoff via Firebird-devel wrote: > On 2020-02-26 15:46, Paul Reeves wrote: > > AFAICT most of the content of that document is rubbish. They have > > certainly skewed our support costs heavily, using the most extreme > > examples. &

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Paul Reeves
. If anyone can let me have a copy of InterBase XE7 I would be happy to run some proper comparisons on our test rig. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] After_Installation.url

2020-01-13 Thread Paul Reeves
ch. And if, one day, the web server wants to use that value, the url will go to the correct page. There are quite a lot of differences between 2.5, 3.0 and 4.0. But unless the web-server has pages that make this distinction, this doesn't matter. Paul -- Paul Reeves http://www.ibphoenix.com S

Re: [Firebird-devel] GPRE and examples

2020-01-09 Thread Paul Reeves
On Thu, 9 Jan 2020 15:42:50 +0100 Dimitry Sibiryakov wrote: > 09.01.2020 13:53, Paul Reeves wrote: > > So the question should whether to include dynamic gpre examples in the > > packages or just remove them from the repo. As far as I know they have > > been deprecated for

Re: [Firebird-devel] GPRE and examples

2020-01-09 Thread Paul Reeves
So the question should whether to include dynamic gpre examples in the packages or just remove them from the repo. As far as I know they have been deprecated for a long while and have not been shipped in the product since maybe even InterBase days. Paul -- Paul Reeves http://www.ibphoenix.com S

Re: [Firebird-devel] Inno Setup version for official distributive

2020-01-08 Thread Paul Reeves
On Mon, 6 Jan 2020 17:32:06 +0100 Dimitry Sibiryakov wrote: > 06.12.2019 20:08, Paul Reeves wrote: > > But I guess we should upgrade anyway. Perhaps a more pertinent question > > would be too ask whether we need to stick with v5. We haven't hacked > > the code. We ju

Re: [Firebird-devel] Version of touch used for package building

2020-01-02 Thread Paul Reeves
isual perspective though as it is easy to spot files that have been edited or binaries installed from different packages. I'll take a look at the code and see if I can fix it. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6209) I've been waiting for Firebird-test Approval. Please advise.

2019-12-17 Thread Paul Reeves
again to Adriano, and received another email from > --- "Your message to > Firebird-test awaits moderator approval". > > Please advise. > > > -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Inno Setup version for official distributive

2019-12-06 Thread Paul Reeves
. We haven't hacked the code. We just use InnoSetup from a standard install so there is no reason to stay with an older version unless v6 actually breaks the existing install script. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, w

Re: [Firebird-devel] FB4 asynchronous replication

2019-10-07 Thread Paul Reeves
On Mon, 7 Oct 2019 17:03:14 +0200 Dimitry Sibiryakov wrote: > 07.10.2019 17:00, Paul Reeves wrote: > > Both servers are using Beta1 > >Upgrade to snapshot. It had been fixed since then. > > Hmm - I thought of that, but couldn't see anything specific in the

Re: [Firebird-devel] FB4 asynchronous replication

2019-10-07 Thread Paul Reeves
ng? Both servers are using Beta1 and synchronous replication works fine so the firebird installation appears to be OK. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] FB4 asynchronous replication

2019-10-07 Thread Paul Reeves
to the either of the replication logs. What am I missing? (BTW, synchronous replication 'just works'.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Reopened: (CORE-3900) VC runtime installer can reboot system prior to installation finishing

2019-09-26 Thread Paul Reeves (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-3900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Reeves reopened CORE-3900: --- I'll take another look. > VC runtime installer can reboot system prior to installation finish

Re: [Firebird-devel] Build error on Windows (Visual Studio 2015)

2019-09-12 Thread Paul Reeves
Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] UDR vs PSQL

2019-06-19 Thread Paul Reeves
nd SPs, but I have always assumed that a UDF will load and execute more quickly than a SP. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] UDR vs PSQL

2019-06-17 Thread Paul Reeves
correct. > Jiri, Perhaps the real comparison should be between UDR and UDF. Can you test that? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-11 Thread Paul Reeves
/STAMP is the wrong way round. It should support the old behaviour. Instead of introducing LOCALTIME/STAMP to return current time without the zone we should introduce new variables that return time zones for those that need them. That may not solve the problem in [subject] but it will ease the pain

Re: [Firebird-devel] UDF lib works on Linux but crash on Windows (Error writing data to connection)

2019-05-07 Thread Paul Reeves
On Tue, 7 May 2019 10:54:53 +0200 Massimo Fazzolari wrote: > Anybody could help me to figure out what's wrong with the > FPC 64bit compiler? Is there any compile/linker flag that I should > use? It might help to tell us which compiler and linker flags you are already using. Paul

Re: [Firebird-devel] Max lock slots for Classic Server v2.5 x64?

2019-03-19 Thread Paul Reeves
6001. But in all cases 8009 was the winner. I didn't go deeper - it may be that the real sweet spot is between, say, 6,000 and 12,000, but again, it may also be database/application specific. But I would start with 8009 and maybe go upward slowly, rather than jumping to around 64K. Paul -- Paul

Re: [Firebird-devel] Building Firebird 2.5 on Windows

2019-03-19 Thread Paul Reeves
On Tue, 19 Mar 2019 16:36:25 +0200 Vlad Khorsun wrote: > 19.03.2019 15:48, Paul Reeves wrote: > > On Tue, 19 Mar 2019 15:33:23 +0200 > > Vlad Khorsun wrote: > > >> > >> The best (and only guarantee) is to use "official" compile

Re: [Firebird-devel] Building Firebird 2.5 on Windows

2019-03-19 Thread Paul Reeves
On Tue, 19 Mar 2019 15:33:23 +0200 Vlad Khorsun wrote: > >The best (and only guarantee) is to use "official" compiler. For > fb25 on Windows it is VC8 (VS2005). Actually, it is MSVC10 :-) MSVC8 was for 2.1, if I recall correctly. Paul -- Paul Reeves http:

Re: [Firebird-devel] CORE-6011 legacy authentication in Windows installer

2019-03-06 Thread Paul Reeves
rrect srp is a form of legacy authorization, even if it does not use the legacy_auth plugin. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-23 Thread Paul Reeves
On Sat, 23 Feb 2019 17:54:40 +0100 Dimitry Sibiryakov wrote: > 23.02.2019 17:51, Paul Reeves wrote: > > It is linked to the fact that rpm installs don't allow > > interaction at install time, so the security database is not > > initialised. > >IIRC, rpm ins

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

2019-02-23 Thread Paul Reeves
ers. > As far as linux and Firebird 3 is concerned that is definitely a problem. It is linked to the fact that rpm installs don't allow interaction at install time, so the security database is not initialised. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Fire

Re: [Firebird-devel] Firebird 4 beta 1 Windows installer says it is suitable for production use

2019-02-23 Thread Paul Reeves
t there are meant to be two boiler plate readme's - one for dev releases and one for prod releases. That one is surely not appropriate for a beta. I'll look into it. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Building Firebird 4 on Windows

2019-02-15 Thread Paul Reeves
On Fri, 15 Feb 2019 11:50:11 +0100 Dimitry Sibiryakov wrote: > 15.02.2019 9:17, Paul Reeves wrote: > > First you need to click on the 'Desktop Development with C++' > >You are talking about installing of Visual Studio. My question was > different: is Bu

Re: [Firebird-devel] Building Firebird 4 on Windows

2019-02-15 Thread Paul Reeves
P option is checked (it is off by default). You then need to go to individual components and make sure that the VC++ option for v141 tools is checked as well as the WinXP option. I _think_ everything else is optional. You also need to set VS150COMNTOOLS manually. Paul -- Paul Reeves http://www.ibpho

Re: [Firebird-devel] What type of UUID we use in Firebird ? i guess Version 1

2019-02-08 Thread Paul Reeves
only guarantee was that they are unique. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

2019-01-24 Thread Paul Reeves
stem IO. But this is NOT synonymous with the IO from a real disc subsystem. Basically a RAM disc will reduce IO to the absolute minimum available with today's technology. But it is probably not the most suitable location to host a firebird database so the performance results would be invalid. Paul -- P

[Firebird-devel] Unknown tag value - missing in the list of possible

2018-01-29 Thread paul reeves
missing from the list of possible tag values ? - Or is it that this tag value is not available among the possible tag values for this call ? - Or is it something so obvious that I'm just missing it completely ? - Or ? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Meltdown and Spectre

2018-01-09 Thread Paul Reeves
ff as one flaw can used to exploit another. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.

Re: [Firebird-devel] Meltdown and Spectre

2018-01-09 Thread Paul Reeves
On Tue, 9 Jan 2018 09:52:59 + Omacht András wrote > > Average running time on 4.9.0-4: 466 secs (7 mins 46 secs) > Average running time on 4.9.0-5: 635 secs (10 mins 35 secs) That is a massive hit. Has anyone had a chance to run tests on AMD kit? Paul -- Paul Re

Re: [Firebird-devel] Build sources

2017-10-13 Thread Paul Reeves
or 13. And if you are working on HEAD you will likely find other small bits that are missing. Don't forget that HEAD is still in alpha. You may find working with the FB 3 branch easier to get started on. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Fi

[Firebird-devel] [FB-Tracker] Created: (CORE-5629) gstat output does not include datetime of analysis

2017-10-05 Thread Paul Reeves (JIRA)
: GSTAT Reporter: Paul Reeves Priority: Minor It would be nice to have a timestamp in a gstat report otherwise it is necessary to rely on the file creation date, which is not always correct. This could be the first line of gstat output, just before the Database "

Re: [Firebird-devel] Understanding OLTP results

2017-09-14 Thread Paul Reeves
firebird. Have you tried other kernels from other distros ? ( 4.1 is getting old, now - the latest is 4.12, I think. ) Have you compared the compile params Oracle Linux uses ? Perhaps they have changed something. Paul -- Paul Reeves http://www.ibphoenix.com Supporting

[Firebird-devel] Firebird.pas is missing

2017-08-30 Thread Paul Reeves
to generate firebird.pas? I looked at the code in Makefile.in and makeInstallImage.sh.in for the linux kits and it is not at all obvious what is needed to add this to the windows build process. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

Re: [Firebird-devel] Problem in Windows zip kits

2017-08-28 Thread Paul Reeves
ke_all.bat and then I'll re-write the code in BuildExecutableInstall.bat to just strip comments from that file. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech communit

Re: [Firebird-devel] Problem in Windows zip kits

2017-08-28 Thread Paul Reeves
There is new stuff added to Alpha1 but nothing seems to be missing. > > - include/firebird/impl is not included > In fact that is my fault. Several installer related commits to B3_0_Release never got forward ported to HEAD. I'm working on bringing all of them up-to-date

Re: [Firebird-devel] fbclient - Event call back is called after isc_cancel_events

2017-08-28 Thread Paul Reeves
r is running on a timer in the main thread. The event listener should really be running in its own thread. Have you tried that? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibr

Re: [Firebird-devel] Problem in Windows zip kits

2017-08-27 Thread Paul Reeves
On Sat, 26 Aug 2017 19:04:28 -0300 Adriano dos Santos Fernandes wrote > Hi! > > I found two problems with include files: > > - ibase.h has #include "consts_pub.h" > > - include/firebird/impl is not included > Can you file that as a bug, and I'll fix

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
s generated within the engine during actual execution. Which leads to a question... How/When are Stored Procedures prepared? A complex SP can have many different execution paths. Is each statement prepared as needed for each execution or are all statements prepared at once, during the initial prepare ? Pa

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
LAN and EXPLAIN with an option to dive into the details of a SP's execution rather than add a new command. But whatever happened to the SP debugger? If we had that, then I would be able to see the plan chosen for each statement in the SP, which would go a long way to helping me with my current problem.

[Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
SP source, remove the 'create proc myproc' and insert 'execute block' and then prepare it with input param markers the plan (or plans) is/are actually returned. So obviously this information is available internally. How come it is supressed for SPs in FB 3.0? Is this a bug? Paul -- Paul Reeves

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-14 Thread Paul Reeves
see the IDPL here: https://www.ibphoenix.com/about/firebird/idpl and the IPL here: https://www.ibphoenix.com/about/firebird/ipl > 2. What prefix do you prefer for this? > > I prefer LIB$, like LIB$CheckTriggerUniquePostion. > > Any other idea? That could work. Does anyone else hav

Re: [Firebird-devel] Useful SQL Stored Procedures as part of standard firebird installation

2017-08-01 Thread Paul Reeves
It is not too much work, but it does require commitment if the intention is that these procedures should ship with Firebird. Bit rot can set in very quickly if no-one is around to maintain code. Perhaps the first step would be to create a github project to allow people to contribute. Pa

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

2017-07-10 Thread Paul Reeves
procedure will return a single record if AEMP_NO has a value and the entire table if it is null. The advantage of using that sort of construct is that only one SQL statement is required, rather than a more complex 'if then else' but is it safe from future implementation changes ? Paul -- Paul

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

2017-07-10 Thread Paul Reeves
he indexed reads more or less double because of the OR clause. (Again, a subject for another day is why does the optimiser even bother with the second stream when EMP_NO can never be null ? ) Anyway, none of the above is any sort of criticism. I'm just trying to get a better understanding of the rules a

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

2017-07-10 Thread Paul Reeves
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

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

2017-07-07 Thread Paul Reeves
cified in the coalesce why can't I force the plan... PLAN (E INDEX (RDB$PRIMARY7)) This error is raised... 'cannot be used in the specified plan' Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -

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

2017-07-07 Thread Paul Reeves
does the optimiser consider COALESCE when this construct is used in a stored procedure? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one

Re: [Firebird-devel] udrcpp_example

2017-07-06 Thread Paul Reeves
On Wed, 5 Jul 2017 12:25:11 -0300 Adriano dos Santos Fernandes wrote > On 04/07/2017 11:33, Paul Reeves wrote: > > Building udrcpp_example fails under windows, and has done since at > > least the final release of Firebird 3.0. Unfortunately the build > > process doesn't dete

Re: [Firebird-devel] udrcpp_example

2017-07-04 Thread Paul Reeves
talled there. I'll try this on a development VM later. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one of the world's most engaging tech

[Firebird-devel] udrcpp_example

2017-07-04 Thread Paul Reeves
*,Firebird::IUdrFunctionFactory *)' as a function argument Shall I log this as a bug? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one

Re: [Firebird-devel] Event Parameter buffer (EPB)

2017-03-28 Thread Paul Reeves
ut still recommended from a performance perspective. (Which is the whole point of using events in the first place.) Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant te

Re: [Firebird-devel] Event Parameter buffer (EPB)

2017-03-28 Thread Paul Reeves
Anyone ? On Mon, 27 Mar 2017 11:12:47 +0200 Paul Reeves wrote > The EPB is clearly documented as being limited to 15 events. I did a > fairly rough grep of the code and I failed to find where this > limitation is enforced. And I couldn't find anything in the release > notes

[Firebird-devel] Event Parameter buffer (EPB)

2017-03-27 Thread Paul Reeves
without anyone noticing? Or have I missed something while grepping the code? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] unix2dos

2017-03-23 Thread Paul Reeves
will be in dos format - hence the name. Why the gnuwin32 version doesn't make that assumption is anyone's guess. So the -D (or --unix2dos in the long format ) is required. Paul -- Paul Reeves http://www.ibphoenix.com Supporting us

Re: [Firebird-devel] LibreOffice 5.3.0 is using firebird 3.0

2017-02-09 Thread Paul Reeves
On Thu, 9 Feb 2017 11:38:51 +0200 you wrote > LibreOffice Release notes > > https://wiki.documentfoundation.org/ReleaseNotes/5.3#Base > IIUC, every time you open/close a firebird database in LO it calls gbak to do a restore or a backup. Paul -- Paul Reeves http://www.i

[Firebird-devel] [FB-Tracker] Created: (CORE-5314) UDFs declared with large varchars take excessive time to execute

2016-07-20 Thread Paul Reeves (JIRA)
Components: UDF Affects Versions: 2.5.6 Environment: Windows Reporter: Paul Reeves UDFs declared with large varchars take excessive time to execute An IBPhoenix client reported the following problem to us. A single udf, when declared with a 32k string length

Re: [Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
On Wed, 29 Jun 2016 13:00:53 +0300 Alex Peshkoff <peshk...@mail.ru> wrote: > On 06/29/2016 12:42 PM, Paul Reeves wrote: > > On Wed, 29 Jun 2016 11:07:06 +0200 > > Paul Reeves <pree...@ibphoenix.com> wrote: > > > > symbol lookup > > error: > &

[Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
defined as x86_64-unknown-linux-gnu so surely that ought to be enough information to define AMD64 but for some reason that does happen. Anyone got any ideas? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

[Firebird-devel] [FB-Tracker] Created: (CORE-5284) Firebird fails to build with USE_VALGRIND

2016-06-17 Thread Paul Reeves (JIRA)
Affects Versions: 3.0.0, 4.0 Initial Environment: Linux Reporter: Paul Reeves Priority: Minor The first build problem arrives with DELAYED_EXTENT_COUNT being used in anonymous namespace, before it has been defined globally. That was easy enough to work around

[Firebird-devel] building FB3 for valgrind

2016-06-17 Thread Paul Reeves
ror perhaps? Should I file a bug report? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interf

[Firebird-devel] isc_dsql_execute_immediate and FB3

2016-05-18 Thread Paul Reeves
because it allowed misuse of the function. However, if we are going to throw an error I think it should be more explicit. Perhaps something along the lines of: 'Select statements cannot be execute by isc_dsql_execute_immediate' Shall I log this as a bug / enhancement request ? Paul -- Paul

[Firebird-devel] Multiple instances of Firebird 3 on linux

2016-05-09 Thread Paul Reeves
parameter? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 161500: Deploy fbclient to by default.

2016-04-01 Thread paul reeves
On Fri, 1 Apr 2016 16:05:17 +0200 Dimitry Sibiryakov <s...@ibphoenix.com> wrote: > 01.04.2016 15:59, paul reeves wrote: > >> >What about firebird.msg ? > > That has always been a problem. Perhaps we could add that to ? > > Although I'm not sure ab

  1   2   >