Bug in Firebird Package

[sugi arto]

This bug found when I was using Firebird 3, tried with Firebird 5 latest version, bug still exist.

Here is the bug

1. Create a package A, in this package, create a procedure like this, procedure test1(inp1 int)

2. Create a package B, and create this procedure that called test1 in package A. 

3. Modify procedure in package A, change its input to test1(inp1 int, inp2 int) and commit. Commit will succeed without any warnings that there's dependency to this is package. 

4. Do backup database, backup also will succeed without any warning

5. Check via latest flamerobin, there's no dependency to package A

Now, restore a backup database, restore will fail and quit prematurely causing all constraints, indices, procedures gone.

Check your backup database, make sure it can be restored correctly! 

On Sat, Jun 14, 2025, 00:00 <firebird...@googlegroups.com> wrote:

firebird...@googlegroups.com

Google Groups

Today's topic summary
View all topics

• Abridged summary of firebird...@googlegroups.com - 2 updates in 1 topic - 3 Updates
• Creating a new database - 10 Updates

Abridged summary of firebird...@googlegroups.com - 2 updates in 1 topic

sugi arto <sug...@gmail.com>: Jun 13 11:08AM +0700 Firebird 5.02   Gbak when doing backup can ran even if password incorrect, is this normal?   ...more

Virgo Pärna <vi...@gaiasoft.ee>: Jun 13 08:41AM +0300 On 13.06.2025 07:08, sugi arto wrote: > Firebird 5.02   > Gbak when doing backup can ran even if password incorrect, is this normal?   Only when database is not in use and connection is not ...more

Mark Rotteveel <ma...@lawinegevaar.nl>: Jun 13 08:50AM +0200 On 13/06/2025 06:08, sugi arto wrote: > Firebird 5.02   > Gbak when doing backup can ran even if password incorrect, is this normal? If you use the commandline that only you uses a database name, ...more

Back to top

Creating a new database

SP Ooi <sp.oo...@gmail.com>: Jun 12 10:01AM -0700 Thank you.   We tried with "isql -a" but no views showed up.   SP Sent from mobile device     On Thu, Jun 12, 2025 at 9:16 AM 'Dimitry Sibiryakov' via firebird-support < ...more

Nikolaus Kern <baur...@gmail.com>: Jun 12 10:08AM -0700 Hello,   I admire the patience of the maintainer of Firebird to respond to questions like this...   If there is no interesst in reading the Firebird book or the available documentation you might ...more

SP Ooi <sp.oo...@gmail.com>: Jun 12 10:10AM -0700 Nikolaus,   I originally just asked if there was an equivalence for gdef & gdl.   But thanks for your comments.   SP Sent from mobile device     ...more

Nikolaus Kern <baur...@gmail.com>: Jun 12 10:20AM -0700 Hi,   I didn´t want to add sarcasm to a very productive group like this.   Nevertheless I am using Firebird for about 20 years now an read about gdef the very first time... It seems that this is ...more

Frank Schlottmann-Gödde <fr...@schlottmann-goedde.de>: Jun 12 07:33PM +0200 Am 12.06.25 um 18:16 schrieb 'Dimitry Sibiryakov' via firebird-support: >> create new databases.   >   I'm not aware of any utility with such name in Firebird starting from > 1.0. ...more

SP Ooi <sp.oo...@gmail.com>: Jun 12 10:44AM -0700 Hi,   Company started using this tool in the 1980s, from Borland Interbase ... to Firebird 1.x on SunOS ... to Firebird 1.5.6 on Linux. We are working on converting more than 665 thousand database ...more

SP Ooi <sp.oo...@gmail.com>: Jun 12 10:46AM -0700 Thank you.   SP Sent from mobile device     On Thu, Jun 12, 2025 at 10:33 AM Frank Schlottmann-Gödde < ...more

Frank Schlottmann-Gödde <fr...@schlottmann-goedde.de>: Jun 12 08:01PM +0200 Am 12.06.25 um 19:44 schrieb SP Ooi:   > We had tried to use "isql -a <database>" to "extract metadata incl. > legacy non-SQL tables" but the output did not produce any "CREATE VIEW" ...more

SP Ooi <sp.oo...@gmail.com>: Jun 12 11:06AM -0700 Hi,   Yes, "show views" showed the views correctly. (Firebird 5.0.1 database)   SP Sent from mobile device     On Thu, Jun 12, 2025 at 11:01 AM Frank Schlottmann-Gödde < ...more

Frank Schlottmann-Gödde <fr...@schlottmann-goedde.de>: Jun 12 08:13PM +0200 Am 12.06.25 um 20:06 schrieb SP Ooi: > Hi,   > Yes, "show views" showed the views correctly. (Firebird 5.0.1 database)   Only the names or also the ddl?   fsg ...more

Back to top

You have received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to firebird-suppo...@googlegroups.com.

[Mark Rotteveel]

On 17/06/2025 04:59, sugi arto wrote:
> This bug found when I was using Firebird 3, tried with Firebird 5 latest
> version, bug still exist.
>
> Here is the bug
> 1. Create a package A, in this package, create a procedure like this,
> procedure test1(inp1 int)
>
> 2. Create a package B, and create this procedure that called test1 in
> package A.
>
> 3. Modify procedure in package A, change its input to test1(inp1 int,
> inp2 int) and commit. Commit will succeed without any warnings that
> there's dependency to this is package.
>
> 4. Do backup database, backup also will succeed without any warning
>
> 5. Check via latest flamerobin, there's no dependency to package A
>
> Now, restore a backup database, restore will fail and quit prematurely
> causing all constraints, indices, procedures gone.
>
> Check your backup database, make sure it can be restored correctly!

Please report bugs on https://github.com/FirebirdSQL/firebird/issues,
and include the SQL statements necessary to reproduce.

Mark
--
Mark Rotteveel