Igor's messages sometimes get marked as spam by gmail.
--
Clive Hayward
On 2012-12-03, at 7:57 AM, e-mail mgbg25171 wrote:
> I've posted a couple of mails lately...I'm not getting them via the list or
> any responses.
> Admin says Igor responded to one of them...Thanks Igor!
> This is just a t
On 12/3/2012 8:26 PM, YAN HONG YE wrote:
SELECT c FROM mytable AS m1 WHERE NOT EXISTS (SELECT b FROM mytable AS m2
WHERE m2.b = m1.c);
SELECT c FROM mytable WHERE NOT EXISTS (SELECT b FROM mytable WHERE b = c);
The second query is equivalent to this:
SELECT c FROM mytable AS m1 WHERE
One is a correlated subquery and the other isn't.
Do I get a prize?
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of YAN HONG YE
> Sent: Monda
On Mon, Dec 3, 2012 at 3:25 PM, Richard Hipp wrote:
> A draft of the
> release website can be seen here:
>
> http://www.sqlite.org/draft/index.html
Typo at the very beginning of http://www.sqlite.org/draft/about.html :
s/SQLite is a in-process library/SQLite is an in-process library/.
---Jo
SELECT c FROM mytable AS m1 WHERE NOT EXISTS (SELECT b FROM mytable AS m2
WHERE m2.b = m1.c);
SELECT c FROM mytable WHERE NOT EXISTS (SELECT b FROM mytable WHERE b = c);
Sincerely,
Cordialement / Best Regards / Mit freundlichen Grüßen / Cordiali saluti !
_
How about trying to write .output to the same file you are .read ing?
I would expect it to explode. Further, I would expect it quite likely that it
would explode without being able to tell you about the explosion.
The sequence should be:
.output somefile
.dump sometable
.output stdout
... ca
Hi Joe,
Thanks for the excellent reply. Putting SQLite.Interop.dll
in my bin\Debug folder solved the problem.
I did read the download page and the faq page, but most of
that stuff is gibberish to me and not beginner friendly at
all. But all's well that ends well. I created some tables
with
On 3 December 2012 19:29, Igor Korot wrote:
> Simon,
>
> On Mon, Dec 3, 2012 at 11:03 AM, Simon Slavin wrote:
>>
>> On 3 Dec 2012, at 6:53pm, Igor Korot wrote:
>>
>
> Here is the session:
>
> sqlite> CREATE TABLE test(id1 integer, id2 double);
> sqlite> INSERT INTO test( 1, 1.0 );
> Error: near
On 3 Dec 2012, at 7:29pm, Igor Korot wrote:
> I didn't get errors when I did that with my table. Other than that its all
> the same.
You didn't get any time shown when the .read command finished. This suggests
that something crashed the .read command. Anything done after that can
malfunctio
We have received no performance regression reports for the SQLite 3.7.15
beta described below. Hence, our intention is to move ahead with the
scheduled release of SQLite version 3.7.15 on 2012-12-12. A draft of the
release website can be seen here:
http://www.sqlite.org/draft/index.html
Simon,
On Mon, Dec 3, 2012 at 11:03 AM, Simon Slavin wrote:
>
> On 3 Dec 2012, at 6:53pm, Igor Korot wrote:
>
>> Yes, using standard sqlite3 shell from command prompt in Windows 7 64-bit.
>> After .dump/.read no queries to the table in question produced output.
>>
>> When restarted the shell eve
Hi Jay,
No, auto_vacuuming is off. And yes, the rows are gone, at least i couldn't
find them anymore in those tables.
My database file is more than 50MB, and I only deleted records in 3 tables.
And indeed, there are lots of indexes inside, so maybe you're right.
On Sun, Dec 2, 2012 at 10:37 PM
On 3 Dec 2012, at 6:53pm, Igor Korot wrote:
> Yes, using standard sqlite3 shell from command prompt in Windows 7 64-bit.
> After .dump/.read no queries to the table in question produced output.
>
> When restarted the shell everything worked.
I've not come across that before. Try
.timer ON
SE
Simon,
On Mon, Dec 3, 2012 at 9:39 AM, Simon Slavin wrote:
>
> On 3 Dec 2012, at 5:38pm, Igor Korot wrote:
>
>> Simon,
>> Yes, thank you.
>
> Great.
>
>> ALL,
>> After recreating the table this way I had to restart sqlite console as
>> otherwise
>> all queries to the table were dead.
>>
>> Is t
test
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
The method in the faq is somewhat simplistic. For example, if you have
indexes or triggers associated with the table, you'll lose them. It may or
may not be a big deal to reinstate them manually but be prepared to have to
do that.
Or you could use one of the many third party tools that will do t
On 3 Dec 2012, at 5:38pm, Igor Korot wrote:
> Simon,
> Yes, thank you.
Great.
> ALL,
> After recreating the table this way I had to restart sqlite console as
> otherwise
> all queries to the table were dead.
>
> Is this normal?
Hmm. No, if you're using the standard sqlite3 shell tool you s
Simon,
Yes, thank you.
ALL,
After recreating the table this way I had to restart sqlite console as otherwise
all queries to the table were dead.
Is this normal?
Thank you.
On Mon, Dec 3, 2012 at 1:42 AM, Simon Slavin wrote:
>
> On 3 Dec 2012, at 1:08am, Igor Korot wrote:
>
>> I thought that s
I've just discovered that if (within the same shell session) I switch from
.mode csv to .mode list, the output remains in csv format. If I instead (or
then) switch to .mode column, the result is correct. If I then switch back
to .mode list, the output reverts to csv format. It seems like one cannot
Awesome, will look into this ASAP.
I appreciate the quick respone!
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon Slavin
> Sent: Monday, December 03, 2012 10:58 AM
> To: General Discussion of SQLite Database
> Su
On 3 Dec 2012, at 3:38pm, "Tilsley, Jerry M." wrote:
> Any suggestions out there on what ODBC driver to use with PHP, or any other
> manner to connect to a SQLite database via PHP?
Yup. Use the SQLite3 object-oriented library:
http://php.net/manual/en/book.sqlite3.php
The library is pre-ins
I've posted a couple of mails lately...I'm not getting them via the list or
any responses.
Admin says Igor responded to one of them...Thanks Igor!
This is just a test to see if the mail is coming to me (as a member of the
list).
Therefore please just ignore this.
___
I use the sqlite 3 PDO driver that comes with PHP. An example:
exec('CREATE TABLE example (a INTEGER, b INTEGER)');
$statement = $handle->prepare('INSERT INTO example VALUES (?, ?)');
$statement->execute(array(1, 1));
$statement->execute(array(2, 2));
$statement->execute(array(3, 3));
$statemen
On Mon, Dec 3, 2012 at 10:38 AM, Tilsley, Jerry M.
wrote:
> All,
>
> Any suggestions out there on what ODBC driver to use with PHP, or any
> other manner to connect to a SQLite database via PHP?
>
Doesn't PHP have built-in support for SQLite?
>
> Thanks,
>
> Jerry Tilsley
> St. Claire Regional
All,
Any suggestions out there on what ODBC driver to use with PHP, or any other
manner to connect to a SQLite database via PHP?
Thanks,
Jerry Tilsley
St. Claire Regional Medical Center
Sr Systems Analyst | Interfaces
Disclaimer
This email is confidential
On Mon, Dec 3, 2012 at 3:11 AM, Hick Gunter wrote:
> The following test case produces correct code for native tables, but
> substituting virtual tables seems to clobber the P4 Keyinfo to be
> propagated to OpenEphemeral at #59 by the spurious P4 to Goto at #8
>
Thank you for the bug report.
Nev
Debugging reveals that the following code in where.c clobbers the P4 value of
the prior instruction which is incorrectly assumed to be an OP_OpenWrite or
OP_OpenRead but in fact is not generated at all for virtual tables.
Maybe the wsFlags are not set correctly?
Additionally, the VOpen for the
The following test case produces correct code for native tables, but
substituting virtual tables seems to clobber the P4 Keyinfo to be propagated to
OpenEphemeral at #59 by the spurious P4 to Goto at #8
create temp table a (f1 integer, f2 integer);
create temp table b (f1 integer, f2 integer);
c
Dear all,
I changed btree.c like as follows.
But, it may not be a best solution.
Whatever TCL test for "quick.test" is passed, following code can have some
mistakes...
I couldn't change it more with my poor knowledge.
*static int btreeCreateTable(Btree *p, int *piTable, int createTabFlags)*{
Bt
I had several cases of corrupted databases in the last few days which all
look similar but not exactly the same:
sqlite> pragma integrity_check;
*** in database main ***
On tree page 45127 cell 9: Rowid 3 out of order (previous was 76)
Corruption detected in cell 9 on page 45127
Fragmentation of 1
On 3 Dec 2012, at 1:08am, Igor Korot wrote:
> I thought that simply using ".backup/.restore" will give me what I want,
> but it gives me a file in internal format.
> What I am trying to do is do make a text file which gives me all SQL command
> that was issued (CREATE TABLE and INSERT) than fix
31 matches
Mail list logo