On Thu, Jan 16, 2014 at 11:18 PM, Joe Mistachkin sql...@mistachkin.comwrote:
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).
Judging
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
On Thu, Jan 16, 2014 at 5:21 AM, Rob Golsteijn rob.golste...@mapscape.euwrote:
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.
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
On 17 Jan 2014, at 1:23pm, d b va230...@gmail.com 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.
2013/12/31 big stone stonebi...@gmail.com:
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.
I'm
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 va230...@gmail.com 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
On 17 Jan 2014, at 6:22pm, d b va230...@gmail.com 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 to
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
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
On Jan 17, 2014, at 7:47 PM, big stone stonebi...@gmail.com 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/
Thanks a
On Fri, Jan 17, 2014 at 2:24 PM, Petite Abeille petite.abei...@gmail.comwrote:
On Jan 17, 2014, at 7:47 PM, big stone stonebi...@gmail.com wrote:
- I just did my first recursive CTE under Ipython notebook.
Finally! We can solve sudoku puzzles in SQL :P
Dan Kennedy, who created the
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
On Fri, Jan 17, 2014 at 2:05 PM, Richard Hipp d...@sqlite.org wrote:
On Fri, Jan 17, 2014 at 2:24 PM, Petite Abeille
petite.abei...@gmail.comwrote:
On Jan 17, 2014, at 7:47 PM, big stone stonebi...@gmail.com wrote:
- I just did my first recursive CTE under Ipython notebook.
Finally! We can
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
On Jan 17, 2014, at 11:26 PM, big stone stonebi...@gmail.com 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?
___
sqlite-users
On Fri, 17 Jan 2014 11:37:59 +0100
Rob Golsteijn rob.golste...@mapscape.eu 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 value in C
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
18 matches
Mail list logo
