Bug 230643 - Stabilize dev-db/sqlite-3.5.9
Bug#: 230643 Product:  Gentoo Linux Version: unspecified Platform: All
OS/Version: Linux Status: RESOLVED Severity: enhancement Priority: P2
Resolution: FIXED Assigned To: betelgeuse@gentoo.org Reported By: arfrever@gentoo.org
Component: Ebuilds
URL: 
Summary: Stabilize dev-db/sqlite-3.5.9
Keywords:  STABLEREQ
Status Whiteboard: 
Opened: 2008-07-03 15:12 0000
Description:   Opened: 2008-07-03 15:12 0000
Stabilize dev-db/sqlite-3.5.9.

------- Comment #1 From Petteri Räty 2008-07-03 20:40:10 0000 -------
(In reply to comment #0)
> Stabilize dev-db/sqlite-3.5.9.
> 

fine by me

------- Comment #2 From Christian Faulhammer 2008-07-05 10:29:06 0000 -------
x86 stable

------- Comment #3 From Brent Baude 2008-07-05 13:42:13 0000 -------
ppc stable

------- Comment #4 From Brent Baude 2008-07-05 13:43:57 0000 -------
ppc64 stable

------- Comment #5 From Ferris McCormick 2008-07-05 15:20:04 0000 -------
Sparc stable, good for over 6 weeks.

------- Comment #6 From Jeroen Roovers 2008-07-05 15:45:06 0000 -------
Stable for HPPA.

------- Comment #7 From Thomas Anderson (tanderson) 2008-07-05 16:34:35 0000 -------
amd64 stable

------- Comment #8 From Raúl Porcel 2008-07-07 10:07:24 0000 -------
alpha/ia64 stable

------- Comment #9 From Coran 2008-09-09 19:49:16 0000 -------
I feel 3.5.9 should not be stable.
3.5.9 has a division problem.  See Debian bug
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=488864

I get the same behavior on Gentoo with 3.5.9, 3.5.6 works properly.  I submit
that 3.5.9 should not be stable.  This breaks some programs like for example
the Sunrise ebuild Anki.  3.5.6 should be the highest stable until this is
fixed. 

>sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> select 1.0/2.0;
0.5
sqlite> select 1.0/3.0;

sqlite> select 1.0/4.0;
0.25
sqlite> select 1.0/5.0;

sqlite> select 1.0/6.0;

sqlite> select 1.0/7.0;

sqlite> select 1.0/8.0;
0.125
sqlite> select 1.0/9.0;

sqlite> select 1.0/10.0;

sqlite>

Here are the version 2 or 3.5.6 results.

>sqlite
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> select 1.0/2.0;
0.5
sqlite> select 1.0/3.0;
0.333333333333333
sqlite> select 1.0/4.0;
0.25
sqlite> select 1.0/5.0;
0.2
sqlite> select 1.0/6.0;
0.166666666666667
sqlite> select 1.0/7.0;
0.142857142857143
sqlite> select 1.0/8.0;
0.125
sqlite> select 1.0/9.10;
0.10989010989011
sqlite> select 1.0/10.0;
0.1
sqlite>

------- Comment #10 From Arfrever Frehtes Taifersar Arahesis 2008-09-09 20:56:40 0000 -------
(In reply to comment #9)
> I feel 3.5.9 should not be stable.

dev-db/sqlite-3.5.9 was stabilized on the majority of architectures over 2
months ago, so you're too late. The only solution is to stabilize a newer
version, but it should happen in another bug.