Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> Have you tried to run the latest laststmtchanges.test on Windows? I am
> still getting a failure that shows the same double counting that was
> originally reported on the mailing list.
>
> laststmtchanges-1.2.1...
> Expected: [5]
>
I've taken a further look. The main problem is that the cursor number is
hardcoded, as can be seen
in the following example (A delete trigger causing further deletes.)
29|OpenRead|3|6|
30|SetNumColumns|3|1|
31|Rewind|3|38|
32|Column|3|0|
33|Rowid|0|0|
34|Ne|355|37|collseq(BINARY)
35|Rowid|3|0|
[EMAIL PROTECTED] wrote:
Perhaps not. But is was the cause of problems I was having
with misc7 yesterday when I checked in my patches for winXP.
Richard,
You were correct. I'm not sure how it happened but I must have had a log
from the previous version of the test and the source for the
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Is it that when a Integer column of a table is defined as primary
key, the it will be part of every index table (rather than rowid)
It's not either-or. Such a column simply becomes an alias for rowid. You
can refer to the same column by the name
Thanks Dennis,
Is it that when a Integer column of a table is defined as primary key, the it
will be part of every index table (rather than rowid) defined on that table?
How does it work when we define a non integer as primary key. Assuming in the
example given below if we make the Title
"Michael Ruck" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've been looking into the way triggers are implemented and was thinking
> about adding support for recursive triggers, as they would simplify my
> current project dramatically. What was/is the reason to leave them out?
>
> My thoughts were
"P Kishor" <[EMAIL PROTECTED]> wrote:
> alright. Let's do it again (DRH can chime in to educate us if I get
> it wrong) --
>
You got it right as far as I can see.
The problem with "public domain" (and this is something I did
not know when I put SQLite in the public domain in 2001) is that
some
Hello,
I've been looking into the way triggers are implemented and was thinking
about adding support for recursive triggers, as they would simplify my
current project dramatically. What was/is the reason to leave them out?
My thoughts were adding recursive triggers by calling them like
Dennis Cote <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> >
> >
> > Your previous changes left the ABC table in a different
> > state than what these latter tests expect to see.
> >
> >
> Richard,
>
> I don't think that is the case
Perhaps not. But is was the cause of problems
Liam Healy wrote:
With the quotes removed, null values come out as nothing beteween
the delimiters, e.g.
2007-06-08,70,70,5,70,70,5
ends with eight null values. Sqlite interprets each as the empty
string "",
which is not the same thing. I presume if it said NULL it would be
right,
I am trying to import (with .import) into SQLite3 some tables that are
currently in an Oracle instance. To do this I am using an Oracle script (a
nice one I found at
http://www.tek-tips.com/viewthread.cfm?qid=1250849=8) . This script
produces another script which is then executed. The result
Nuno Lucas wrote:
On 4/26/07, John Elrick <[EMAIL PROTECTED]> wrote:
2. Settings which cause Media Center to return control more
optimistically than Pro or Home. In this case, there would be a
hypothetically higher risk of data loss on the Media Center machine.
However, the point of a
Nuno Lucas wrote:
And you seem to not have noticed this link:
http://www.microsoft.com/technet/prodtechnol/windows2000serv/maintain/optimize/wperfch7.mspx
I actually did and thank you. I received your message within a minute
after I had sent my last one. The wonders of email delays
On 4/26/07, John Elrick <[EMAIL PROTECTED]> wrote:
Using two machines as an example, XP Home and XP Media Center.
XP Home and Media Center with the pragma synchronous=OFF executes the
test operation in under 2.0 seconds.
Set to FULL the times are, respectively 118 seconds and 8 seconds.
The
Griggs, Donald wrote:
I may be confused a bit.
Regarding: 1) "the described slowdown occurs consistently on Windows
XP Home and Pro and on Windows Vista."
On its face, I would think this means that Xp Home and Vista do *NOT*
have a problem, and that "fast" behaviour represents an
I may be confused a bit.
Regarding: 1) "the described slowdown occurs consistently on Windows
XP Home and Pro and on Windows Vista."
On its face, I would think this means that Xp Home and Vista do *NOT*
have a problem, and that "fast" behaviour represents an integrity-risk
problem.
Regarding:
Some interesting new information, if anyone can make use of it.
After adding one more machine to the test, we have established that the
described slowdown occurs consistently on Windows XP Home and Pro and on
Windows Vista. The problem appears to be absent on Windows Media Center
(two
Hi Klemens,
Thank you, I'm trying to follow this:
http://technet2.microsoft.com/WindowsVista/en/library/4ac505e6-dd8b-4ae7-80fa-b9d77cd8104d1033.mspx?mfr=true
Cheers,
Mike
Klemens Friedl 提到:
Try to deactivate the shadow copy for the directory where the sqlite
db file(s) are stored
Pavan wrote:
Thanks for the quick reply. I did not quite understand to which part
of the
question this reply belongs. Are you suggesting that I should not take
explicit license ?
You certainly don' t need to. You can if it makes you or your lawyers
feel more comfortable.
BTW, i dont want to
Try to deactivate the shadow copy for the directory where the sqlite
db file(s) are stored (directory extended properties).
-
To unsubscribe, send email to [EMAIL PROTECTED]
alright. Let's do it again (DRH can chime in to educate us if I get it wrong) --
On 4/26/07, Pavan <[EMAIL PROTECTED]> wrote:
Hi Kishor,
>you don't have to do anything.
Thanks for the quick reply. I did not quite understand to which part of the
question this reply belongs. ..
..
>
> On
Hi Kishor,
you don't have to do anything.
Thanks for the quick reply. I did not quite understand to which part of the
question this reply belongs. Are you suggesting that I should not take
explicit license ?
BTW, i dont want to do any changes to sqlite, but i am more concerned about
the
B V, Phanisekhar wrote:
Thanks for that Info.
I have another question:
Assume I have a table given below
"CREATE TABLE IF NOT EXISTS Title(Id INTEGER PRIMARY KEY, TitleName
String)"
"CREATE UNIQUE INDEX IF NOT EXISTS TitleIdx ON TitleName"
Now since Id is an integer and a primary key, this
[EMAIL PROTECTED] wrote:
Your previous changes left the ABC table in a different
state than what these latter tests expect to see.
Richard,
I don't think that is the case. I'm using the misc7.test file from CVS
head. A recent change to that file that appears prior to these failures
is
Thanks for that Info.
I have another question:
Assume I have a table given below
"CREATE TABLE IF NOT EXISTS Title(Id INTEGER PRIMARY KEY, TitleName
String)"
"CREATE UNIQUE INDEX IF NOT EXISTS TitleIdx ON TitleName"
Now since Id is an integer and a primary key, this will work as rowid
you don't have to do anything. SQLite is in public domain. You can
cook with it, make castles with it, become a billionaire (although, if
you do, remember to give some money to your favorite open source
project), or roll pancakes with it.
If you make and modifications to SQLite AND if you want
Hi,
I have gone through this link
http://www.sqlite.org/copyright.html and here are few more practical queries
related to commercial usage:-
1. If i develop a wrapper module around sqlite(without taking explicit
license) to store some private data in the db, should the wrapper module be
made
"B V, Phanisekhar" <[EMAIL PROTECTED]> wrote:
> How does the index table looks?
>
> Assume the main table to be:
> CREATE TABLE table1 (a INTEGER, b INTEGER)
> Assume there is an index on column a:
> CREATE INDEX index1 ON table1 (a);
>
> Now let's suppose the entries
Is there a reason why ALTER TABLE ADD can add only one column?
I'v changed the parser to allow any number of columns - I'm calling
sqlite3AlterFinishAddColumn() for every column. It seems to work.
Am I missing some problem, or nobody wanted more columns before?
Wiktor Adamski
[EMAIL PROTECTED] wrote:
>
> then I use the command
>
> lemon parse.y
>
> I successfully get the parse.h file
>
> but the file is not right.
> I only get 137 ids
>
> the follwing 15 ids do not exist in the parse.h
>
> TK_TO_TEXT
>
> TK_CONST_FUNC
>
You need to run the awk script
Hi Pavan,
try
http://reddog.s35.xrea.com/wiki/TkSQLite.html
It's excellent.
Ulrich
On Thursday 26 April 2007 10:26, Pavan wrote:
> Hi Ralf,
>
> Thanks for the link. My OS is Linux. Is there something available on
> these lines for linux ?
>
> Best Regards,
> Pavan.
>
> On 4/26/07, Ralf
Dennis,
How does the index table looks?
Assume the main table to be:
CREATE TABLE table1 (a INTEGER, b INTEGER)
Assume there is an index on column a:
CREATE INDEX index1 ON table1 (a);
Now let's suppose the entries in table1 be:
10, 91
Hello Ralf Junker,
>>Thanks for the link. My OS is Linux. Is there something available on these
>>lines for linux ?
>
>SQLiteSpy apparently runs on Linux with the help of wine, but I have not
>tested this myself: http://www.winehq.com/
Here is a small report on this:
Hello Pavan,
>Thanks for the link. My OS is Linux. Is there something available on these
>lines for linux ?
SQLiteSpy apparently runs on Linux with the help of wine, but I have not tested
this myself: http://www.winehq.com/
Ralf
Hi Ralf,
Thanks for the link. My OS is Linux. Is there something available on these
lines for linux ?
Best Regards,
Pavan.
On 4/26/07, Ralf Junker <[EMAIL PROTECTED]> wrote:
Hello Pavan,
>Can we store/retrieve Japanese/korean characters in sqlite db ?
Yes, you can well do so, as others
Hello Pavan,
>Can we store/retrieve Japanese/korean characters in sqlite db ?
Yes, you can well do so, as others have already pointed out.
If you are also looking for a Unicode GUI SQLite database manager to display
and edit Japanese / Korean character databases, you might want to have a look
36 matches
Mail list logo