Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Frank Millman" <frank@chagford.com>
Newsgroups: comp.lang.python
Subject: Re: Problem with sqlite3 and Decimal
Date: Sat, 12 Dec 2015 08:22:40 +0200
Lines: 33
Message-ID: <mailman.172.1449901375.12405.python-list@python.org>
References: <n4ei3l$b98$1@ger.gmane.org> <CAPTjJmor6NewucCo7XTSSwyyfbgwCWZ8Jt-MjjkYSjOCFu78_A@mail.gmail.com> <n4ga7r$gil$1@ger.gmane.org> <CAPTjJmoPXFSnXe1QA8MjjncBZBpqNkztha8YHJv=MBm--ZE8jg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de MP5n31IMBd8kDCfpDM6XcAzzBDkbdIiq5CzikhbnyIaw==
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.001
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'only,': 0.07; 'subject:sqlite3': 0.07; 'events.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; ':-)': 0.12; 'curious.': 0.16; 'received:80.91.229.3': 0.16; 'received:io': 0.16; 'received:plane.gmane.org': 0.16; 'received:psf.io': 0.16; 'reproduce': 0.16; 'skip:n 70': 0.16; 'subject:Problem': 0.16; 'wow,': 0.16; 'wrote:': 0.16; 'result,': 0.18; 'why.': 0.18; '2015': 0.20; 'seems': 0.23; 'wrote': 0.23; 'academic': 0.23; 'dec': 0.23; 'sat,': 0.23; 'header:In-Reply-To:1': 0.24; 'testing': 0.25; 'example': 0.26; 'header:X-Complaints-To:1': 0.26; 'separate': 0.27; 'sequence': 0.27; 'idea': 0.28; 'initial': 0.28; 'workaround': 0.29; 'post': 0.31; 'that,': 0.34; 'but': 0.36; 'to:addr:python-list': 0.36; 'pm,': 0.36; 'subject:: ': 0.37; 'really': 0.37; 'thanks': 0.37; 'received:org': 0.37; '12,': 0.37; 'thought': 0.37; 'goes': 0.39; 'sure': 0.39; 'to:addr:python.org': 0.40; 'subject:with': 0.40; 'still': 0.40; 'your': 0.60; 'interest': 0.64; 'here': 0.66; 'frank': 0.72; 'satisfied': 0.83; 'why?': 0.91
X-Injected-Via-Gmane: http://gmane.org/
X-Gmane-NNTP-Posting-Host: 197.82.211.31
In-Reply-To: <CAPTjJmoPXFSnXe1QA8MjjncBZBpqNkztha8YHJv=MBm--ZE8jg@mail.gmail.com>
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3502.922
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3502.922
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.20+
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Xref: csiph.com comp.lang.python:100321

"Chris Angelico"  wrote in message 
news:CAPTjJmoPXFSnXe1QA8MjjncBZBpqNkztha8YHJv=MBm--ZE8jg@mail.gmail.com...

> On Sat, Dec 12, 2015 at 4:10 PM, Frank Millman <frank@chagford.com> wrote:
> > I can reproduce your example above. However, if I set the initial value 
> > to
> > 5678.7, then the sequence goes
> >
> > 5678.7
> > 5802.15
> > 5925.6
> > 6049.05
> > 6172.5
> >
> > I would have thought that adding 123.45 to 5802.15 would always produce 
> > the
> > same result, but here it seems to depend on prior events.
> >
> > Any idea why? Academic interest only, but I am curious.
>
> You weren't adding 123.45 to 5802.15. Here's why.

[snip really interesting explanation]

Wow, thanks for that, Chris. Consider my academic curiosity well and truly 
satisfied :-)

I have found a workaround for my problem, but I will post that in a separate 
message - still testing to make sure it is 100%.

Frank