Re: [sqlite] Question about floating point

2018-12-26 Thread Rowan Worth
On Sat, 15 Dec 2018 at 15:10, Frank Millman wrote: > On Dec 15, 2018, at 08.58, Jay Kreibich wrote: > > > > On Dec 15, 2018, at 12:49 AM, Frank Millman > wrote: > > > > > > I know that floating point is not precise and not suitable for > financial uses. Even so, I am curious about the following

Re: [sqlite] [Question] Non-EXCLUSIVE modes in dot-file locking strategy

2018-12-26 Thread Rowan Worth
On Sun, 16 Dec 2018 at 05:00, Pierre Tempel wrote: > > “... programs which rely on [the O_CREAT and O_EXCL flags of > > open(2) to work on filesystems accessed via NFS version 2] for > > performing locking tasks will contain a race condition. The solution > > for performing atomic file locking

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

2018-12-26 Thread Mark Johnson
Am Do., 27. Dez. 2018 um 02:53 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > (summery of the last messages that were sent as email) > > >> Please add the list of column names after the view name: > >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ... > >> I have a note to improve the

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

2018-12-26 Thread Mark Johnson
(summery of the last messages that were sent as email) >> Please add the list of column names after the view name: >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ... >> I have a note to improve the documentation about this point. So would the following be true: To insure that a constant,

Re: [sqlite] Unable to import CSV file correctly when using ext/misc/csv.c as the csv module.

2018-12-26 Thread D Burgess
There is also a problem with the documentation on csv.c Example from the source comments: CREATE VIRTUAL TABLE temp.csv2 USING csv( filename = "../http.log", schema = "CREATE TABLE x(date,ipaddr,url,referrer,userAgent)" ); It should be noted that the schema= parameter

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

2018-12-26 Thread Richard Hipp
On 12/26/18, Mark Johnson wrote: > Am Do., 20. Dez. 2018 um 16:34 Uhr schrieb Mark Johnson < > mj10...@googlemail.com>: > >> Based on ticket >> >> https://www.sqlite.org/src/tktview?name=43ddc85a63 >> >> >> >> However, the column count is not correct. >> In my case 2 columns are missing: which

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

2018-12-26 Thread Mark Johnson
Am Do., 20. Dez. 2018 um 16:34 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > Based on ticket > > https://www.sqlite.org/src/tktview?name=43ddc85a63 > > > > However, the column count is not correct. > In my case 2 columns are missing: which should be 19. > After a fresh look at this today,

Re: [sqlite] Unable to import CSV file correctly when using ext/misc/csv.c as the csv module.

2018-12-26 Thread Richard Hipp
Fixed at https://www.sqlite.org/src/info/7acaed08f946633f On 12/25/18, hi jack wrote: > The SQLite source code version I’m using is the latest public release > version 3.26.0. > >

[sqlite] Unable to import CSV file correctly when using ext/misc/csv.c as the csv module.

2018-12-26 Thread hi jack
The SQLite source code version I’m using is the latest public release version 3.26.0. -- Reproduce steps: 1. Prepare a file data.csv. The content is a,b,c,d

Re: [sqlite] Simple way to import GPX file?

2018-12-26 Thread John McMahon
I know I am coming to this a couple of weeks late, but I have been doing this for several years and thought I would add my 2 cents worth. Probably too late for OP, but may be useful for someone else later. I used gpsbabel like this initially (in a JPSoft 4nt/tcmd script), gpsbabel -i gpx ^

Re: [sqlite] Typo

2018-12-26 Thread Richard Hipp
Thanks. Fixed at https://www.sqlite.org/docsrc/info/2ffc105f81a74dad and on the website. On 12/26/18, Wolfgang Enzinger wrote: > > Another one in https://www.sqlite.org/security.html: > > "... even with presented with maliciously malformed SQL inputs or database > files." > > Should be "...

Re: [sqlite] Typo

2018-12-26 Thread Wolfgang Enzinger
Am Tue, 25 Dec 2018 08:59:45 +0100 schrieb gwenn: > There is a typo here: > https://sqlite.org/session/sqlite3changeset_op.html >> If pbIncorrect is not NULL, then *pbIndirect is set to true > Should be pbIndirect instead of pbIncorrect. Another one in https://www.sqlite.org/security.html: "...

Re: [sqlite] i Know i should use 'AS', but ....

2018-12-26 Thread Luuk
On 26-12-2018 08:20, Clemens Ladisch wrote: Luuk wrote: sqlite> .mode column sqlite> .headers on sqlite> select 1 as X,date() as d union all select 2,date() union all select 3,datetime(); X   d --  -- 1   2018-12-25 2   2018-12-25 3   2018-12-25