From Mageia wiki
Firebird is a database system.
SRPM: firebird-2.5.2.26539-2.mga2.src.rpm ----------------------------------------- firebird-classic firebird-devel firebird firebird-server-classic firebird-server-common firebird-server-superserver firebird-superclassic firebird-superserver firebird-utils-classic firebird-utils-common firebird-utils-superserver lib64fbclient2 lib64fbembed2
If you've previously tested firebird and the isql-fb command complains "Your user name and password are not defined" or some other error then removing /var/lib/firebird will clear all old data and allow you to start fresh.
# urpmi firebird firebird-superserver
# systemctl start firebird-superserver.service
$ isql-fb localhost:employee -user SYSDBA -password masterkey
Database: localhost:employee, User: SYSDBA
SQL> create table t (col1 int, col2 int, col3 int);
SQL> insert into t values (100, 200, 300);
SQL> insert into t values (101, 201, 301);
SQL> insert into t values (102, 202, 302);
SQL> commit;
SQL> alter table t drop col1;
SQL> select col2, col3 from t as t1 where exists (select * from t as t2 order by t1.col2 );
COL2 COL3
============ ============
200 300
201 301
202 302
SQL> commit;
SQL> drop table t;
SQL> exit;
