Re: [sqlite] DLLs containing user-defined SQL functions

2006-06-07 Thread Ted Unangst
ibrary, and not any other, but any other library calling "foo" may land in a different symbol. depending on what you pass to dlopen/dlsym, you can usually find the symbol you want. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] SUM and NULL values

2005-09-08 Thread Ted Unangst
le is much more compelling than the October sales, so I change my vote. Standards are good. :) -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] SUM and NULL values

2005-09-08 Thread Ted Unangst
" the answer is not "I can't tell." Exacting correctness aside, I would expect 0 to confuse fewer people. Is it more likely an SQL expert relies on NULL being different than 0, or that a non-expert selects sum() without considering the NULL possibility? Perhaps a pragma is the right answer? -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] 2.8.16

2005-09-08 Thread Ted Unangst
sqlite-2.8.16.tar.gz md5 should be available, no? -- Ted Unangst www.coverity.com Coverity, Inc.

[sqlite] disable locking?

2005-06-21 Thread Ted Unangst
From a quick check of the sources, I didn't see anyway to disable locking for a database. Correct? Would it be useful to have a pragma to simply turn off locking for a database? -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] Basic Text Bind Question

2005-06-07 Thread Ted Unangst
x27;Fullman' );" ); size = sprintf( buf, "INSERT INTO People VALUES( 'Mike', 'Smith' );" ); size = sprintf( buf, "SELECT * FROM People WHERE lname = '?'" ); unless you deleted the code between the sprintf lines, this isn't doing what you think it is. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] SQLite on Motorola Power PC

2005-04-20 Thread Ted Unangst
erate config.h. I've not removed config.h from Makefile.in or Makefile.linux-gcc. All tests on Linux x86 with gcc 3.3.3 pass OK with this code. Not tested on other platforms or cross-compile. Apply patch (in sqlite directory) with: Looks like it will deref 0 to get Timeout in some cases. -- T

Re: [sqlite] NFS Query Performance

2005-04-19 Thread Ted Unangst
lls in os_unix.c. In fact, there's a #define and comment for DJGPP that does exactly what you want. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] Indexing problem

2005-04-19 Thread Ted Unangst
t :P). Once you get comfortable with the fact that only a single index can be used everything makes sense. Just to be clear, you mean a single index per table, right? Two tables in a where can use two indices in sqlite? -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] Storing 64-Bit Addresses

2005-03-31 Thread Ted Unangst
om Example WHERE ? < (begin + end); Store the length of the region, instead of the end. Or is that impossible? I'm not sure what physical property (begin + end) could refer to. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] Version 3.2.0

2005-03-24 Thread Ted Unangst
o support, I be happy to start using it. The NetBSD version of libedit supports libreadline compat. There's a portable version at http://www.thrysoee.dk/editline/ -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] sqlite_exec_printf and length modifiers

2005-02-22 Thread Ted Unangst
convert 64 bit integers to strings before inserting? snprintf into a temp buffer, then use %s (or %q) with sqlite_exec_printf. but all the sqlite functions should certainly take %lld. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] sqlite3-3.1.2.bin segfault

2005-02-15 Thread Ted Unangst
" claim does not appear to extend to running on any machine other than the build machine. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] bug in btree code 3.0.8

2005-01-07 Thread Ted Unangst
x the problem. -- Ted Unangst www.coverity.com Coverity, Inc.

Re: [sqlite] bug in btree code 3.0.8

2005-01-06 Thread Ted Unangst
rrect is it not? It should not be 4 bytes before. If that's wrong, I will go back to debugging this on my own. ok, mailing list doesn't like long messages. you can get the sql at http://www.coverity.com/sqlcmds -- Ted Unangst www.coverity.com Coverity, Inc.

[sqlite] bug in btree code 3.0.8

2005-01-06 Thread Ted Unangst
g else I can do to help? -- Ted Unangst www.coverity.com Coverity, Inc.