D. Richard Hipp wrote:
On Thu, 2005-08-25 at 00:18 +0200, Ramon Ribó wrote:
Is there a way to define an aggregate function in the TCL binding?
No. Not at this time.
I think this topic came up a while ago, when simple functions were added
to the TCL bindings (or at least when I became a
On 8/25/05, Will Leshner <[EMAIL PROTECTED]> wrote:
>
> On Aug 24, 2005, at 7:41 PM, Firman Wandayandi wrote:
>
> > Does SQLite3 compatible with SQLite2 databases? If yes, so I can
> > manage the SQLite2 database using SQLite3 engine.
>
> No, and no.
>
Ah, yes, I see. That's the reason why i c
I presume it is a PENDING lock? Does SQLite acquire a PENDING lock as
soon it begins an Update operation?
On Aug 24, 2005, at 7:41 PM, Firman Wandayandi wrote:
Does SQLite3 compatible with SQLite2 databases? If yes, so I can
manage the SQLite2 database using SQLite3 engine.
No, and no.
On Wed, 2005-08-24 at 22:32 -0400, Mrs. Brisby wrote:
> > There are several attacks that can be used to derive the original key
> > state, but they all require huge samples of data to analyze.
>
> No they don't. That's the problem. They only need a large number of
> _uses_ of the key, not large a
Does SQLite3 compatible with SQLite2 databases? If yes, so I can
manage the SQLite2 database using SQLite3 engine.
--
Firman Wandayandi
Never Dreamt Before (http://php.hm/~firman/)
On Mon, 2005-08-22 at 16:39 -0500, Dennis Jenkins wrote:
> RC4 is basically an XOR against a huge one-time pad.
No it's not. The only thing like a one-time pad is a one-time pad.
What makes an OTP secure isn't the protocol, but where the bits come
from.
If they come from ANYWHERE but a truly ran
D. Richard Hipp wrote:
Most people who are using SQLite successfully have, I imagine,
either written their own wrappers around the core API (which
is not hard as I do provide you with a lot of helper routines
such as sqlite3_vmprintf and friends) or they are using an existing
wrapper written b
This is almost a general programming question, but any help would be
appreciated.
Root Problem:
/home/kiel/development/omms/output/libdbWrapper.a(dbwrapper.o): In
function `_ZN3srs9DbWrapper4openERKSs':
/home/kiel/development/omms/src/dbwrapper/dbwrapper.cpp:49: undefined
reference to `_sqlite
On Thu, 2005-08-25 at 00:18 +0200, Ramon Ribó wrote:
>
> Is there a way to define an aggregate function in the TCL binding?
No. Not at this time.
>
> In case it is not there, would it be a nice addition for symmetry with
> the C-C++ interface?
That depends. The interface is likely to b
Hello,
Is there a way to define an aggregate function in the TCL binding?
In case it is not there, would it be a nice addition for symmetry with
the C-C++ interface?
Also, I briefly reviewed the TCL binding C code and it looks like the
"function" interface does not take advantage of t
On Wed, 2005-08-24 at 10:08 -1000, Glen Nakamura wrote:
> On Wed, Aug 24, 2005 at 02:50:04PM -0500, Jolan Luff wrote:
> > OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible
> > to run "make test" without having done "make" first and this is no
> > longer the case with CVS HEAD
On Wed, 2005-08-24 at 14:50 -0500, Jolan Luff wrote:
> >
> > What is your environment? The build scripts have hardly changed
> > since 3.2.2 so it is hard to imagine what might have broken...
>
> OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible
> to run "make test" withou
On Wed, Aug 24, 2005 at 02:50:04PM -0500, Jolan Luff wrote:
> OpenBSD/amd64 with gcc 3.3.5. I noticed that with 3.2.2 it was possible
> to run "make test" without having done "make" first and this is no
> longer the case with CVS HEAD.
The problem could be the following lines in Makefile.in:
# I
On Wed, Aug 24, 2005 at 02:23:22PM -0400, D. Richard Hipp wrote:
> On Wed, 2005-08-24 at 13:08 -0500, Jolan Luff wrote:
> > I am trying to test this in my environment but it looks like the
> > build scripts were subtly broken as I can no longer run 'make test':
> >
>
> What is your environment?
On Wed, 2005-08-24 at 14:41 -0400, G. Roderick Singleton wrote:
> I recall that running make test as root gives very strange results.
>
You have a good memory. But that problem has been addressed:
See http://www.sqlite.org/cvstrac/chngview?cn=740
and http://www.sqlite.org/cvstrac/chngview?cn=236
On Wed, 2005-08-24 at 14:23 -0400, D. Richard Hipp wrote:
> On Wed, 2005-08-24 at 13:08 -0500, Jolan Luff wrote:
> > I am trying to test this in my environment but it looks like the
> > build scripts were subtly broken as I can no longer run 'make test':
> >
>
> What is your environment? The bui
On Wed, 2005-08-24 at 13:08 -0500, Jolan Luff wrote:
> I am trying to test this in my environment but it looks like the
> build scripts were subtly broken as I can no longer run 'make test':
>
What is your environment? The build scripts have hardly changed
since 3.2.2 so it is hard to imagine wh
On Wed, Aug 24, 2005 at 12:58:46PM -0400, D. Richard Hipp wrote:
> A bug introduced into the CVS tree on July 8 was causing
> malfunctions and segfaults when you attempt to DELETE or
> UPDATE more than 40960 rows in a single statement. This
> bug has now been fixed and a test case has been added t
On Aug 24, 2005, at 10:46 AM, Brown, Dave wrote:
Has anyone created (or is logging) a testbed so that new versions
of SQLite
can be run through some regression tests? Might want to add this
one to the
mix if so.
SQLite is one of the most regression tested piece of code I've ever
seen.
Dr. Hipp,
I tested the corrected code from the command line with complete success.
I did not perform any programmatic interface testing though.
Thank you for fix and for the quick turn around.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
Has anyone created (or is logging) a testbed so that new versions of SQLite
can be run through some regression tests? Might want to add this one to the
mix if so.
-Dave
-Original Message-
From: Downey, Shawn [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 24, 2005 11:56 AM
To: sqlite
A bug introduced into the CVS tree on July 8 was causing
malfunctions and segfaults when you attempt to DELETE or
UPDATE more than 40960 rows in a single statement. This
bug has now been fixed and a test case has been added to
the regression suite so that it will not go undetected
again. Version
> Now, whenever I insert into this table I want to set date_create to
> CURRENT_TIMESTAMP.
>
> Whenever I update a row I want date_lch (lch=last change) to be set to
> CURRENT_TIMESTAMP. (Changes to the date_create col should be (silently)
> 'ignored'.
If you feel you cannot trust applications to
Great! Thank you very much!
> I see the problem. I'm working on the fix now.
I see the problem. I'm working on the fix now. This will
result in 3.2.5, eventually.
The bug has been in the code for 2 months. Apparently nobody
tests out of CVS. :-(
--
D. Richard Hipp <[EMAIL PROTECTED]>
I built the sqlite 3.2.4 code in VC60 and ran the same delete statement:
delete from diagram_item where diagram_item.diagram NOT IN (select
diagram.name from diagram);
This caused a dialog box: Unhandled exception in sqlite3.exe:
0xC005: Access Violation
Clicking OK places the cursor in the
The database is in the mail (4MB). Thanks.
Some additional background:
A select with the same clause does not crash in 3.2.4. I.e.,
select * from diagram_item where diagram_item.diagram NOT IN (select
diagram.name from diagram);
3.2.3 does not crash with the delete or the select statement.
On Wed, 2005-08-24 at 10:56 -0400, Downey, Shawn wrote:
> I am experiencing a repeatable crash with Sqlite 3.2.4 under Windows XP
> when running the following SQL at the command line:
>
> delete from diagram_item where diagram_item.diagram NOT IN (select
> diagram.name from diagram);
>
It works
I am experiencing a repeatable crash with Sqlite 3.2.4 under Windows XP
when running the following SQL at the command line:
delete from diagram_item where diagram_item.diagram NOT IN (select
diagram.name from diagram);
The schemas in question are:
CREATE TABLE diagram
(
name varchar(24) n
You might find the syntax "INSERT OR REPLACE INTO" useful. It will do an
UPDATE if the record exists, or INSERT if it doesn't exist.
See http://www.sqlite.org/lang_insert.html
Hugh
Hello Serge,
But if you use CURRENT_TIMESTAMP for default value, the time
represents as string with format "-MM-DD HH:MM:SS".
This format is more human readable :)
--
Best regards
Sergey Startsev
SQLite Analyzer - SQLite database management tool with GUI.
http://www.kraslabs.com/sqlite_a
On Aug 24, 2005, at 6:49 AM, YOGESH wrote:
..
so i tried to build sqlite from source code.but again there i got the
erro gcc not installed.
do you have the Xcode tools installed? For 10.3, that should be the
version 1.5 release of Xcode tools (also known as 'developer tools').
You need t
Hello All,
From: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
"The julian day number is the preferred internal representation of
dates."
Unfortunately floating point values are not very readable when used
with existing GUI tools. The only problem is visualization, GUI tools
need to
Version 3.2.3 contained a memory allocation bug which could cause
a segfault when complex WHERE clauses are parsed. The problem is
fixed in version 3.2.4 which is now available on the website.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Hello all,
I tried to install sqlite 2.8.16 on mac os x 10.3 .
when i tried to install from .dmg file,a separate drive was crated and three
files namely sqlite,sqlite.a and sqlite.h were created when i tried to execute
the sqlite file i got the error saying that linncurses5.4.dylib is not there
The new update of SQLiteSpy has just been released.
SQLiteSpy is a graphical SQLite3 database browser, explorer and analyzer for
Windows 32 platforms.
SQLiteSpy features a database schema tree, full Unicode support, type colored
data grids, regular expression support, and more.
SQLiteSpy is fr
On 24.08.2005, at 03:21, Kurt Welgehausen wrote:
SELECT * FROM PRIM AS P
WHERE NOT EXISTS
(
SELECT REFID FROM REF1 WHERE REF1.REFID=P.ID
UNION
SELECT REFID FROM REF2 WHERE REF2.REFID=P.ID
);
I looks like correct SQL according to the SQLite docs,
but I don't understand why you coded the select
Hi,
Thanks for the response. I was pretty sure it wasn't possible to pregenerate
when using the commandline interface, but i couldn't find anything to confirm
either way.
I tried using two wrappers before (can't remember which ones now) but one of
them only supported SQLite 2.x, and the second
hi-
i see where it says to use isql viewer.
i am playing with that now trying to get it to work.
thanks,
jim
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
40 matches
Mail list logo