Hi,
I would like to report the following as a bug in SQLITE:
The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers
correctly to x decimal places when held as x+1 decimal places.
The simplest example I have found with x=1 is:
"select round(1.15,1)"
Result: "1.1" (should be 1.
> On Nov 4, 2019, at 2:41 AM, Adrian Sherwin wrote:
>
> Hi,
>
> I would like to report the following as a bug in SQLITE:
>
> The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers
> correctly to x decimal places when held as x+1 decimal places.
>
> The simplest example I h
On 4 Nov 2019, at 8:41am, Adrian Sherwin wrote:
> The simplest example I have found with x=1 is:
> "select round(1.15,1)"
> Result: "1.1" (should be 1.2)
SQL1992 4.4.1 Characteristics of numbers:
" An approximation obtained by truncation or rounding of a numerical
value N for an T is a value
> On Nov 4, 2019, at 2:59 AM, Jay Kreibich wrote:
>
>
>> On Nov 4, 2019, at 2:41 AM, Adrian Sherwin wrote:
>>
>> Hi,
>>
>> I would like to report the following as a bug in SQLITE:
>>
>> The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers
>> correctly to x decimal plac
Monday, November 04, 2019, 8:41:48 AM, Adrian Sherwin
wrote:
> Hi,
> I would like to report the following as a bug in SQLITE:
> The SQLITE "round" function fails to round between 4.1 and 4.6% of numbers
> correctly to x decimal places when held as x+1 decimal places.
> The simplest example I
@SQLite Guys: Do you have something like branching on your roadmap? I really
like this feature and see a lot of use-cases beside the blockchain topic. And,
of course if this works with your encryption extension that would be awesome.
* simple versioning of a database: Useful when you want to kee
On Monday, 4 November, 2019 02:10, Jay Kreibich wrote:
>> On Nov 4, 2019, at 2:59 AM, Jay Kreibich wrote:
>>> On Nov 4, 2019, at 2:41 AM, Adrian Sherwin wrote:
>>> The simplest example I have found with x=1 is:
>>> "select round(1.15,1)"
>>> Result: "1.1" (should be 1.2)
>> SQLite uses the IEEE
I’m eager to try out the new virtual columns (thanks Richard and team). Is it
imminent or is there a beta for testing?
___
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-us
On Monday, 4 November, 2019 02:16, Graham Holden wrote:
>This is almost certainly because (according to
>https://www.h-schmidt.net/FloatConverter/IEEE754.html) the number
>"1.15" cannot be expressed exactly in floating-point; the nearest
>expressible number being 1.1497615814208984375, and p
On 11/4/19, x wrote:
> I’m eager to try out the new virtual columns (thanks Richard and team). Is
> it imminent or is there a beta for testing?
Use the "Prerelease Snapshot" from the download page.
--
D. Richard Hipp
[email protected]
___
sqlite-users m
Thanks Richard.
From: sqlite-users on behalf of
Richard Hipp
Sent: Monday, November 4, 2019 11:55:31 AM
To: SQLite mailing list
Subject: Re: [sqlite] 3.31
On 11/4/19, x wrote:
> I’m eager to try out the new virtual columns (thanks Richard and team). Is
> it
Without commenting on the security (or lack thereof) of any of the
settings below, here are the systemd unit files I'm using on Centos.
As the documentation only provides an example for Xinetd I thought I'd
submit these for possible inclusion:
[root@www sodface]# cat /etc/systemd/system/althttpd@.
The post you quoted points to exactly that: a version of SQLite that handles
branches. Check it out.
That's one of the reasons that the source code for SQLite is public: so that
people can add the features they want.
___
sqlite-users mailing list
sqli
On Monday, 4 November, 2019 02:10, Jay Kreibich wrote:
>OK, no, I’m wrong. Because 1.05 rounds to 1.1, even though the
>representation is 1.049523162841796875.
The representation of 1.05 is 1.0500444089209 and the next closest
representable number is 1.049822364316
> On Nov 4, 2019, at 4:57 AM, Simon Slavin wrote:
>
> That's one of the reasons that the source code for SQLite is public: so that
> people can add the features they want.
Totally agree. However, when you go off the mainline of SQLite you lose some
things, like easy updating to new SQLite re
15 matches
Mail list logo
