Re: [sqlite] "Common Table Expression"

On 1/17/2014, 8:24 AM, Jan Nijtmans wrote: Not necessary. I noticed that CTE was just merged to SQLite's trunk, so it apparently will be part of SQLite 2.8.3. Ahh great, I look forward to seeing that released in February (regular schedule) or whenever. The greater maintainability of code due

Re: [sqlite] Mutally dependent JOIN clauses

On Fri, 17 Jan 2014 11:37:59 +0100 Rob Golsteijn wrote: > SELECT * FROM (C LEFT JOIN >    A ON A.a*A.a + B.b*B.b = C.c*c.c) > LEFT JOIN B ON A.a*A.a + B.b*B.b = C.c*c.c; > > The "C LEFT JOIN A" part is to be evaluated first; produces output > for all

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

On Jan 17, 2014, at 11:26 PM, big stone wrote: > Has anyone a clue ? No. But this is what Charlie the Unicorn has to say on the subject: "Oh God you guys. This better be pretty important. Is the meadow on fire?" ___

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

I think this should work, but with current almagation avalaible for download sqlite-amalgamation-201401171527, I get nothing. Has anyone a clue ? drop table if exists gen9; drop table if exists genx; drop table if exists initial; create table gen9(z); insert into gen9 values

Re: [sqlite] "Common Table Expression"

On Fri, Jan 17, 2014 at 2:05 PM, Richard Hipp wrote: > On Fri, Jan 17, 2014 at 2:24 PM, Petite Abeille > wrote: >> On Jan 17, 2014, at 7:47 PM, big stone wrote: >> > - I just did my first recursive CTE under Ipython notebook. >>

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

hello again, I get the message of error "OperationalError: circular reference: x" from the recursive CTE below. Is it a syntax error or a bug ? drop table if exists gen9; drop table if exists genx; create table gen9(z); insert into gen9 values

Re: [sqlite] "Common Table Expression"

On Fri, Jan 17, 2014 at 2:24 PM, Petite Abeille wrote: > > On Jan 17, 2014, at 7:47 PM, big stone wrote: > > > - I just did my first recursive CTE under Ipython notebook. > > Finally! We can solve sudoku puzzles in SQL :P > Dan Kennedy, who

Re: [sqlite] "Common Table Expression"

On Jan 17, 2014, at 7:47 PM, big stone wrote: > - I just did my first recursive CTE under Ipython notebook. Finally! We can solve sudoku puzzles in SQL :P http://technology.amis.nl/2009/10/13/oracle-rdbms-11gr2-solving-a-sudoku-using-recursive-subquery-factoring/ >

[sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

Hello, I'm trying to do the SQLite version of the sudoku solver that exist here in POSTGRESQL (here : http://wiki.postgresql.org/wiki/Sudoku_puzzle) I'm at this stage below currently. could anyone help me ? I have a syntax error , and a bit confuse where it can be (not sure about the modulo

Re: [sqlite] "Common Table Expression"

Yes ! It's in trunk. With Keith Medcalf's help, I suceeded to compile it. => Thanks a lot Keith ! I can confirm : - the sqlite3.dll works under python3 by swapping the default one, - I just did my first recursive CTE under Ipython notebook. ==> I would never have imagined that to happen so

Re: [sqlite] sqlite abort

On 17 Jan 2014, at 6:22pm, d b wrote: > What is the default time? Zero. No retrying at all. Any conflict is treated as an error. > what is the ideal time for sqlite? However long you want your application to try before deciding that it is never going to recover and has

Re: [sqlite] sqlite abort

Thank you. What is the default time? what is the ideal time for sqlite? On Fri, Jan 17, 2014 at 6:53 PM, d b wrote: > Hi all, > > When database busy with read/write operations, it's thrown sqlite abort > error while delete a record. > > what does it mean sqlite

Re: [sqlite] "Common Table Expression"

2013/12/31 big stone : > Hello "CTE in SQLite" fans, > > To get CTE in SQLite, I guess we must answer by the example the fears > expressed by Simon and Rsmith. Not necessary. I noticed that CTE was just merged to SQLite's trunk, so it apparently will be part of SQLite 2.8.3.

Re: [sqlite] sqlite abort

On 17 Jan 2014, at 1:23pm, d b wrote: > When database busy with read/write operations, it's thrown sqlite abort > error while delete a record. Have you set a timeout ? If you haven't, SQLite will try only once and will not wait until other processes are finished the file.

[sqlite] sqlite abort

Hi all, When database busy with read/write operations, it's thrown sqlite abort error while delete a record. what does it mean sqlite abort(Callback routine requested an abort)? Shouldn't application delete when database busy with read/write operations? Thanks, a v

Re: [sqlite] Mutally dependent JOIN clauses

On Thu, Jan 16, 2014 at 5:21 AM, Rob Golsteijn wrote: > Dear List, > > I came across a query with 2 LEFT JOINs of which the join clauses were > mutually dependent. > They did not produce the result I expected, but now I wonder if this is > legal SQL in the first place.

Re: [sqlite] Mutally dependent JOIN clauses

Guys, Just a clarification to my previous post: I'm not looking for a solution to my example problem (but thanx anyway for the suggestions). What I'm really trying to understand is if the behaviour of the LEFT JOIN operator is correct. I think SQlLite produces the wrong result, but please

Re: [sqlite] Fw: System.Data.SQLite.dll

On Thu, Jan 16, 2014 at 11:18 PM, Joe Mistachkin wrote: > > RadSolution wrote: > > > > The version info for this file states that it is version 91.0.77.0 dated > 31/01/2012 12:59 > > This is used in several of our legacy systems (without any problems that > I'm aware of). >