Re: [firebird-support] gback NULLed columns

2018-06-22 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
> I would first rule out the possibility that the change was not > committed. Both DDL and gbak are transactional, so not having committed > the table change would result in that change not being part of the gbak > backup. Thank you, Mark. So, this is not usual and somehow I should be concerned,

Re: [firebird-support] How can I correctly write this WHERE

2018-06-22 Thread Venus Software Operations venussof...@gmail.com [firebird-support]

Re: [firebird-support] Plan with stored procedure

2018-06-22 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Josef, Firebird 3 shows plan Natural for all procedures. 2.5 also sometimes shows Natural, sometimes - mix of plans of queries inside the procedure. So, you cannot apply this plan to the statement. Regards, Alexey Kovyazin IBSurgeon www.ib-aid.com On 22.06.2018 9:47, josef.gschwendt..

[firebird-support] Re: Plan with stored procedure

2018-06-22 Thread josef.gschwendt...@quattro-soft.de [firebird-support]
Hi, I forgot to write that "SC_Costs" is a stored procedure. Josef