Re: [Firebird-devel] Improve release filenames

2022-08-24 Thread Paul Reeves
will complain 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. Pau

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

2022-06-17 Thread Paul Reeves
bjections. Or I 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
had problems reproducing 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 m

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 th

[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 interfa

Re: [Firebird-devel] Build environments with Docker

2021-12-09 Thread Paul Reeves
eds the 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 lis

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

2021-08-16 Thread Paul Reeves
nd later ? It might 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
e 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
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 necess

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 ++ :-) > > Ju

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

2020-08-18 Thread Paul Reeves
ory. I'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.

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

2020-08-18 Thread Paul Reeves
ications 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
7;d like to see java 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.ibph

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

2020-08-17 Thread Paul Reeves
rt of the 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
where all the 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
ractice we 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/list

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 compiles in H

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

2020-08-12 Thread Paul Reeves
y in that file. (Yes, I know the isc api is deprecated 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

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

2020-08-12 Thread Paul Reeves
re 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
bird::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

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 h

Re: [Firebird-devel] ICU File Deployment Guidance

2020-04-29 Thread Paul Reeves
n anyone confirm the 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
omated 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 Fi

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

2020-04-28 Thread Paul Reeves
aller is being 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
d. But that doesn't 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

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
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. P

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
d-fashioned HDD. 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
;t cost much. 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.ibp

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
t. 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

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

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

2020-01-02 Thread Paul Reeves
l 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

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

2019-12-17 Thread Paul Reeves
plied 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,

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 th

Re: [Firebird-devel] FB4 asynchronous replication

2019-10-07 Thread Paul Reeves
missing? 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
itten 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 f

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

2019-09-12 Thread Paul Reeves
ersion. (As far as I recall.) 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
for UDFs and 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
erformance estimation is 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.

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 --

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
correct 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

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

2019-03-06 Thread Paul Reeves
e use zero security at the un/pw level so don't really care about security. We want to take our users with us. To do so means keeping migration as simple as possible. What is the opinion of others on this subject? Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird

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, rp

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
. > 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

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

2019-02-23 Thread Paul Reeves
ed but 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 > differ

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

2019-02-15 Thread Paul Reeves
inXP 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:/

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

2019-02-08 Thread Paul Reeves
s 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
od system 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. P

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

2018-01-29 Thread paul reeves
ously 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 o

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, Slas

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
SVC12 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 Support

[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 "/pa

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
ed 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 Fir

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

2017-08-28 Thread Paul Reeves
make_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 tec

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

2017-08-28 Thread Paul Reeves
o me. 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

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

2017-08-28 Thread Paul Reeves
stener 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

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'l

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

2017-08-25 Thread Paul Reeves
e plans 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 prep

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

2017-08-25 Thread Paul Reeves
ter to extend PLAN 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

[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?

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

2017-08-14 Thread Paul Reeves
u can 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 els

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

2017-08-01 Thread Paul Reeves
e. 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 contrib

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

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

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

2017-07-10 Thread Paul Reeves
e fetches and the 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 und

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 i

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

2017-07-07 Thread Paul Reeves
hough a field is specified 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 of the

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

Re: [Firebird-devel] udrcpp_example

2017-07-04 Thread Paul Reeves
s installed 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 mos

[Firebird-devel] udrcpp_example

2017-07-04 Thread Paul Reeves
tusType *,const char *,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 tec

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
ation 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&#

Re: [Firebird-devel] unix2dos

2017-03-23 Thread Paul Reeves
On Thu, 23 Mar 2017 16:35:32 +0100 Dimitry Sibiryakov wrote > 23.03.2017 16:09, Paul Reeves wrote: > > The reason we need it is because git seems to check (some) files out > > with LF eols and we need to deploy all text files with CR LF eols. > >It can be changed in

Re: [Firebird-devel] unix2dos

2017-03-23 Thread Paul Reeves
idn't discover this until late in the RC stage of v3.0.0, hence a rapid fix with unix2dos. Paul -- Paul Reeves http://www.ibphoenix.com Supporting users of Firebird -- Check out the vibrant tech community o

Re: [Firebird-devel] unix2dos

2017-03-23 Thread Paul Reeves
nd unix2dos on linux assumes that output 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 --

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
source tree was mangled in some way. I had previously used to to do a build on another platform and just zipped it up and copied it across. So perhaps the problem, (apart from the user himself :-) ), is that 'make clean' does not make clean enough. I tried that a couple of times, as well as

Re: [Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
On Wed, 29 Jun 2016 13:00:53 +0300 Alex Peshkoff wrote: > On 06/29/2016 12:42 PM, Paul Reeves wrote: > > On Wed, 29 Jun 2016 11:07:06 +0200 > > Paul Reeves wrote: > > > > symbol lookup > > error: > > /root/rpmbuild/BUILD/Firebird-3.0.0.32483-0/gen/R

Re: [Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
On Wed, 29 Jun 2016 11:07:06 +0200 Paul Reeves wrote: > > I'll try building from the epel-7 source rpm and see if that works. > That seems to fix the FB_CPU problem And now I'm getting a new error : symbol lookup error: /root/rpmbuild/BUILD/Firebird-3.0.0.32483-0/gen/R

Re: [Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
m > > > > > > Strange error you have, no idea why > > It is probably because I have tried to build the tagged Firebird 3.0.0 source. I notice in the fedora build logs that several patches have been applied. I'll try building from the epel-7 source rpm and see if

[Firebird-devel] Centos7 and FB_CPU

2016-06-29 Thread Paul Reeves
gets 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 Fir

[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. But

  1   2   3   >