Re: [sqlite] Relax "DISTINCT aggregates" error

Dominique Devienne, on Friday, November 15, 2019 09:02 AM, wrote... > > As can be seen below, the last query fail, despite the one before it > succeeding. > Yet the second argument is constant, thus it would seem "natural" for it to > work as well. > Could the error be "relaxed", when the

Re: [sqlite] Adding a record to a table with one value change

Simon Slavin, on Thursday, November 14, 2019 06:48 PM, wrote... > > On 14 Nov 2019, at 10:27pm, Jake Thaw, on > > > Why not like this? > > > > insert into t (a, b, c, d, e, idate) > > SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p001' ORDER BY > > idate desc limit 1; > > Dammit. I

Re: [sqlite] Adding a record to a table with one value change

Keith Medcalf, on Thursday, November 14, 2019 06:44 PM, wrote... > > > On Thursday, 14 November, 2019 15:27, Jake Thaw, on > > >Why not like this? > > >insert into t (a, b, c, d, e, idate) > >SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p001' ORDER BY > >idate desc limit 1; > > Or, if

Re: [sqlite] Adding a record to a table with one value change

his. Thanks again. josé > On Fri, Nov 15, 2019 at 9:19 AM Simon Slavin, on > > > > On 14 Nov 2019, at 10:06pm, Jose Isaias Cabrera, on > > > > > insert into t (a, b, c, d, e, idate) values > > > ( > > >(SELECT a FROM t WHERE a = 'p001' ORDER

Re: [sqlite] Adding a record to a table with one value change

Simon Slavin, on Thursday, November 14, 2019 05:18 PM, wrote... > > On 14 Nov 2019, at 10:06pm, Jose Isaias Cabrera, on > > > insert into t (a, b, c, d, e, idate) values > > ( > >(SELECT a FROM t WHERE a = 'p001' ORDER BY idate desc limit 1), > >(SELEC

[sqlite] Adding a record to a table with one value change

Greetings! I have this table, create table t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate); insert into t (a, b, c, d, e, idate) values ('p001', 1, 2, 'n', 4, '2019-02-11'); insert into t (a, b, c, d, e, idate) values ('p002', 2, 2, 'n', 4, '2019-02-11'); insert into t (a, b, c, d, e, idate)

Re: [sqlite] Things you shouldn't assume when you store names

Simon Slavin, on Wednesday, November 13, 2019 05:27 PM, wrote...​ ​ > By the way, Keith, 'Medcalf' is possibly the oldest known English surname > (13th Century) and indicates that one​ > of your ancestors raised or slaughtered cows.​ ​ Researching my last name, Cabrera, I found out that it

Re: [sqlite] Things you shouldn't assume when you store names

> > ​ ​ Keith Medcalf, on Wednesday, November 13, 2019 05:19 PM, wrote...​ >​ > Its like the stupid "security questions" thing. I always answer them with a > vulgarity.​ ​ I knew this!!​ ​ josé ___ sqlite-users mailing list

Re: [sqlite] Things you shouldn't assume when you store names

Peter da Silva, on Wednesday, November 13, 2019 04:37 PM, wrote... > > My last name has a space in it. It's been less than a month since the last > time it was rejected by a form. One of my oldest online friends has only > one name. Assume nothing, permit everything. We still need to know that

Re: [sqlite] Why do these 2 updates give different results?

Donald Griggs, on Wednesday, November 13, 2019 12:26 PM, wrote... > > > > > When dealing with ED and sildenafil, getting a NULL result disappoints > > everyone. ;-) > > Good one! NOT that **I** know anything about that. Hahahahah... ___

Re: [sqlite] Why do these 2 updates give different results?

Bart Smissaert, on Wednesday, November 13, 2019 12:22 PM, wrote... > > Yes, you right and have seen what happens. > Indeed, does less update should say less updates to 1. > Indeed, the clause "QR3PARAMS.ED = 1 is superfluous. > I can see that in the second one the problem is with the update to

Re: [sqlite] Why do these 2 updates give different results?

David Raymond, on Wednesday, November 13, 2019 10:34 AM, wrote... > > "Why is ED changed to '' or NULL for ID 5?" > > When you update to a subquery which returns no rows, then the field gets > updated to null. So, I have to address "no matches or no rows returned" in another subquery. Huh!

Re: [sqlite] Why do these 2 updates give different results?

Bart Smissaert, on Wednesday, November 13, 2019 06:41 AM, wrote... > > UPDATE QR3PARAMS SET ED = > CASE WHEN ED = 1 THEN 1 > ELSE > (SELECT 1 FROM CURRENT_MED WHERE > (QR3PARAMS.ED = 1 OR TERM_TEXT GLOB 'Sildenafil*' OR TERM_TEXT GLOB > 'Tadalafil*' OR TERM_TEXT GLOB 'Vardenafil*') > AND ID =

Re: [sqlite] Things you shouldn't assume when you store names

Igor Tandetnik, on Monday, November 11, 2019 02:56 PM, wrote... > > On 11/11/2019 12:30 PM, Jose Isaias Cabrera wrote: > > > > Igor Tandetnik, on Monday, November 11, 2019 11:02 AM, wrote... > >>> Most people have to figure out what Unicode they are using,

Re: [sqlite] Things you shouldn't assume when you store names

Richard Damon, on Monday, November 11, 2019 02:37 PM, wrote... > > No. Aaaah, my apologies. We are talking about different things. You are talking about a combination of Unicodes vs. full, character. I take it back. Yes, if you are combining these, then, of course, you are going to have to

Re: [sqlite] Things you shouldn't assume when you store names

Igor Tandetnik, on Monday, November 11, 2019 02:24 PM, wrote... > > On 11/11/2019 12:50 PM, Richard Damon wrote: > > Writing 20 UTF-32 characters may ALSO print less than 20 glyphs to the > > screen. > > Or more, depending on what you mean by "glyph". See e.g. U+FDFB (ARABIC > LIGATURE

Re: [sqlite] Things you shouldn't assume when you store names

Jens Alfke, on Monday, November 11, 2019 01:00 PM, wrote... > > > On Nov 11, 2019, at 9:39 AM, Jose Isaias Cabrera, on > > > > However, space is cheap now > > It isn't. A sizable fraction of all software development is done for devices > with > under a megabyte o

Re: [sqlite] Things you shouldn't assume when you store names

Richard Damon, on Monday, November 11, 2019 12:50 PM, wrote... > Writing 20 UTF-32 characters may ALSO print less than 20 glyphs to the > screen. This is not true, if the string has more or at least 20 UTF32 characters, and you request 20 character while still talking UTF32, it will print 20.

Re: [sqlite] Things you shouldn't assume when you store names

Jens Alfke, on Monday, November 11, 2019 12:47 PM, wrote... > > Hang on — why exactly 20 characters? Of text in an arbitrary language, which > is to be displayed in an arbitrary font, with an arbitrary line width? > > I don't know about you, but the only time I think about "exactly 20 >

Re: [sqlite] Things you shouldn't assume when you store names

Richard Damon, on Monday, November 11, 2019 11:19 AM, wrote... > UTF-32 is a reasonable internal operation format, if code-point > operations are important. It does not make a good transmission format, I agree. That is why, I have not created any files for anything as UTF32 for delivery or

Re: [sqlite] Things you shouldn't assume when you store names

Igor Tandetnik, on Monday, November 11, 2019 11:02 AM, wrote... > > On 11/11/2019 10:49 AM, Jose Isaias Cabrera wrote: > > So, yes, it's bulky, but, if you want to count characters in languages such > > as > > Arabic, Hebrew, Chinese, Japanese, etc., the e

Re: [sqlite] Things you shouldn't assume when you store names

Richard Damon, on Monday, November 11, 2019 09:47 AM, wrote... > > On 11/11/19 9:26 AM, Jose Isaias Cabrera wrote: > > Simon Slavin, on Monday, November 11, 2019 08:50 AM, wrote... > >> On 11 Nov 2019, at 1:35pm, Jose Isaias Cabrera, on > >> > >>> Not i

Re: [sqlite] Things you shouldn't assume when you store names

Simon Slavin, on Monday, November 11, 2019 08:50 AM, wrote... > > On 11 Nov 2019, at 1:35pm, Jose Isaias Cabrera, on > > > Not if the system uses UTF32. :-) You could put the pictograph in that that > > textbox, and it'll work. > > Can you point to some descripti

Re: [sqlite] Things you shouldn't assume when you store names

Richard Damon, on Sunday, November 10, 2019 07:01 AM, wrote... > Actually, 'The Artist whose name formerly was Prince' (which wasn't his > name, his legal name was an unpronounceable pictograph), breaks every > computer system I know. Not if the system uses UTF32. :-) You could put the

Re: [sqlite] Reading a SharePoint file

Jose Isaias Cabrera, on Friday, November 8, 2019 03:32 PM, wrote... > > Jens Alfke, on Friday, November 8, 2019 03:25 PM, wrote... > > > > On Nov 8, 2019, at 12:21 PM, Jose Isaias Cabrera, on > > > > > > Yeah, that is what I am doing now. I was trying to sav

Re: [sqlite] Reading a SharePoint file

Jens Alfke, on Friday, November 8, 2019 03:25 PM, wrote... > > On Nov 8, 2019, at 12:21 PM, Jose Isaias Cabrera, on > > > > Yeah, that is what I am doing now. I was trying to save time [clip] > SharePoint might support WebDAV, and most OSs support (or used to support)

Re: [sqlite] Reading a SharePoint file

Jens Alfke, on Friday, November 8, 2019 03:16 PM, wrote... > > > On Nov 8, 2019, at 11:57 AM, Jose Isaias Cabrera, on > > > > Is there any way that SQLite can read a file on a Sharepoint site? > > Download the file over HTTP and then open the local file with SQLit

Re: [sqlite] Reading a SharePoint file

Simon Slavin, on Friday, November 8, 2019 03:15 PM, wrote... > > On 8 Nov 2019, at 7:57pm, Jose Isaias Cabrera, on > > > Is there any way that SQLite can read a file on a Sharepoint site? > > Not without downloading it to a local drive

[sqlite] Reading a SharePoint file

Is there any way that SQLite can read a file on a Sharepoint site? ie https://some.site.com/sites/ROC/Docs%20comp/Shared.Projects_DB.sqlite3 Thanks.

Re: [sqlite] Rounding Error

Adrian Sherwin, on Monday, November 4, 2019 03:41 AM, 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

Re: [sqlite] Count error?

t; > > ; Thanks. Works. josé > On 11/1/2019 9:07 AM, Jose Isaias Cabrera wrote: > > Jose Isaias Cabrera, on Friday, November 1, 2019 11:51 AM, wrote... > >> > >> Richard Hipp, on Friday, November 1, 2019 11:41 AM, wrote... > >>> On 11/1/19, Jose Is

Re: [sqlite] Count error?

Jose Isaias Cabrera, on Friday, November 1, 2019 11:51 AM, wrote... > > > Richard Hipp, on Friday, November 1, 2019 11:41 AM, wrote... > > > > On 11/1/19, Jose Isaias Cabrera, on > > > sqlite> select count(a.n),count(b.n),count(c.n) FROM t0 AS a LEFT JOIN t1 &

Re: [sqlite] Count error?

Richard Hipp, on Friday, November 1, 2019 11:41 AM, wrote... > > On 11/1/19, Jose Isaias Cabrera, on > > sqlite> select count(a.n),count(b.n),count(c.n) FROM t0 AS a LEFT JOIN t1 AS > > b LEFT JOIN t2 AS c; > > 3375|3375|3375 > > > > Huh? I expected t

[sqlite] Count error?

Greetings. Please take a look at the following: create table t0 (n INTEGER PRIMARY KEY, a, b, c, d, e, idate); insert into t0 (a, b, c, d, e, idate) values ('p001', 'a', 1, 'n', 4, '2019-02-11'); insert into t0 (a, b, c, d, e, idate) values ('p002', 'a', 1, 'n', 4, '2019-02-11'); insert

Re: [sqlite] Network file system that support sqlite3 well

Peng Yu, on Tuesday, October 15, 2019 06:47 PM, wrote... > > Hi, > > I'd like to use sqlite3 db files on many compute nodes. But they > should access the same storage device for the sqlite3 db files. The > directory storing the db files looks the same on any compute node > logically---the storage

Re: [sqlite] Last record

Keith Medcalf, on Tuesday, October 15, 2019 02:26 PM, wrote... > > > On Tuesday, 15 October, 2019 09:35, Philippe RIO, on > > >A short question : how could I know if I am reading the last record with > >sqlite (sqlite3_step)? sqlite3_step only returns SQLITE_ROW. Is there a > >function for that

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:31 PM, wrote... > Imagine a vehicle which has wheels to drive on a road. And wings to fly and > a hull to float. How nice and happy world would be !? True? Of course true. > > But, this vehicle would be bad as a car, bad as an airplane and bad a

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Roman Fleysher, on Thursday, October 10, 2019 04:17 PM, wrote... > > With your brain excluded, who is "we"? > > The beauty of SQLite is that SQL was distilled to the smallest and most > reproducible > on many platforms set. Over time, I see how developers expand functionality > to make it >

Re: [sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Simon Slavin, on Thursday, October 10, 2019 04:12 PM, wrote... > > On 10 Oct 2019, at 9:03pm, Jose Isaias Cabrera, on > > > 2. The normal SQlite snapshots plus a series of libraries and functions that > can easily be compiled with the original light SQLite. > > Here's

[sqlite] SQLite plus the works (was Re: Opposite of SQLite)

Simon Slavin, on Thursday, October 10, 2019 03:42 PM, wrote... > > On 10 Oct 2019, at 7:55pm, Ned Fleming, on > > > SQLessLite > > SQDietStartsMonday All kidding aside, and naming continuing, :-), I believe the world will be a happier place with: 1. The normal SQLite snapshots (just like it's

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Jose Isaias Cabrera, on Thursday, October 10, 2019 08:55 AM, wrote... > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > > the Django ORM we discovered a crash that can be reduced

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

> > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > While trying to enable support for FILTER (WHERE) on SQLite 3.30 for > the Django ORM we discovered a crash that can be reduced to the > following > > sqlite> CREATE TABLE item (id int, price int); > sqlite> INSERT INTO item

Re: [sqlite] Date time input

James K. Lowden, on Tuesday, October 8, 2019 02:39 PM, wrote... > > On Tue, 8 Oct 2019 09:06:24 -0700 > Jens Alfke, on > > > I think the idea of a semi-official ?SQLite++? has been floated here > > before > > OK, but it needs a better name. What better place than here to debate > that? ;-)

Re: [sqlite] Date time input

Jens Alfke, on Tuesday, October 8, 2019 12:06 PM, wrote... > > > > On Oct 8, 2019, at 5:34 AM, Jose Isaias Cabrera, on > > > > No, that is not what I was trying to say or ask. Not even close. What I was > trying to say, and most of you missed it was, that if I

Re: [sqlite] [EXTERNAL] Re: Date time input

Shawn Wagner, on Tuesday, October 8, 2019 09:40 AM, wrote... > > So, I have a bunch of sqlite extension modules that I really should polish > up for an official release Real Soon Now... > > I just added a basic interface to the POSIX strptime() function to the > string functions library: > >

Re: [sqlite] [EXTERNAL] Re: Date time input

Hick Gunter, on Tuesday, October 8, 2019 08:46 AM, wrote... > > What it boils down to is asking the data storage layer to perform a > presentation > layer task. Thanks, Hick. > > If you insist on solving the problem inside an SQL statement, you can always > write your own extension function to

Re: [sqlite] Date time input

Jens Alfke, on Monday, October 7, 2019 09:18 PM, wrote... [clip] > I swear, half the questions on this list build down to "Why doesn't > SQLite act like MS Access?" If you need all the bells and whistles of > formatting > input and output, then use a fancy DBMS application. SQLite is for

[sqlite] Date time input

Greetings. I have to ask this question: Why is it that the date function does not take a '4/5/2019' and returns '2019-04-05'? This may have been asked before, and the answer may be some where in the internet, but, I could not find it. The other thing is that it would be nice to have date

Re: [sqlite] Lookup join

Richard Hipp, on Tuesday, October 1, 2019 02:05 PM, wrote... > > On 10/1/19, Fredrik Larsen, on > > > > The declarative model of SQL is nice, but when you care about performance, > > it quickly gets frustrating and time consuming. > > In a perfect world, the query planner would recognize your

Re: [sqlite] Fossil Public Accounts

Warren Young, on Tuesday, October 1, 2019 12:38 PM, wrote... > > On Oct 1, 2019, at 8:02 AM, J. King, on > > > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera, on > >> > >> Is there a Fossil public account site like git? > > Git doesn’t

Re: [sqlite] Fossil Public Accounts

J. King, on Tuesday, October 1, 2019 10:02 AM, wrote... > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera, on > > > >Is there a Fossil public account site like git? I believe there are a > >lot of people that can use something like that. Thoughts? O

[sqlite] Fossil Public Accounts

Is there a Fossil public account site like git? I believe there are a lot of people that can use something like that. Thoughts? Or not. josé ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Safe to use SQLite over a sketchy network?

Randall Smith, on Tuesday, September 24, 2019 05:14 PM, wrote...​ > ​ > I have an application where remote users will be connecting to a SQLite DB > over a network​ > connection that seems to be somewhat sketchy (I can't characterize it well; > I'm hearing​ > this second-hand).​ > ​ > My

Re: [sqlite] Schedule Up - 26th Annual Tcl/Tk Conference (Tcl'2019)

Richard Hipp, on Monday, September 23, 2019 05:10 PM, wrote...​ ​ > I am presenting an 8-hour tutorial on SQLite internals on Tuesday​ > (2019-11-05). Have you signed up for that yet? :-)​ ​ Yes, I saw that. I am in Rochester, NY. Texas is a bit far. But, next conferece 5 hours or less, I

Re: [sqlite] Schedule Up - 26th Annual Tcl/Tk Conference (Tcl'2019)

confere...@tclcommunityassociation.org, on Monday, September 23, 2019 04:20 PM, wrote... > [ NEWS > * Our keynote speaker is [Will Duquette](https://github.com/wduquette) > talking about "Tcl, Rust, and the Death of Rube Goldberg" Dr. Hipp, I would have placed you keynote speaker before

Re: [sqlite] [EXTERNAL] Fastest way to SELECT on a set of keys?

Keith Medcalf, on Monday, September 16, 2019 01:33 PM, wrote... > > It will, but that depends how many rows there are. > > That is, the statement: SELECT * FROM t1 WHERE id IN (1,2,3,4,5,6) > > Is equivalent to > > CREATE TEMPORARY TABLE keyset (key PRIMARY KEY); > INSERT OR IGNORE INTO keyset

Re: [sqlite] Fastest way to SELECT on a set of keys?

Jens Alfke, on Friday, September 13, 2019 12:38 PM, wrote... > (a) Execute "SELECT … FROM table WHERE key=?", once for each key. > (b) Execute "SELECT key, … FROM table WHERE key IN (…)", including all of the > key strings. I have found that the ... IN ... has provided a much faster result

Re: [sqlite] insert: how to force application to provide value for int primary key?

Dominique Devienne, on Tuesday, September 10, 2019 08:21 AM, wrote... > > On Tue, Sep 10, 2019 at 2:20 PM Jose Isaias Cabrera, on > wrote: > > > Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > > > Make it a WITHOUT ROWID table: > > >

Re: [sqlite] insert: how to force application to provide value for int primary key?

Marek Wieckowski, on Tuesday, September 10, 2019 08:08 AM, wrote... > > Yes, indeed works. Great, thank you! > > Marek > > > On Tue, Sep 10, 2019 at 9:13 AM Richard Hipp, on > > > On 9/10/19, Marek Wieckowski, on > > > > > > Is there a way in sqlite to ensure (on the database side) that all > >

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

Dominique Devienne, on Tuesday, September 10, 2019 07:53 AM, wrote... > > As DRH mentioned recently about a different piece of doc, I suspect that > doc hasn't been updated in years, Is that a hint? :-) josé ___ sqlite-users mailing list

Re: [sqlite] dqlite 1.0.0 - SQLite replication and failover library

> From: Free Ekanayaka, on Thursday, August 29, 2019 10:21 AM, wrote... > > Hello Jose, > > Jose Isaias Cabrera, on > > which lets me know that it linux/unix based. But, is Windows an > > option also? Thanks. > > At the moment Windows is not an option, mainl

Re: [sqlite] dqlite 1.0.0 - SQLite replication and failover library

Free Ekanayaka, on Thursday, August 29, 2019 06:40 AM, wrote... > > Hi, > > following up from my previous post back in 2017 [0], I'd like to > announce version 1.0.0 of dqlite, a C library that brings data > replication and high-availability to SQLite, using the Raft consensus > algorithm. > >

Re: [sqlite] Problem building DLL on Windows - no exported symbols

Reynolds, Scott, on Friday, August 23, 2019 08:05 AM, wrote... > > I'm trying to build SQLite (sqlite-autoconf-329.tar.gz) for Windows x64 > using Visual Studio 2017. All items are building, but my test application is > unable to resolve any SQLite symbols. This would seem to be the

Re: [sqlite] Schema updates across threads in WAL & multithread mode

Ben Asher, on Friday, August 16, 2019 02:32 PM, wrote... > > Hi folks! We're running (sqlite 3.27.2) into an issue where we make a > schema update (adding a column to a table) on our writer connection, but > then the schema update isn't immediately available on the read-only > connections that we

Re: [sqlite] Getting a notification when a write lock is released.

test user, on Friday, August 16, 2019 02:29 PM, wrote... > > Thanks for the example José. You're welcome. Just thought I would provide some idea... :-) josé ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Getting a notification when a write lock is released.

test user, on Thursday, August 15, 2019 07:35 PM, wrote... > The reason for the notification is to minimize time spent waiting. I will tell you what I did with 10 PMs working with a shared windows drive with an SQLite DB. But, take it with a grain of salt, unless you have high-blood pressure,

Re: [sqlite] Documentation update request

Kevin Benson, on Thursday, August 15, 2019 02:40 PM, wrote... > > On Thu, Aug 15, 2019 at 2:33 PM Jose Isaias Cabrera, on > wrote: > > Oh! Trickery! > > > > > Dickery (sometimes a nickname for RICHARD ;-) > Doc (...umentation; the something Richard "Dick&

Re: [sqlite] Documentation update request

Richard Hipp, on Thursday, August 15, 2019 01:32 PM, wrote... > > On 8/15/19, Simon Slavin, on > > On 15 Aug 2019, at 5:20pm, Richard Damon, on > > > >> You under quote, the faq says it “can not be changed (except under > >> extra-ordinary conditions).”, and those extra-ordinary conditions are a >

Re: [sqlite] Will rootpage number ever change?

Richard Hipp, on Thursday, August 15, 2019 09:45 AM, wrote... > > On 8/15/19, Jose Isaias Cabrera, on > > I have no idea > > what that means, but the question I have is, will that number ever change? > > Thanks. > > Yes. Root page numbers will change, for example whe

[sqlite] Will rootpage number ever change?

Greetings. When I run this command, sqlite> SELECT * FROM sqlite_master WHERE type='table' AND name='PMOTitles'; type|name|tbl_name|rootpage|sql table|PMOTitles|PMOTitles|560|CREATE TABLE PMOTitles ( TitleKey PRIMARY KEY, Titles ) sqlite> I see that there is a rootpage

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

Richard Hipp, on Tuesday, August 13, 2019 04:47 PM, wrote... > > On 8/13/19, Jose Isaias Cabrera, on > > > > I see all of you smart programmers using this > > non-column matching behavior, and I ask myself why? > > Because that's the way Dennis Richie did it. :-) S

[sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

James K. Lowden, on Tuesday, August 13, 2019 12:31 PM, wrote... > > On Mon, 12 Aug 2019 14:14:08 -0600 > "Keith Medcalf", on > > > Perhaps I am just lazy but I see no point in engaging in extra work > > for no advantage > > bool > is_true (bool tf) { > if (tf == true) { >

Re: [sqlite] Powershell Enter-PSSession for sqlite3.exe fails

Clinton James, on Friday, August 9, 2019 04:33 PM, wrote... > > You are right, it is the wrong behavior though the command is perfectly valid. > My first example shows the current problem, sqlite3.exe does not bring me > into an > interactive shell. I am trying to get the correct behavior while

Re: [sqlite] Powershell Enter-PSSession for sqlite3.exe fails

Clinton James, on Thursday, August 8, 2019 11:47 AM, wrote... > > [lab-6]: PS C:\swimage\release\utilities> .\sqlite3.exe -version > 3.29.0 2019-07-10 17:32:03 > fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6 > [lab-6]: PS C:\...\utilities> .\sqlite3.exe dummy.db > [lab-6]: PS

Re: [sqlite] Grammar police

Warren Young, on Friday, July 12, 2019 12:53 PM, wrote... > > On Jul 12, 2019, at 10:16 AM, Jose Isaias Cabrera, on > > "an historical oversight" is the correct English syntax, by the way. ;-) > > I can highly recommend the book “Word by Word: The Secret Life of >

Re: [sqlite] Grammar police

Warren Young, on Thursday, July 11, 2019 03:13 PM, wrote... > > On Jul 11, 2019, at 10:41 AM, Richard Hipp, on > > > > Here in the Southeastern US (specifically in Charlotte, NC) we really > > do say "an historical oversight". If you said "a historical > > oversight", people would look at you

Re: [sqlite] Please explain multi-access behaviour to me

Andy Bennett, on Tuesday, June 18, 2019 03:53 PM, wrote... > > > Actually, you're better off setting a timeout rather than handling > > retry in your own code: > > > > > > As I understand it, SQLITE_BUSY can occur in two situations: one where > busy

Re: [sqlite] althttpd.c check-in: efdc1b8e66

Dr. Richard Hipp, on Monday, April 29, 2019 09:18 AM, wrote...​ > On 4/29/19, Jose Isaias Cabrera wrote:​ > >​ > > I know I can probably use cygwin to run this tool, but plain Windows is not​ > > an option, right?​ > >​ > ​ > Althttpd is built around fork(

Re: [sqlite] select within transaction

Jose Isaias Cabrera, on Friday, June 14, 2019 02:50 PM, wrote... > Yes, and no. From what I understand, and have been using it, if > something was written to the DB, it will give you a 1. Otherwise > a 0. But, it is not the amount of fields, just a write. ie. This is wrong in

Re: [sqlite] select within transaction

Roman Fleysher, on Friday, June 14, 2019 02:22 PM, wrote... > > Since ROLLBACK is not an error, I want SELECT to be executed only will update > actually happened (not rollback). Because of EXCLUSIVE, I want it to be in > one transaction and thus I need some indicator if SELECT was after

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

"...unnecessary confusion", IMHO. From: sqlite-users on behalf of Richard Hipp Sent: Wednesday, June 12, 2019 09:35 AM To: General Discussion of SQLite Database Subject: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output? IEEE754 floating

[sqlite] How to build a Windows DLL with cygwin

Greetings! I have been a Cygwin user since its infancy, and I have been looking for a way to build SQLite Windows DLL with Cygwin, and I just found how to do this. I know I can use MinGW, which is the way I was doing it, but if you have Cygwin, you can just follow this steps: 1. use your

Re: [sqlite] [EXTERNAL] SQLITE Return Exponential value in the latest version(3.28.0) rather than integer number .

I don't think he means integer, but more "the original value entered." From: sqlite-users on behalf of Hick Gunter Sent: Thursday, June 6, 2019 08:43 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL] SQLITE Return Exponential value in the latest

Re: [sqlite] round function inconsistent

Lifepillar, on Friday, May 24, 2019 02:48 PM, wrote... >On 24 May 2019, at 19:53, Warren Young wrote: >> >>https://chiselapp.com/user/lifepillar/repository/sqlite3decimal/index > >sqlite3decimal’s author here: be warned that the extension is still in > development. In particular, it’s far

Re: [sqlite] [EXTERNAL] Re: round function inconsistent

Hick Gunter, on Tuesday, May 28, 2019 02:42 AM, wrote... >Think of floating point as a knapsack problem. Thanks for the nice explanation... >So instead of complaining that the IEEE cylinder set causes undue > stress on your knapsacks, please choose a more suitable set of > cylinders for your

Re: [sqlite] round function inconsistent

Rowan Worth, on Monday, May 27, 2019 11:07 PM, wrote...​ >On Mon, 27 May 2019 at 23:36, Jose Isaias Cabrera ​ >wrote:​ >​ >> Ok, I think it happens even before the casting. This should be,​ >> 3.2598, and yet, it's 3.26.​ >>​ >> sqlite> SELECT

Re: [sqlite] round function inconsistent

James K. Lowden, on Sunday, May 26, 2019 04:51 PM, wrote...​ >On Fri, 24 May 2019 13:10:49 +​ >Jose Isaias Cabrera wrote:​ >​ >> >Consider these two queries:​ >> >​ >> > SELECT round(3.255,2);​ >> > SELECT round(3.2548,2);​ &

Re: [sqlite] round function inconsistent

Dr. Richard Hipp, on Friday, May 24, 2019 01:06 PM, wrote... > >I also went to sqlfiddle and did a slightly more realistic scenario: > > CREATE TABLE t1(a INT, b DOUBLE PRECISION); > INSERT INTO t1(a,b) VALUES(1,3.255); > INSERT INTO t1(a,b) VALUES(2,3.254893418589635); > SELECT

Re: [sqlite] round function inconsistent

Thomas Kurz, on Friday, May 24, 2019 09:13 AM, wrote... >Sorry, but even Excel (which usually isn't very good at decimal math) gives >correct results: > >ROUND(3.255;2) --> 3.26 >ROUND(3.254999;2) --> 3.25 FWIW, I went to sqlfiddle [1] and these are the answers for this SQL command:

Re: [sqlite] round function inconsistent

Dr. Richard Hipp, on Friday, May 24, 2019 08:44 AM, wrote... >> Dr. Hipp, how many more scenarios, where round gives the wrong answer, >> exist? Thanks. >> > >Consider these two queries: > > SELECT round(3.255,2); > SELECT round(3.2548,2); > >Do you expect them to give different

Re: [sqlite] round function inconsistent

Simon Slavin, on Friday, May 24, 2019 08:34 AM, wrote... >On 24 May 2019, at 1:30pm, Jose Isaias Cabrera wrote: > >> Dr. Hipp, how many more scenarios, where round gives the wrong answer, > exist? Thanks. > >As Dr. Hipp wrote, round was giving the right answer. All you

Re: [sqlite] round function inconsistent

Alessandro Merolli, on Friday, May 24, 2019 07:39 AM, wrote... > Great! Now use SQLite API and add a new user defined function for > your used case. > I suppose that SQlite should always follow a well-defined pattern: in > this case as Mr. Hipp said, it is IEEE754. If IEEE754 can't figure out

Re: [sqlite] round function inconsistent

Dr. Richard Hipp, on Friday, May 24, 2019 07:13 AM, wrote... >> Last result should be 3.26 > >3.255 cannot be exactly represented as an IEEE754 double-precision >binary floating point number. So the system has to use an >approximation. The closest approximation is

Re: [sqlite] Have SQLite handle values of my own type

Dominique Devienne, on Thursday, May 23, 2019 10:35 AM, wrote... >On Thu, May 23, 2019 at 3:50 PM Jose Isaias Cabrera >wrote: > >Works for me with a .001 at least, as shown below. But that wasn't really >the point I was making, FWIW. --DD > >C:\Users\ddevienne>ping 19

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

J. King, on Thursday, May 23, 2019 07:26 AM, wrote... >On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote: > >>This is SQLite. Perhaps some of us could collaborate on a fork called >>SQLbloat and put out standard libs/code/precompileds for versions of >>sqlite with everything - bbq sauce and all,

Re: [sqlite] Have SQLite handle values of my own type

Dominique Devienne, on Thursday, May 23, 2019 07:02 AM, wrote... >On Thu, May 23, 2019 at 12:37 PM Simon Slavin wrote: >> On 23 May 2019, at 3:55am, Keith Medcalf wrote: >> > Technically, COLLATE only works on TEXT. Most people declare their own >> types as binary blobs and the programmer has

Re: [sqlite] CSV import does not handle fields with a comma surrounded by double

Patrick Sherrill, on Tuesday, May 21, 2019 09:38 AM, wrote... >I don’t know about ‘valid’ csv, it has been a moving target for decades. White >space as far as my recollection should not be considered in parsing a csv. In wikipedia [1], under Specification, #3, it states, "with the records

Re: [sqlite] readfile() enhancement request

Rowan Worth, on Monday, May 20, 2019 03:02 AM, wrote... >On Sat, 18 May 2019 at 00:34, Tony Papadimitriou wrote: > >> It’s quite often (for me, at least) the case I need to do something like >> this from the command line: >> >> >sqlite3.exe my.db “insert into t values(‘simple field’,’multi-line

Re: [sqlite] Bug in table_info pragma

Jose Isaias Cabrera, on Friday, May 17, 2019 08:28 AM, wrote... >J. King, on Friday, May 17, 2019 07:19 AM, wrote... >>Perhaps I should have been clearer that this is a regression? >> I know, overkill, but here is another look at it, SQLite version 3.28.0 2019-04-16 19:49:

Re: [sqlite] Bug in table_info pragma

J. King, on Friday, May 17, 2019 07:19 AM, wrote... >Perhaps I should have been clearer that this is a regression? > >SQLite version 3.13.0 2016-05-18 10:57:30 >Enter ".help" for usage hints. >Connected to a transient in-memory database. >Use ".open FILENAME" to reopen on a persistent database.

<    1   2   3   4   5   6   7   >