[sqlite] Bug in SQLite 3.8.2

query selects ROWID from the regular table - both tables must be mentioned in the FROM clause - the WITHOUT ROWID table must be mentioned as the second one Regards, -- Paweł Salawa pawelsal...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.o

[sqlite] Building sqlite 3.7.3 with Tcl binding

Hi, How do I compile sqlite 3.7.3 with Tcl bindings? I don't see any tcl-related options in configure script (the amalgamation distribution) and default compilation doesn't probide Tcl bindings. Thanks for help! Regards, -- Paweł Salawa pawelsal...@gmail.com

[sqlite] Tcl bindins problem, once again

Hi, I mentioned the problem before but it seems to be ignored for now. I'd really appreciate some response, at least confirmation or denial that I'm right about the problem. Quoting from previous thread: --- QUOTE --- select a1.txt, a2.txt from a a1 join a a2 using (ref)

Re: [sqlite] No error on UPDATE setting duplicated value on UNIQUE column.

> Maybe you should remove the "ON CONFLICT IGNORE" clause at the end of the > uniqueness constraint... You're right, of course. Shame on me for missing it :( Shame on me! -- Paweł Salawa pawelsal...@gmail.com ___ sqlite-users mai

[sqlite] No error on UPDATE setting duplicated value on UNIQUE column.

on doesn't call ROLLBACK for that case. Last call at the end is to ensure that other constraint violation raises error correctly. Same behaviour takes place for tclsqlite extension. Regards, -- Paweł Salawa pawelsal...@gmail.com ___ sqlite-us

Re: [sqlite] Tcl bindings are a little problematic.

Hi, I have a feeling that thread "Tcl bindings are a little problematic." is forgotten, but yet not concluded. I want to catch your eye again on it. Please see response below. Regards, Pawel From: Paweł Salawa <pawelsal...@...> Subject: Re: Tcl bindings are a little problem

Re: [sqlite] Tcl bindings are a little problematic.

k, 2 września 2010, napisałeś: > On Wed, Sep 1, 2010 at 6:11 PM, Paweł Salawa <p...@bitrock.com> wrote: > > > Hi, > > > > It's pretty hard to make a SELECT from same table, but using two different > > aliases for the table and at the same time also ge

[sqlite] Tcl bindings are a little problematic.

of any questions don't hesistate to ask. Regards, -- Paweł Salawa p...@bitrock.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users