[Firebird-devel] Domain default not used for SP ending parameter

2013-11-28 Thread Robbert-Jan
Hi, Domain defaults seem not to be applied for SP ending parameters, see case below. Is this as designed, or a bug, or a request? I just want to be sure before I issue a Jira tracker. CREATE DOMAIN MyDomain1 AS INTEGER DEFAULT 1 CREATE PROCEDURE MyProcedure1 (Var1 MyDomain1) RETURNS (Var2

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Jiri Cincura
On Sun, Sep 15, 2013 at 5:05 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote: Set up bidirectional replication between old server with old FB version and new version with 3.0. This way you can move load from old server to new one step-by-step and if any problem appear, return users back to

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Dimitry Sibiryakov
28.11.2013 14:26, Jiri Cincura wrote: The replication might work, but as I know how the updates are flowing, we would very likely had a lot of collisions. Only if database was designed this way. Properly designed databases should not produce conflicts. But the real problem is switching

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Jiri Cincura
On Thu, Nov 28, 2013 at 2:31 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote: Only if database was designed this way. Properly designed databases should not produce conflicts. Please. That's nonsense. I'm simply updating same records from more apps. Very often at the same time (or better to

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Dimitry Sibiryakov
28.11.2013 14:46, Jiri Cincura wrote: Please. That's nonsense. I'm simply updating same records from more apps. Very often at the same time (or better to say time window). Do inserts instead of updates. This way you get rid of conflicts and as a bonus will get a good history of changes.

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Jiri Cincura
On Thu, Nov 28, 2013 at 2:57 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote: Do inserts instead of updates. This way you get rid of conflicts and as a bonus will get a good history of changes. Yeah. I have another 10 man-years to rewrite all this stuff. Ok, set two IP addreses for

Re: [Firebird-devel] Testing Firebird 3.0 under real load

2013-11-28 Thread Dimitry Sibiryakov
28.11.2013 15:12, Jiri Cincura wrote: Yeah. I have another 10 man-years to rewrite all this stuff. Don't be so pessimistic. You can leave application as is but for operations that really produce conflict, you can convert updates to inserts at database level by using views. But still one

Re: [Firebird-devel] Domain default not used for SP ending parameter

2013-11-28 Thread Adriano dos Santos Fernandes
On 28/11/2013 07:36, Robbert-Jan wrote: Hi, Domain defaults seem not to be applied for SP ending parameters, see case below. Is this as designed, or a bug, or a request? I just want to be sure before I issue a Jira tracker. CREATE DOMAIN MyDomain1 AS INTEGER DEFAULT 1 CREATE PROCEDURE

[Firebird-devel] Fwd: ARM64 port

2013-11-28 Thread Dmitrijs Ledkovs
Hello, I've enabled ARM64 build of firebird2.5 in ubuntu. At the moment profiling was not available, hence -p / -pg flags were not used. Build log can be found here: https://launchpad.net/ubuntu/+source/firebird2.5/2.5.2.26540.ds4-8ubuntu1/+build/5278157 One can also compile it using qemu

Re: [Firebird-devel] Fwd: ARM64 port

2013-11-28 Thread Leyne, Sean
Dmitrijs, I've enabled ARM64 build of firebird2.5 in ubuntu. I don't have access to arm64 machines and hence i have no idea if it actually runs =) it does compile though. While it is good that you worked on the port. If you don't have an platform to test, why would you bother with the

Re: [Firebird-devel] Fwd: ARM64 port

2013-11-28 Thread Dmitrijs Ledkovs
On 28 November 2013 18:26, Leyne, Sean s...@broadviewsoftware.com wrote: Dmitrijs, I've enabled ARM64 build of firebird2.5 in ubuntu. I don't have access to arm64 machines and hence i have no idea if it actually runs =) it does compile though. While it is good that you worked on the port.

Re: [Firebird-devel] Fwd: ARM64 port

2013-11-28 Thread Alex Peshkoff
On 11/28/13 22:52, Dmitrijs Ledkovs wrote: On 28 November 2013 18:26, Leyne, Sean s...@broadviewsoftware.com wrote: Dmitrijs, I've enabled ARM64 build of firebird2.5 in ubuntu. I don't have access to arm64 machines and hence i have no idea if it actually runs =) it does compile though.