<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "http://bugs.gentoo.org/bugzilla.dtd">

<bugzilla version="2.22.7"
          urlbase="http://bugs.gentoo.org/"
          maintainer="bugzilla@gentoo.org"
>

    <bug>
          <bug_id>230643</bug_id>
          
          <creation_ts>2008-07-03 15:12 0000</creation_ts>
          <short_desc>Stabilize dev-db/sqlite-3.5.9</short_desc>
          <delta_ts>2008-09-28 23:59:44 0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>Gentoo Linux</product>
          <component>Ebuilds</component>
          <version>unspecified</version>
          <rep_platform>All</rep_platform>
          <op_sys>Linux</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <keywords>STABLEREQ</keywords>
          <priority>P2</priority>
          <bug_severity>enhancement</bug_severity>
          <target_milestone>---</target_milestone>
          
          <blocked>224849</blocked>
          
          <everconfirmed>1</everconfirmed>
          <reporter>arfrever@gentoo.org</reporter>
          <assigned_to>betelgeuse@gentoo.org</assigned_to>
          <cc>coran.fisher@gmail.com</cc>

      

      
          <long_desc isprivate="0">
            <who>arfrever@gentoo.org</who>
            <bug_when>2008-07-03 15:12:37 0000</bug_when>
            <thetext>Stabilize dev-db/sqlite-3.5.9.</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>betelgeuse@gentoo.org</who>
            <bug_when>2008-07-03 20:40:10 0000</bug_when>
            <thetext>(In reply to comment #0)
&gt; Stabilize dev-db/sqlite-3.5.9.
&gt; 

fine by me</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>fauli@gentoo.org</who>
            <bug_when>2008-07-05 10:29:06 0000</bug_when>
            <thetext>x86 stable</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>ranger@gentoo.org</who>
            <bug_when>2008-07-05 13:42:13 0000</bug_when>
            <thetext>ppc stable</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>ranger@gentoo.org</who>
            <bug_when>2008-07-05 13:43:57 0000</bug_when>
            <thetext>ppc64 stable</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>fmccor@gentoo.org</who>
            <bug_when>2008-07-05 15:20:04 0000</bug_when>
            <thetext>Sparc stable, good for over 6 weeks.</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>jer@gentoo.org</who>
            <bug_when>2008-07-05 15:45:06 0000</bug_when>
            <thetext>Stable for HPPA.</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>tanderson@gentoo.org</who>
            <bug_when>2008-07-05 16:34:35 0000</bug_when>
            <thetext>amd64 stable</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>armin76@gentoo.org</who>
            <bug_when>2008-07-07 10:07:24 0000</bug_when>
            <thetext>alpha/ia64 stable</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>coran.fisher@gmail.com</who>
            <bug_when>2008-09-09 19:49:16 0000</bug_when>
            <thetext>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. 

&gt;sqlite3
SQLite version 3.5.9
Enter &quot;.help&quot; for instructions
sqlite&gt; select 1.0/2.0;
0.5
sqlite&gt; select 1.0/3.0;

sqlite&gt; select 1.0/4.0;
0.25
sqlite&gt; select 1.0/5.0;

sqlite&gt; select 1.0/6.0;

sqlite&gt; select 1.0/7.0;

sqlite&gt; select 1.0/8.0;
0.125
sqlite&gt; select 1.0/9.0;

sqlite&gt; select 1.0/10.0;

sqlite&gt;

Here are the version 2 or 3.5.6 results.

&gt;sqlite
SQLite version 2.8.17
Enter &quot;.help&quot; for instructions
sqlite&gt; select 1.0/2.0;
0.5
sqlite&gt; select 1.0/3.0;
0.333333333333333
sqlite&gt; select 1.0/4.0;
0.25
sqlite&gt; select 1.0/5.0;
0.2
sqlite&gt; select 1.0/6.0;
0.166666666666667
sqlite&gt; select 1.0/7.0;
0.142857142857143
sqlite&gt; select 1.0/8.0;
0.125
sqlite&gt; select 1.0/9.10;
0.10989010989011
sqlite&gt; select 1.0/10.0;
0.1
sqlite&gt;</thetext>
          </long_desc>
          <long_desc isprivate="0">
            <who>arfrever@gentoo.org</who>
            <bug_when>2008-09-09 20:56:40 0000</bug_when>
            <thetext>(In reply to comment #9)
&gt; 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&apos;re too late. The only solution is to stabilize a newer version, but it should happen in another bug.</thetext>
          </long_desc>
      
    </bug>

</bugzilla>