Re: Problem with sqlite3 and Decimal

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> (permalink)
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

Show key headers only | View raw

"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

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Problem with sqlite3 and Decimal "Frank Millman" <frank@chagford.com> - 2015-12-12 08:22 +0200

csiph-web