[sqlite] test/format 11.3 failing?

2004-02-03 Thread b.bum
Test 11.3 of format is failing on OS X... do_test format3-11.3 { execsql {SELECT '123456789012345678901'=='123456789012345678900'} } {1} why? thanks, b.bum - To unsubscribe, e-mail: [EMAIL PROTE

[sqlite] md5sum()

2004-02-03 Thread b.bum
e a matter of splitting out the TCL/Test specific stuff from md5.c. b.bum - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] md5sum()

2004-02-04 Thread b.bum
Enclosed patch adds md5() as an aggregate. Unit tests refactored to use md5() as opposed to md5sum(). All tests pass [that did before]. I broke the core md5 functions out into a header file full of static inlines. This reduces namespace pollution while still allowing the same code to be used

Re: [sqlite] md5sum()

2004-02-04 Thread b.bum
? +1 if so, -1 if not. Send 'em to me personally and I'll be happy to keep a running tally. b.bum - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Re: SQLite 2.8.12 test format-3-11.3

2004-02-10 Thread b.bum
'=='123456789012345678900'} } {1} ... and the two values are "not equal by inspection". If the test is expected to pass, why? b.bum - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Re: SQLite 2.8.12 test format-3-11.3

2004-02-10 Thread b.bum
significant digit. doubles are only accurate to 17 signficant digits (roughly) so the two number are indistinguishable. Thank you for the clarification. Could the test be changed such that it is version aware and the case changes appropriately to ensure that it passes based on version? b.bum

[sqlite] PENDING & WRLOCK/RDLOCK

2004-07-23 Thread b.bum
Some more locking questions... When sqlite3OsLock() takes out the PENDING lock, it switches between RDLOCK and WRLOCK depending on the locktype requested. However, it doesn't appear that any subsequent code checks for RDLOCK vs.WRLOCK on the PENDING BYTE. Actually, it appears that the only GET

[sqlite] SQLite & stack size

2004-09-03 Thread b.bum
the stack size appropriately along the way. The larger question is what changed in SQLite3 such that the stack size is significantly larger for common operations? I would imagine that this could be of concern for the embedded market. b.bum

Re: [sqlite] SQLite & stack size

2004-09-03 Thread b.bum
Thank you for the precise explanation -- very helpful. On Sep 3, 2004, at 8:19 AM, D. Richard Hipp wrote: alloca(), which does not work right on many systems. ... and would be on the stack anyway. b.bum

Re: [sqlite] Lock files....

2004-09-24 Thread b.bum
against the same database file using the regular locking path. I don't believe this is a case covered in the unit tests. b.bum

Re: [sqlite] Lock files....

2004-09-24 Thread b.bum
s specifically a request to have a test that ensures that the *** already existing locking features *** work correctly when multiple processes are beating upon the database. That is, to test code paths that already exist for which -- at least as far as I can tell -- there is little testing coverage. How is that bloating SQLite? b.bum

[sqlite] Begin transaction at RESERVED lock level?

2004-09-24 Thread b.bum
looking for a way to mark the lock as RESERVED at the beginning of the transaction in certain special cases. b.bum

Re: [sqlite] Begin transaction at RESERVED lock level?

2004-10-01 Thread b.bum
On Oct 1, 2004, at 3:20 AM, Michael Roth wrote: | I've been thinking about adding a PRAGMA that would cause this | behavior. Another option is added a keyword to the end of BEGIN, | for example "BEGIN EXCLUSIVE" or something like that. The "BEGIN EXCLUSIVE" approach is very attractive. That would

Re: [sqlite] How to install SQLite for use in XCode (MacOSX) ?

2004-10-02 Thread b.bum
py it -- it won't hurt anything and it'll make your project source dir more portable) - to include the sqlite3 header: #include That's all you need to do. b.bum

Re: [sqlite] How to install SQLite for use in XCode (MacOSX) ?

2004-10-03 Thread b.bum
ion. This also allows me to easily quantify changes to the OS project over time and track my own changes, if necessary. b.bum

[sqlite] CSV mode not correctly quoting output

2004-10-06 Thread b.bum
I'll file a bug on this. Anyone know how to file a bug such that the formating isn't smushed into a single line? Output from CSV mode is not properly quoted. An example (from sqlite3): sqlite> .mode csv sqlite> .header on sqlite> create table "Foo" ( foo, bar ); sqlite> insert i

