Bug 8046 - Update candidate for firebird-2.5.1.26351.0-3
Summary: Update candidate for firebird-2.5.1.26351.0-3
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 2
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: QA Team
QA Contact:
URL:
Whiteboard: has_procedure, MGA2-32-OK, MGA2-64-OK
Keywords: validated_update
Depends on:
Blocks:
 
Reported: 2012-11-11 17:40 CET by Philippe Makowski
Modified: 2012-11-17 17:47 CET (History)
2 users (show)

See Also:
Source RPM: firebird-2.5.2.26539-1.mga2
CVE:
Status comment:


Attachments

Description Philippe Makowski 2012-11-11 17:40:45 CET
firebird-2.5.2.26539-1.mga2  is an upstream bug fix release
(http://tracker.firebirdsql.org/browse/CORE/fixforversion/10450)

example of bug fix upstream :http://tracker.firebirdsql.org/browse/CORE-3806

to test it under Mageia :

urpmi 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;


before the update, the wrong result was :
SQL> select col2, col3 from t as t1 where exists (select * from t as t2 order by t1.col2 );

        COL2         COL3 
============ ============ 
         200          200 
         201          201 
         202          202 


Advisory
-----------------------
Upstream bugfix release that fix various bug and potentials server crash

(http://tracker.firebirdsql.org/browse/CORE/fixforversion/10333)
(http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#bug-252)
Philippe Makowski 2012-11-11 17:45:20 CET

Assignee: bugsquad => qa-bugs
Source RPM: (none) => firebird-2.5.1.26351.0-3

Comment 1 claire robinson 2012-11-11 18:44:19 CET
Thanks for the procedure Philippe

SRPM: firebird-2.5.2.26539-1.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

Source RPM: firebird-2.5.1.26351.0-3 => firebird-2.5.2.26539-1.mga2
Whiteboard: (none) => has_procedure

Comment 2 Marc Lattemann 2012-11-11 22:20:29 CET
Thanks for the detailed procedure. Tested successfully for mga2 i586 and x86_64.

validate update:

Advisory
-----------------------
Upstream bugfix release that fix various bug and potentials server crash

(http://tracker.firebirdsql.org/browse/CORE/fixforversion/10333)
(http://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes252.html#bug-252)

SRPM: firebird-2.5.2.26539-1.mga2.src.rpm

Could sysadmin push packages to updates? Thanks.

Keywords: (none) => validated_update
CC: (none) => sysadmin-bugs
Whiteboard: has_procedure => has_procedure, MGA2-32-OK, MGA2-64-OK

Comment 3 Thomas Backlund 2012-11-17 17:47:53 CET
Update pushed:
https://wiki.mageia.org/en/Support/Advisories/MGAA-2012-0223

Status: NEW => RESOLVED
CC: (none) => tmb
Resolution: (none) => FIXED


Note You need to log in before you can comment on or make changes to this bug.