Bug 8046

Summary:	Update candidate for firebird-2.5.1.26351.0-3
Product:	Mageia	Reporter:	Philippe Makowski <makowski.mageia>
Component:	RPM Packages	Assignee:	QA Team <qa-bugs>
Status:	RESOLVED FIXED	QA Contact:
Severity:	normal
Priority:	Normal	CC:	sysadmin-bugs, tmb
Version:	2	Keywords:	validated_update
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:	has_procedure, MGA2-32-OK, MGA2-64-OK
Source RPM:	firebird-2.5.2.26539-1.mga2	CVE:
Status comment:

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