Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
.com/stevedrake/uib> > > > > > > > From: firebird-support@yahoogroups.com > <mailto:firebird-support@yahoogroups.com> <mailto:firebird-support@yahoogroups.com>> > Sent: Thursday, 14 February 2019 6:30 AM > To: Firebird Support <mailto:fireb

RE: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
stops functioning correctly after restore under Firebird 3 Thanks Mark. I realize it’s a huge migration. I will be exhaustively testing everything. I like the idea of creating an empty database and pumping the data over. Is there a tool for this? (Actually just found one from Clever Components

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-2-2019 18:29, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > Thanks Mark. I realize it’s a huge migration. I will be exhaustively > testing everything. I like the idea of creating an empty database and > pumping the data over. Is there a tool for this?

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.02.2019 18:29, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I like the idea of creating an empty database and pumping the data over. Is > there a tool > for this? (Actually just found one from Clever Components) I'd recommend to look at FBCopy/FBExport tools.

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
The restore are not validating the Stored Procedures! After recreation in FB3 you have to validate/compile you SP! Regards Gregor Sent from Yahoo Mail. Get the app https://yho.com/148vdq

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
Thanks Mark. I realize it’s a huge migration. I will be exhaustively testing everything. I like the idea of creating an empty database and pumping the data over. Is there a tool for this? (Actually just found one from Clever Components) I have looked at the migration docs for the 2.x

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-2-2019 16:58, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I’m starting to look into migrating from 1.56 to either 2.5 or directly to > 3.0. I’ve bought the Migration Guide but haven’t read it yet. > > It concerns me that I would/will have to recompile all

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.02.2019 16:39, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > My bet is on the addition of the savepoint. Yes, this is the way partial cursor stability is implemented in 3.0: insert-select cannot see changes made inside of the same savepoint, so sub-query in second query

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
I’m starting to look into migrating from 1.56 to either 2.5 or directly to 3.0. I’ve bought the Migration Guide but haven’t read it yet. It concerns me that I would/will have to recompile all SPs and triggers. Is there an automated way to do this? I have 909 SPs and 785 triggers. This will

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
I can reproduce it (Firebird 2.5.8 to Firebird 3.0.4). I suggest that you create a ticket in the tracker. The problem doesn't sound familiar to me, and if it is a known problem, the core developers will close appropriately to an existing duplicate. Looking at the BLR (using set blob all in

[firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

2019-02-13 Thread david.holli...@parcelperfect.com [firebird-support]
When migrating from Firebird 2.5 to Firebird 3 we have a number of stored procedures that stop functioning correctly. They start working again once the procedures have been rebuilt from script. The procedures all perform something along the lines of inserting a record with a default value and then