> 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
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
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
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@.
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
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
d...@sqlite.org
___
sqlite-users m
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
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-us
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
@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
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
> 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
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: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
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.
15 matches
Mail list logo