Re: [sqlite] Mailinglist question

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 -

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

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

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.

Re: [sqlite] Custom API Server and custom database

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.

Re: [sqlite] Error trying to do inner joins

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

Re: [sqlite] Error trying to do inner joins

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

Re: [sqlite] Error trying to do inner joins

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

Re: [sqlite] Error trying to do inner joins

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

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

[sqlite] Error trying to do inner joins

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) );

Re: [sqlite] Explain results help...

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

Re: [sqlite] Explain results help...

> 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 >

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

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

Re: [sqlite] Explain results help...

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

[sqlite] Custom API Server and custom database

-- 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

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

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