Re: [sqlite] SQLite with branching

2019-11-04 Thread Jens Alfke
> 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

Re: [sqlite] Rounding Error

2019-11-04 Thread Keith Medcalf
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

Re: [sqlite] SQLite with branching

2019-11-04 Thread Simon Slavin
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

[sqlite] althttpd systemd unit files

2019-11-04 Thread Carl Chave
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@.

Re: [sqlite] 3.31

2019-11-04 Thread x
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

Re: [sqlite] 3.31

2019-11-04 Thread Richard Hipp
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

Re: [sqlite] Rounding Error

2019-11-04 Thread Keith Medcalf
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

[sqlite] 3.31

2019-11-04 Thread x
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

Re: [sqlite] Rounding Error

2019-11-04 Thread Keith Medcalf
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

Re: [sqlite] SQLite with branching

2019-11-04 Thread Robert M. Münch
@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

Re: [sqlite] Rounding Error

2019-11-04 Thread Graham Holden
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

Re: [sqlite] Rounding Error

2019-11-04 Thread Jay Kreibich
> 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

Re: [sqlite] Rounding Error

2019-11-04 Thread Simon Slavin
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

Re: [sqlite] Rounding Error

2019-11-04 Thread Jay Kreibich
> 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

[sqlite] Rounding Error

2019-11-04 Thread Adrian Sherwin
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.