database file mid-transaction.
I'm also seeing a similar problem in which it silently discards entries, but I
haven't been able to narrow down an example for you. Let me know if that would
be helpful and I'll try harder.
What could I do to improve LSM?
Charles
__
4418) at
> runlsm.cpp:41 (gdb) print pNext
> $1 = (ShmChunk *) 0x
>
>
>
> It's a pity that LSM isn't ready for production, because if the quality of
> sqlite3 is indication, I'm going to really enjoy using it!
>
> Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
27;t ready for production, because if the quality of
sqlite3 is indication, I'm going to really enjoy using it!
Charles
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello,
I have two sqlite databases. (db1, db2)
I try to write a trigger in db1 which inserts data to a table in db2.
In the sqlite docu there is a section about "Temp Triggers".
"...Except, it is possible to create a TEMP TRIGGER on a table in another
database."
CREATE TE
Hi,
perhaps, this can help:
1) download zip with latest SQLite DLL from http://sqlite.org/download.html;
2) unzip it to c:\temp;
3) copy c:\temp\sqlite3.dll to Windows\System32 folder;
4) if there is already sqlite3.dll in Windows\System32 and it's locked,
overwrite it with InUse.exe
website text. I
> suggest you may want to have a native English speaker proof it.
>
>
> On Wed, Oct 23, 2013 at 12:21 PM, Sqlite Dog wrote:
>
> > Hi,
> >
> > we are happy to announce a final release of SqliteDog: a modern SQLite
> > database manager.
>
Hi,
we are happy to announce a final release of SqliteDog: a modern SQLite
database manager.
http://sqlitedog.com
--
Regards,
SqliteDog support team
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
Hi,
seems like SQLite is not checking trigger SQL for invalid column names
until execution? Is there a way to force this check?
The problem: trying to find out which indices, triggers and views depend on
particular column. We can recreate table without this column and recompile
indices, triggers
We are using SQLite 3.7.17
2013/8/13 Sqlite Dog
> What is a best way to detect that query does full table scan? Considering
> this (from http://www.sqlite.org/eqp.html ):
>
> "Warning: The data returned by the EXPLAIN QUERY PLAN command is intended
> for interactive de
What is a best way to detect that query does full table scan? Considering
this (from http://www.sqlite.org/eqp.html ):
"Warning: The data returned by the EXPLAIN QUERY PLAN command is intended
for interactive debugging only. It may change dramatically between SQLite
releases. Applications s
On Sat, 20 Jul 2013 18:03:43 +0100, Simon Slavin - slav...@bigfraud.org
wrote:
On 20 Jul 2013, at 3:11pm, sqlite.20.browse...@xoxy.net wrote:
this in-memory database actually persists. Ie. Beyond the life of the
program that created it.
Then it's not an in-memory database. Hav
On Sat, 20 Jul 2013 18:03:43 +0100, Simon Slavin - slav...@bigfraud.org
wrote:
On 20 Jul 2013, at 3:11pm, sqlite.20.browse...@xoxy.net wrote:
this in-memory database actually persists. Ie. Beyond the life of the
program that created it.
Then it's not an in-memory database. Hav
question is: Why is this file not being deleted?
As far as I can tell I am doing everything I can to enable it -- finish()ing my
statement handles and disconnecting my connections -- but it still persists
unless I unlink the file.
Is this a sqlite bug? Or a DBD::Sqlite bug? or a DBI bug; or s
OK. Thank you.
2013/7/19 Richard Hipp
> On Fri, Jul 19, 2013 at 9:20 AM, Sqlite Dog wrote:
>
> > >
> > > There is no way to detect which encryption algorithm is used. Indeed,
> > the
> > > encryption is so thorough that there is no way to tell whether
2013/7/19 RSmith
> Being a Delphi Developer (mostly) and using SQLite quite often, I can tell
> you some things about it:
>
> You can easily wrap an SQLite DLL in Delphi, there are many free
> implementations of this, if you dont have one, send me a mail and I will
> supply one
2013/7/19 Ralf Junker
> On 19.07.2013 09:21, Sqlite Dog wrote:
>
> > Our database manager is developed using Delphi (Pascal). Thus it is
> > not possible to statically link SQLite library, SQLite.dll is used.
> > Is there some other way to support SEE in our project?
2013/7/19 Richard Hipp
> On Fri, Jul 19, 2013 at 3:21 AM, Sqlite Dog wrote:
>
> >
> > Our database manager is developed using Delphi (Pascal). Thus it is not
> > possible to statically link SQLite library, SQLite.dll is used. Is there
> > some other way
That's interesting. What about pas file with function declarations to
SQLite API? Should it be modified somehow?
2013/7/19 kyan
> On Fri, Jul 19, 2013 at 10:21 AM, Sqlite Dog wrote:
>
> >
> > Our database manager is developed using Delphi (Pascal). Thus it is not
>
Hi all,
Anyone here using SQLite via Perl & DBI & DBD::SQLite?
Thanks, buk.
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
Check it out at http://www.inbox.c
Hi,
documentation on SEE (http://www.hwaci.com/sw/sqlite/see.html) states that
"You can ship as many compiled, binary copies of SQLite with your
commercial product as long as each copy is attached to your product in such
a way that it cannot be separated from your product. Normally this
coll - my opinions are my own.
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/tools/speedtest.py
Well, performance is not an issue... What I'm looking for is a database
with all sorts of database objects available.
Perhaps, SQLite developers already have one for their own purporse and
would be able to share it.
--
Regards,
SqliteDog support team
_____
Hi,
we are developing (yet another :) SQLite manager.
I'm wondering is there available sample "feature-tight" "limit-striking"
SQLite database (or SQL script) for GUI manager testing purposes?
Like:
- identifier names contains spaces, UNICODE chars, are surro
y of the internal formats.
See this discussion: http://stackoverflow.com/a/11102689/179850
Thanks much for Sqlite!!
--
This message was sent from a MailNull anti-spam account. You can get
your free account and take control over your email by visiting the
following URL
Hi,
Canonical ha released a first prototype of u1db, a sqlite based
document db which is syncable. Somehow this reminds me of a
combination of the fossil db model and unql and unqlspec. Is there a
relation between the projects?
thanks
Hi,
some time ago Richard was involved in http://www.unqlspec.org/ . Is
that still going on? I am quite interested in a backend for sqlite.
thanks,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
docs.
A bit related is a question on the vfs. apsw allows to implement a
vfs. Is this also possible with tcl?
thanks,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Test.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
de that is common to all os_*.c files
*/
-->8---
> make test
:
All tests successful.
Files=59, Tests=1308, 87 wallclock secs ( 4.61 usr 0.48 sys + 53.42
cusr 3.96 csys = 62.47 CPU)
Result: PASS
>
_______
sqlite-users mailing list
sqlite-users@sql
Hi,
I have put together a simple uuid generation method in sqlite:
select '{' || hex( randomblob(4)) || '-' || hex( randomblob(2))
|| '-' || '4' || substr( hex( randomblob(2)), 2) || '-'
|| substr('AB89
e a code review.
PS C:\rev\src\sqlite3\src> fossil info
project-name: SQLite
repository: c:\rev\fossil\sqlite3.f
local-root: C:/rev/src/sqlite3/
user-home: : C:/Users/rev/AppData/Local
project-code: 2ab58778c2967968b94284e989e43dc11791f548
server-code: 2fa7c8b2762294d28396292f74c7b94c
My "procedural language" is C#, so that is a can-do situation. But I would
like to get a lot more out of set-based SQLite if possible.
On Fri, Dec 11, 2009 at 11:55 PM, Igor Tandetnik wrote:
> Sqlite Fool wrote:
> > In a previous life, I was able to get the stuff i
Hey all. Very happy to have found this e'list. I have worked with a few
other DB (and DB-ish) systems in the past but am only now taking a deep-dive
into SQLite.
I am attempting to load a delimited text file into a Celko-style nested-set
model table.
In a previous life, I was able to ge
I sent this last night, but it didn't post on the list. Trying again to make
sure this is working.
-- Original Message --
Received: 08:40 PM MDT, 08/27/2009
From: cscs-sql...@usa.net
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Conditional tri
Dan, updating to sqlite3.dll version 3.6.17 did fix the problem.
Also, I should clarify what I meant by having the query syntax doc on the
sqlite web site. It is indeed on the web site, but I spent a lot of time
yesterday trying to find a document just like it and couldn't. It just needs
Dan, thank you for the additional information, it's most helpful. I'll let
you know what I find out.
BTW, any reason that doc is not on the SQLite Web site? It would help a lot
of people understand the old and new query syntax better.
Craig
> >
> > Did an FTS3 update ch
but
With, sqlite3.dll version 3.6.16:
colname match 'tetons -bend -jackson -oxbow* -parks' no longer works
correctly. It acts like only the last negated token is being used and results
have bend, jackson and oxbow* tokens in them.
I used SQLite Expert to test this on the same sqlite database
main.mytable(col1,...colN) SELECT col1,...colN FROM dbA.myothertable
COMMIT
DETACH dbA
sqlite3_close B.db
Cheers!
From: Wenton Thomas
To: sqlite-users@sqlite.org
Sent: Saturday, 4 July, 2009 7:31:55 PM
Subject: [sqlite] problem with SQLITE_BUSY
Now in my
Hi All,
As part of a project I am toying with writing I
needed undo/redo functionality, so have ended up writing a loadable
extension for sqlite which implements undo/redo functionality entirely
within the database using custom functions. Kind-of a C implementation
of http://www.sqlite.org
dings.
end loop
sqlite3_finalize();
See sqlite_bind_[](), sqlite_reset(), sqlite_clear_bindings() in manual
From: knightfeng
To: sqlite-users
Sent: Friday, 3 July, 2009 5:02:57 PM
Subject: [sqlite] How to do 5,000,000 "select"s as fast as possible
Dea
(embarrassed)
printf("testValue=(%s)\n", testValue);
From: John Machin
To: General Discussion of SQLite Database
Sent: Tuesday, 30 June, 2009 4:51:09 PM
Subject: Re: [sqlite] first few characters of varchar() corrupted when
SELECTing from a C++ pr
I should have looked harder...
"The order of arbitrary."
http://www.mail-archive.com/sqlite-users@sqlite.org/msg17641.html
From: "freshie2004-sql...@yahoo.com.au"
To: sqlite-users@sqlite.org
Sent: Tuesday, 30 June, 2009 2:31:40 PM
Subje
____
From: pierr
To: sqlite-users@sqlite.org
Sent: Tuesday, 30 June, 2009 2:42:16 PM
Subject: Re: [sqlite] first few characters of varchar() corrupted when
SELECTing from a C++ program?
uralmazamog wrote:
>
> Greetings,
>
> maybe it's just me bei
CREATE TRIGGER atest_2 AFTER INSERT ON Test
BEGIN
INSERT INTO Log(s) VALUES('atest_2');
END;
INSERT INTO Test(s) VALUES('Test');
SELECT rowid,* FROM log;
Returns the following on both windows (3.6.14) and linux (3.4.2):
1|btest_2
2|btest_3
3|btest_1
4|atest_2
5|atest_3
6|atest_
D. Richard Hipp a écrit :
> This is not error in the SQLite code. The code here is correct. The
> bug is in your compiler.
Sorry but I don't agree at all.
> Adding a work-around so that this will work in your compiler makes the
> code rather more complicated:
&g
> This is probably not a bug. There are places in the SQLite code where
> we deliberately discard all but the lower 8 bits of an integer. But,
> if you like to tell us *where* in the code this occurs, I'll be happy
> to verify it for you.
In sqlite3.c big file,
Hello all,
I'm compiling sqlite 3.6.13 with Visual 2003, and RunTime Check
activated, and it gives this error :
Run-Time Check Failure #1 -
A cast to a smaller data type has caused a loss of data. If this was
intentional, you should mask the source of the cast with the appropriate
bi
Hi everyone,
I'm new to sqlite and this mailing list and hope to get some help
here. I've used SQLite for some projects now and I must say, that it
is the fastes database I ever used. Great work!
But there is one thing, that I really dislike, because I get errors
sometimes with this a
Hi!
Is this expected?
$ sqlite3
SQLite version 3.6.10
Enter ".help"for instructions
Enter SQL statements terminated with a ";"
sqlite> select round(3.1416);
3.0
CPU Time: user 0.000000 sys 0.00
sqlite>
I expected an integer 3 as documented:
round(X)
round(X,Y)
All:
For comparison I tried several combinations of query orders and indices.
I found both indices and the join clause sequence make significant
differences in execution time. Using SQLiteSpy with SQLite v3.6.1 on
Windows XP.
I have two tables:
GPFB with 34830 rows, 10 columns with a 4-column
re than one
> > name...
>
> However you can specify that the name/id pair is unique ...
> PRIMARY KEY (name, id)
>
> Regards,
> MikeW
Excellent!
Thanks, I didn't know that...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the 'id' column 'unique' as a client may have more than one
name...
What is the recommended way to do this with SQLite?
PS: I'm not wrong in thinking that IF EXISTS (...) THEN ...
isn't implemented, am I? I couldn't get the sqlite3 interpreter
to accept any stat
nkJon <[EMAIL PROTECTED]>
Sent: Friday, September 26, 2008 6:56 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Issue when enabling fts3 in sqlite3
Oh, I was using the amalgamate source code 3.6.3 ... so I believe the problem
was related to what Roger mentioned below.. Thanks though fo
:
>
> IF you are using SQLite with eVC, you must enabled function level linking,
> because
> ARM linkers had a bug before eVC SP4 that generated corrupt image files.
>
> On Thu, Jun 12, 2008 at 9:39 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> De
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
Dear Virgilio,
Thanks for your Quick reply, we dont know how to enable the funtional level
linking using SQLite with eVC, so kindly tell us how to enable the same.
Thanks & Regards,
kartthikeyan
Virgilio Alexandre Fornazin-2 wrote:
>
> IF you are using SQLite with eVC, you mu
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc of type DTX 10 processor ARMV4T.Also we have
generated the lib file specific for ARM processor using the LIB.exe with the
parameters DEF:sqlite3.def MACHINE:ARM and the sqlite3.lib and sqlite3
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a inner join query which
>> takes
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc.Here we are using a inner join query which takes
different time during different executions, the query which we using in our
application is
"SELECT DISTINCT MT.PcNo, MT.SubPcNo, MT.Br
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a query which has three
>> Inner joins
Dear All,
We are using SQLite for our application development which would be deployed
in a pocket pc.Here we are using a query which has three Inner joins and
using sqlite3_prepare and sqilte3_step function to prepare the records and
to fetch the records.By executeing the Query and we moves to
query does
it mean the execution time for our query is 40 secs because we are
retrieving the records soon once gets executed.
Regards
Kartthi
Stephen Oberholtzer wrote:
>
> On Tue, May 27, 2008 at 9:06 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> Dear All,
>
Dear All,
i have developed an application using SQLite which runs in the pocket pc
device. My application has to show some messages in a list box (custom
build) while moving forward im able to move the records one by one in the
recordset. But when i move upwards im not able to move to the
Dear All,
I have just started using the SQLite Db in my applications. My application
runs under MIPS processor. I have generated the Sqlite3.dll and Sqlite3.lib
file for the MIPS processor and it is geting compiled. When i use
Sqlit3_Open function to open a DB, it fails with the error message
es work.
Thanks, Si.
-
Get the name you always wanted with the new y7mail email address.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
sqlite-users@sqlite.org wrote:
> Hi all,
>
> Hopefully you can help, while running sqlite version 3.5.5
>
&g
sqlite-users@sqlite.org wrote:
> Hi all,
>
> Hopefully you can help, while running sqlite version 3.5.5
>
> Two seperate threads each attempt to run a vacuum command against the same
> db. Each thread has an independent connnection to the db.
>
> One thread succe
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
Hi all,
Hopefully you can help, while running sqlite version 3.5.5
Two seperate threads each attempt to run a vacuum
Hi all,
Hopefully you can help, while running sqlite version 3.5.5
Two seperate threads each attempt to run a vacuum command against the same db.
Each thread has an independent connnection to the db.
One thread succeeds and the other gets a return code of 1 (SQLITE_ERROR) from
ìì ìê° sqlite-users@sqlite.org ë¡ë¶í° ì¤ë ë©ì¼ì ìì ì ê±°ë¶íììµëë¤.
_
--- Begin Message ---
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error,
'Connection' object has no attribute 'autocommit'
I´ve had a google for this and its seems like it may be a bug python-sqlite or
sqlite bug , but also I tri
- Original Message
> From: John Stanton <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 14, 2007 11:43:48 AM
> Subject: Re: [sqlite] Re: Threads
>
> If you machine has a single disk it fundamentally does not have parallel
> I/O.
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Tuesday, September 4, 2007 3:32:38 PM
> Subject: Re: [sqlite] 3.5.0 alpha TryEnterCriticalSection linker error
>
>
> =?ISO-8859-1?Q?Daniel_
>
> - Original Message
> From: Zbigniew Baniewski <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, July 26, 2007 4:12:00 PM
> Subject: Re: [sqlite] Problem with SQLite FastCGI module "malformed database
> schema"
>
>
>
Hello, everybody
I have the following problem: I have the following tables:
Months
--
CREATE TABLE 'Months'
(
IDMonth INTEGER PRIMARY KEY NOT NULL,
MonthRef INTEGER
);
(where MonthRef is the date of the first day of the month - created in the code)
C
ANIEL writes:
Howdy all!
I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite. It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves. I have
added support for Unicode to his wrapper, then added my Ma
- Original Message
From: Martin Jenkins <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, June 22, 2007 2:00:45 PM
Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH
script
litenoob wrote:
> Hi, I'm wondering how to write a BASH sc
Hello.
I am a newbie both to sqlite and tcl. I would like to learn how to run the
test suite, so that later, when I start modifying the source code (e.g. to
make a customized subset), I can verify that I have not broken anything.
Is there a document somewhere that describes how to run the
> - Original Message
> From: Joe Wilson <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Monday, June 11, 2007 8:36:32 PM
> Subject: Re: [sqlite] Database replication question
>
>
> Large bulk inserts with more than one index (implicit or expli
Hi all
I am trying to put in place a simple replication process to copy a database
from one machine to an other.
The table I have is something like
CREATE TABLE sn2uid(sn VARCHAR(100) NOT NULL, uid INTEGER NOT NULL, PRIMARY KEY
(sn));
CREATE INDEX uidindex on sn2uid ( uid )
Where the (sn,uid) p
- Original Message
> From: Dennis Cote <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, May 30, 2007 12:09:25 PM
> Subject: Re: [sqlite] sqlite internal structs don't make use of C bitfields?
> You may want to look at how the isInited fiel
- Original Message
> MemPage bitfield patch below.
>
> sizeof(MemPage) on Linux:
>
> original: 84
> patched: 76
> ...
> Break-even for memory is 904/8 = 113 MemPage structs allocated.
I didn't look at the code, so mind me :)
If the MemPage are malloced individually (instead of b
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Tuesday, March 27, 2007 1:50:51 PM
> Subject: Re: [sqlite] Transaction detection...
>
>
> [EMAIL PROTECTED] wrote:
> > Hi all
> >
Hi all
Is there a way to detect if a transaction is active on the current connection?
Basically the equivalent of "PQtransactionStatus" in postgresql.
I need that to automate rollback or commit depending on other variables within
my application while keeping the connection open.
Thanks!
Nicola
hi,
SQLite version 3.3.13 is now available in the usual place:
...
As always, please let me know if you find any problems.
building 3.3.13 on osx, all's seemingly well, except the process still
fails to build/install one file,
% cd /usr/ports/sqlite_build
% ls doc/whentouse
easy enough ...
@661
Makefile.in
install:sqlite3 libsqlite3.la sqlite3.h ${HAVE_TCL:1=tcl_install}
$(INSTALL) -d $(DESTDIR)$(libdir)
$(LTINSTALL) libsqlite3.la $(DESTDIR)$(libdir)
$(INSTALL) -d $(DESTDIR)$(exec_prefix)/bin
doing a clean build of v339 on osx 10.4.8.
% cd /projects/sqlite_build
% ../sqlite-3.3.9/configure --prefix=/usr/local/sqlite --enable-tcl
--enable-shared --enable-static --enable-debug --enable-threadsafe=yes
and,
% make
complete successfully.
at,
% make install
it fails at
after building docs, on the "docs.html" page, there's a reference to
"whentouse.html",
Appropriate Uses For SQLite
when i click on it, it's a missing page.
looking in mybuild dir,
% ls doc/
arch.html datatype3.html ol
comparing with apples' darwin-bundled sqlite src for an older sqlite
version (313 was it?), the addition of,
-DASSERT_VIA_CALLBACK=1 -DENABLE_LOCKING_CALLBACKS=1
as CFLAGS _seems_ to do the trick.
after applying the patch discussed earlier, then,
cd /projects/sqlite-3.3.8/conf
re-config+building, then
./testfixture ../sqlite-3.3.8/test/conflict.test
finishes with NO errors.
Memory leaked: 0 bytes in 0 allocations
Thread-specific data deallocated properly
0 errors out of 127 tests
Failures on these tests:
checking als
whittling down the last few testsuite errors,
% ./testfixture ../sqlite-3.3.8/test/conflict.test
reports,
conflict-1.0... Ok
(...)
conflict-6.1... Ok
conflict-6.2...
Expected: [0 {7 6 9} 1 1]
Got: [0 {7 6 9} 1 0]
conflict-6.3
> well, a 0.04% test failure rate ain't bad!
>
Are you, perchance, running this on a network filesystem of
some kind?
nope. all on my 'local' box.
just starting to look over these ...
i had NOT *defined* UTF8 as the encoding of choice ... or, at all,
actually. so, iirc, that means defaault t
FWIW, my MacBook has nothing special installed. The "About This Mac"
dialog box says "Mac OS X Version 10.4.8. 2GHz Intel Core Duo". I
searched through the Makefile that configure generated and there was
no sign of a -static flag anywhere. "gcc -v" says version 4.0.1,
(Apple Computer, Inc. bui
now, to check 'make fulltest', with,
% chown -R snowcrash /projects/b1
% chown -R snowcrash /projects/sqlite-3.3.8
% sudo -u snowcrash make fulltest
and see if this 'holds'.
with the mods i've made,
make fulltest
reports,
...
Thread-specific data deallocated p
in/finkinfo/database/sqlite3.patch?revision=1.1&view=markup
to sqlite v3.3.8, the 'errors' are gone.
(NOTE: from "dmacks" @ #fink
"that -static patch is not really portable upstream ...
The tail syntax change is backward-compatible, but is the only one
recognized by new ve
> can you tell me what, specifically, does 'just' this,
>
> cd b1
> ./testfixture ../sqlite/test/autovacuum_ioerr2.test
>
> report for you?
>
Thread-specific data deallocated properly
0 errors out of 1761 tests
well, for the life o' me, here, (now on 2
what, specifically, does 'just' this,
cd b1
./testfixture ../sqlite/test/autovacuum_ioerr2.test
report for you?
thanks.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
just fyi,
i've now tested this on a different osx box, in order to try to rule
out something/anything 'environmental'. this box is, basically, a
'vanilla' osx install.
same problem -- same errors.
-
To unsubscribe, sen
checking readline header files... not specified: still searching...
checking readline.h usability... no
checking readline.h presence... no
checking for readline.h... no
checking for /usr/include/readline.h... configure: error: cannot check for file
existence when cross compiling
not sure on you
101 - 200 of 242 matches
Mail list logo