_FTS1"
StringPooling="true"
ExceptionHandling="0"
BufferSecurityCheck="false"
EnableFunctionLevelLinking="true"
Runti
hello to all. I wish to report some quirks I discovered with floating point
and
ROUND() function, while looking into a problem reported by my development
team wrt
to sqlite handling of above function.
first of all, let me state that I understand the issues with inexact
floating point
well, yes, it IS a limitation, which I will fix in the next release. the
problem is,
EXP registers its own version of a "date" function, as described in the
readme (I think I did describe it :), which is completely different than the
standard sqlite3 date function. I will make this optional in the
yes, I am sure. I tested with 3.1.3, with the same results.
>
> I'll eventually get to this. If Dan's fix is correct, though,
> the problem was introduced after 3.2.2. Are you sure you are
> not using code out of CVS?
>
I have found a bug in the way sqlite treats ORDER BY clauses.
to reproduce the bug, run this script against an empty database (memory db
would do):
===
CREATE TABLE Eidh (
ekey VARCHAR(12) NOT NULL,
perigrafh VARCHAR(30) NOT NULL,
PRIMARY
What do you want if the user types "SELECT (t0.x || t1.x) FROM table0,
table1 ."?
I would like to second that request. Ok, sure, there are cases where the
info is meaningless (like above), and should be blank.
But in most cases, it IS meaningful, and extremely useful for tools (not so
much
I am not running on *ix, so I cannot test.however, your mentioning multi-cpu
machines, brings something to mind.
In windows, most synchronization functions rely on some form of INTERLOCKED
operation. Now, these operations are implemented differently on multi-cpu
(and hyperthreading counts as
Definitely 3.x. why go with an old version ?
-Original Message-
From: Ahmet Aksoy [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 01, 2005 3:10 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Advice needed for a new group member
Hi Mike,
I'll check your wrapper as son as
In the home page of www.sqlite.org there is a "contrib" link in the right
upper area.
It points to http://www.sqlite.org/contrib
-Original Message-
From: Bert Verhees [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 30, 2004 11:02 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
In a previous thread about sqlite_schema, I commented that there *is* a case
where
SQLITE_SCHEMA does get raised as an error, although DRH said that this is
not possible in
version 3.x. It turns out that I was wrong. The scenario I described does
raise an error,
but it is not SQLITE_SCHEMA, it is
> In SQLite version 3.0, when a schema change occurs, SQLite
> automatically goes back to step 1, rereads the schema, and
> tries again. So you should never get an SQLITE_SCHEMA error
> in version 3.0. Back in version 2.8, you could get an
> SQLITE_SCHEMA error in some circumstances. When
look into www.sqlite.org/contrib
- Original Message -
From: "Edovia Technologies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 3:45 AM
Subject: [sqlite] SQLite manager for Windows
> Hi,
>
>
>
> Anyone knows about a SQLite 3 manager for Windows? The
- Original Message -
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 02, 2004 5:25 PM
Subject: Re: [sqlite] new uploads
ok, Denis I have fixed the bug and uploaded the new version of
sqlite3Explorer. thanks for pointing it out.
BTW, I have some
>
> - set the pragma "temp_store" to MEMORY
> - CREATE TEMPORARY VIEW temp_table AS ()
>
> I am assuming that temp_table is completely in memory, and any queries
> against it will not go back to the disk. Since the table itself is
> small, I am hoping that the overhead of reading the entire table
> It would usually make more sense to do the following:
>
> BEGIN TRANSACTION;
> ... inserts,updates,deletes
> COMMIT;
>
> You get pretty much the same affect, but it is safe. Setting
yes, I am aware of this, of course. what I am saying is : since there *is* a
cache,
and since we *can* modify its
> Yes, I was a trifle optimistic with my estimates
>
> On an operating system with a sensible I/O scheduler (I cannot say
> whether or not windows qualifies) it should normally take about
> two complete rotations of the disk platter to complete a write.
> Obviously a large change would take
I have a new version of sqliteExplorer, which handles v3 databases, and has
some other enhancements as well, for some time now. The problem is, I dont
have a web server to put it on. DRH, is there some place on the site where I
can upload it ?
question to all:
how many people use sqlite with
- Original Message -
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 07, 2004 7:10 PM
Subject: Re: [sqlite] Is this an in-memory database too
> Yes. As many different processes as you want can read the database
> at the same time. Only one
I am using a parametric sql statement, with parameters of the form :Name
The following routines give an access violation, when called via the windows
dll:
sqlite3_bind_parameter_name
sqlite3_bind_parameter_index
The access violation indicates that a NULL pointer is being accessed.
A brief look
19 matches
Mail list logo