Re: [sqlite] Mailinglist question

2017-08-17 Thread Wolfgang Enzinger
Am Thu, 10 Aug 2017 01:37:14 +0200 schrieb Wolfgang Enzinger: > I'm connected to this mailing list as if it was a newsgroup using > nntp://news.gmane.org:563/gmane.comp.db.sqlite.general. Bummer ... just a few hours after I posted this, that service seems to have stopped pulling any new posts - b

[sqlite] Possible SQLite bug using an uncollated index with a collated query

2017-08-17 Thread Jens Alfke
I believe I may have found a bug in SQLite 3.18. I've got a query that returns a correct result set when there are no indexes in the database, but returns an incorrect result set if recompiled after an index has been added. The incorrect result set has no collation applied, so the problem seems

[sqlite] tclsqlite3.c and libtclsqlite3.so not built

2017-08-17 Thread Roderick
Dear Sirs, I am trying to build sqlite 3.20 in FreeBSD 11.1. configure, make and make install does not build the tcl interface. I configure with --enable-tcl --with-tcl=/usr/opt/tcl86/lib. At the end, I get only pkgIndex.tcl, not libtclsqlite3.so in /usr/opt/tcl86/lib/tcl8.6/sqlite3. Neither

Re: [sqlite] Custom API Server and custom database

2017-08-17 Thread J Decker
On Wed, Aug 16, 2017 at 1:11 PM, Henry Udoye wrote: > -- > Henry Udoye. > 4165 Whiteplains Road. > P. O. Box 1290. > Bronx. N. Y. 10466 > Phone : 914-316-1854. > Fax : 206-350-3803 > hudoye1...@gmail.com > > > > > > Can you supply or provide the following: > > > > 1. Create custom APIs serv

Re: [sqlite] Error trying to do inner joins

2017-08-17 Thread David Raymond
Correct. For normal* cases inner joins are where you want only things that match in table A and table B, then you expand that out with multiple inner joins to get to 3 or more tables. Order doesn't matter in an inner join, so A INNER JOIN B will be equivalent to B INNER JOIN A. Outer joins are

Re: [sqlite] Error trying to do inner joins

2017-08-17 Thread Keith Medcalf
Yes. Or you could toss the new fangled JOIN syntax (which does nothing if the join is not an outer join) which only adds silly complication and do something like: SELECT sentece_en, sentence_el FROM Saetning, Verb_Saetn, Verbum WHERE Saetning.Saeting_ID == Vert_Saetn.Saetning_ID A

Re: [sqlite] Error trying to do inner joins

2017-08-17 Thread Lars Frederiksen
Thank you, This SQL works fine. Is the inner join normally used for connecting 3 tables where the "middle one" is a link table? /Lars -Oprindelig meddelelse- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af David Raymond Sendt: 17. august 2017 21:1

Re: [sqlite] Error trying to do inner joins

2017-08-17 Thread David Raymond
There's an issue with the join statement in the first join you're joining Saetning and Verb_Saetn, but the ON clause uses fields in Verb_Saetn and Verbum, not Saetning. And then you join that back to Saetning, so you've joined Saetning twice and Verbum 0 times. Since the Saetning table shows up

Re: [sqlite] Error trying to do inner joins

2017-08-17 Thread R Smith
On 2017/08/17 8:54 PM, Lars Frederiksen wrote: Hello, I have a small db with 3 tables: CREATE TABLE IF NOT EXISTS "Verb_Saetn"( VS_ID INT PRIMARY KEY NOT NULL, VERBUM_ID INT NOT NULL, SAETNING_ID INT NOT NULL, FOREIGN KEY(VERBUM_ID) REFERENCES Verbum(VERBUM_ID), FOREIGN KEY

[sqlite] Error trying to do inner joins

2017-08-17 Thread Lars Frederiksen
Hello, I have a small db with 3 tables: CREATE TABLE IF NOT EXISTS "Verb_Saetn"( VS_ID INT PRIMARY KEY NOT NULL, VERBUM_ID INT NOT NULL, SAETNING_ID INT NOT NULL, FOREIGN KEY(VERBUM_ID) REFERENCES Verbum(VERBUM_ID), FOREIGN KEY(SAETNING_ID) REFERENCES Saetning(SAETNING_ID) ); C

Re: [sqlite] Explain results help...

2017-08-17 Thread R Smith
On 2017/08/17 2:40 PM, jose isaias cabrera wrote: Jens Alfke wrote... On Aug 16, 2017, at 8:36 PM, jose isaias cabrera wrote: The following query is taking a bit too long for my taste. I did a quick query with explain and I got this… The output of EXPLAIN QUERY PLAN is a lot easier to

Re: [sqlite] Explain results help...

2017-08-17 Thread Simon Slavin
> On 17 Aug 2017, at 1:40pm, jose isaias cabrera wrote: > > sqlite> explain query plan > ...> SELECT ls.id FROM LSOpenProjects ls JOIN client.LSOpenProjects cl ON > ...> ( > ...> cl.login != 'lsuser' AND > ...> cl.id = ls.id AND > ...> cl.XtraB != ls.XtraB > ...> ) LIMIT 100; > 0|0|

Re: [sqlite] Compiler warning "gethostuuid() is disabled" building SQLite for iOS

2017-08-17 Thread Bob Friesenhahn
On Wed, 16 Aug 2017, Richard Hipp wrote: On 8/16/17, Simon Slavin wrote: I worked at a university and we used network home directories. Why use the local disk when you can instead use a network filesystem that is less reliable and about 100x slower? It is not necessarily the case that a

Re: [sqlite] Explain results help...

2017-08-17 Thread jose isaias cabrera
Jens Alfke wrote... On Aug 16, 2017, at 8:36 PM, jose isaias cabrera wrote: The following query is taking a bit too long for my taste. I did a quick query with explain and I got this… The output of EXPLAIN QUERY PLAN is a lot easier to understand; have you tried that? Most importantly i

[sqlite] Custom API Server and custom database

2017-08-17 Thread Henry Udoye
-- Henry Udoye. 4165 Whiteplains Road. P. O. Box 1290. Bronx. N. Y. 10466 Phone : 914-316-1854. Fax : 206-350-3803 hudoye1...@gmail.com Can you supply or provide the following: 1. Create custom APIs server with multiple end points and multiple clients 2. Build a Custom databas

Re: [sqlite] COLLATE doesn't work with parenthesized expressions (doc issue)

2017-08-17 Thread Dan Kennedy
On 08/17/2017 07:07 AM, Jens Alfke wrote: On Aug 16, 2017, at 4:55 PM, Richard Hipp wrote: Remember: COLLATE binds more tightly than ==. So 'xyz' = 'XYZ' COLLATE nocase gets parsed out as 'xyz' = ('XYZ' COLLATE nocase) And that expression has a different meaning from your ('x