Re: [sqlite] CSV mode not correctly quoting output

2004-10-06 Thread b.bum
I already logged a bug (#911) along with a fix Guido's time machine strikes again. Gotta love that. http://www.sqlite.org/cvstrac/tktview?tn=911 Will this make an appearance in 3.0.8 (or some other near-future version)? Thank you, b.bum

[sqlite] version-info same for sqlite2 and sqlite3

2004-10-06 Thread b.bum
Out of curiosity... Both sqlite2 and sqlite3 use --version-info "8:6:8" when creating libsqlite.la & libsqlite3.la. I would think the version # needs to be changed? b.bum

Re: [sqlite] SQLITE_BUSY returned without busy handler called

2004-10-18 Thread b.bum
r the other process to ABORT or for (A) to do an END TRANSACTION (which will work because the INSERT/UPDATE attempt on (A) failed to advance the lock state). b.bum

Re: [sqlite] SQLITE_BUSY returned without busy handler called

2004-10-19 Thread b.bum
ELECTs change, thus breaking assumptions made by INSERT or UPDATE. I guess I should really upgrade to sqlite3, which uses PENDING locks to try and eliminate writer starvation. Even with PENDING, you can still write code to cause a deadlock as I originally described. b.bum

Re: [sqlite] SQLite files locking

2004-10-19 Thread b.bum
om opening the file-- say, sqlite command line tool-- that is a much harder problem. Probably the easiest way would be to change the file format slightly. b.bum

[sqlite] minor typo

2004-10-21 Thread b.bum
PAGER_EXCLUSIVE occurs when before any changes ** are made to the database file. After an sqlite3pager_rollback() ** or sqlite_pager_commit(), the state goes back to PAGER_SHARED. There is a minor typo in the second to last sentence -- "occurs when before" doesn't make sense. b.bum

Re: [sqlite] Configure script

2004-10-31 Thread b.bum
This is because of a bug in Makefile.in that effectively causes .o files to be linked multiple times in the testfixture binary. b.bum

Re: [sqlite] Mac OS X, Readline 5.0, and SQLite

2004-11-06 Thread b.bum
e made a precompiled, statically linked, .so in my .mac account: http://homepage.mac.com/bbum/BumFiles/FileSharing27.html Just grab the .so files and shove 'em in /Library/Python/2.3/. (There is also a precompiled Python Berkeley DB module-- but it requires the BDB dylib to be installed). b.bum

Re: [sqlite] Mac OS X, Readline 5.0, and SQLite

2004-11-06 Thread b.bum
On Nov 6, 2004, at 10:48 AM, Jeff Flowers wrote: There has to it than just being under the GPL. After all, Emacs and other GLPed software is included in Mac OS X. Maybe it is to prevent people from accidently mixing GPLed and non-GPLed code? There isn't any GPL'd software on the baseline user insta

Re: [sqlite] Crashing on some computers

2004-11-09 Thread b.bum
s? Are you statically linking SQLite or using a dylib? b.bum

Re: [sqlite] Crashing on some computers

2004-11-09 Thread b.bum
/local/lib? ... alternatively, try otool -L on the compiled binary produced by Xcode. If you are dynamically linking SQLite, try building it statically (see the list archives -- I posed how to do this a few days ago). It may be that you are running into a dynamic linking issue. b.bum

Re: [sqlite] Crashing on some computers

2004-11-10 Thread b.bum
ymbol tables. Both hard to debug, unfortunately. b.bum

Re: [sqlite] Assertion failure in sqlite3pager_get

2004-11-10 Thread b.bum
n Mac OS X. First, validate the integrity of your database file. sqlite3 your.db pragma integrity_check; If the file is integral, then are you linking dynamically or statically? If dynamically, you need to tangle with the make stuff to build and link as a single module (it is a linker option). b.bum

[sqlite] faster sqlite3Malloc()

2004-11-12 Thread b.bum
There is an opportunity for a minor speedup in sqlite3Malloc(). sqlite3Malloc() is implemented as follows: void *sqlite3Malloc(int n){ void *p; if( (p = malloc(n))==0 ){ if( n>0 ) sqlite3_malloc_failed++; }else{ memset(p, 0, n); } return p; } The separation of th