Re: [sqlite] Compiler warning for v3.7.5 -- signed overflow

2011-02-23 Thread Richard Hipp
w.sqlite.org/testing.html#staticanalysis -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] apostrophes in strings...

2011-02-23 Thread Richard Hipp
ase and specify the decryption key. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation seams to be wrong.

2011-02-24 Thread Richard Hipp
ing an older version. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] Parallel execution of queries in threads

2011-02-24 Thread Richard Hipp
k 2 seconds. > Total Rows in table are 10. > Sample query is "SELECT column1, sum(column2) from TABLE_NAME;" > > What can be the reason behind this? > Have you tried this using SQLite version 3.7.5 or are you using a prior versio

Re: [sqlite] Bug Report - undefined function as a default value cause segmentation fault.

2011-02-28 Thread Richard Hipp
alues('xxx');" > Fixed on 2009-08-18. Fix first released in version 3.6.18. http://www.sqlite.org/src/info/093917d > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/

Re: [sqlite] adding fdopen to VFS?

2011-02-28 Thread Richard Hipp
g to implement > it), the functionality needed for Chromium could be implemented very > cleanly. What do you think about that? > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/list

Re: [sqlite] adding fdopen to VFS?

2011-02-28 Thread Richard Hipp
ion used by > sqlite instead of POSIX's open. In this case, that would roughly > be PlatformBridge::databaseOpenFile. > Can't you simply compile the standard "sqlite3.c" amalgamated source file using -Dopen=openUsingPlatformBridge and then implement a single function openUsi

Re: [sqlite] adding fdopen to VFS?

2011-02-28 Thread Richard Hipp
On Mon, Feb 28, 2011 at 1:00 PM, Paweł Hajdan, Jr. wrote: > On Mon, Feb 28, 2011 at 15:12, Richard Hipp wrote: > >> On Mon, Feb 28, 2011 at 8:36 AM, Paweł Hajdan, Jr. < >> phajdan...@chromium.org> wrote: >> >>> >>> I remember a part of earlier dis

Re: [sqlite] adding fdopen to VFS?

2011-02-28 Thread Richard Hipp
On Mon, Feb 28, 2011 at 2:33 PM, Richard Hipp wrote: > > > On Mon, Feb 28, 2011 at 1:00 PM, Paweł Hajdan, Jr. < > phajdan...@chromium.org> wrote: > >> >> What do you think about adding a call like below to the VFS interface? >> >> int (*xOpenW

Re: [sqlite] possible bug handling group by and where clauses

2011-03-02 Thread Richard Hipp
c - Évolution > iter62|text|1|integer|Blanc - Évolution > > i do not believe it should be possible that a query with a left join > yields less results > than the exact same query with an inner join. > > possibly this would be expected from a having clause on the table right > to the join but that would be asking for t

Re: [sqlite] Adjusting strategy for ROWIDs

2011-03-04 Thread Richard Hipp
retty good PRNG. Unlike LCG and LFSR PRNGs, the output sequence does not loop the first time you get a repeated output value. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] Indexing - a test example

2011-03-07 Thread Richard Hipp
> > Thanks in advance. > > Jonathan Trahair > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] jquery sqlite3

2011-03-07 Thread Richard Hipp
Also there was no independent implementation of SQLite (I guess they didn't know about Noah Hart's work) and the committee felt like they needed at least two implementations in order to make something a standard. We're all really sad about this -

Re: [sqlite] no such function: sqlite_attach?

2011-03-07 Thread Richard Hipp
t miscreants from bypassing any sqlite3_set_authorizer() restrictions on the use of ATTACH by calling sqlite_attach() directly. > > Sam > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bi

Re: [sqlite] Failure during Rollback statement

2011-03-09 Thread Richard Hipp
e mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Getting random data from grouped data in one table

2011-03-09 Thread Richard Hipp
> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

2011-03-10 Thread Richard Hipp
it ever be changed by some event, for example a Vacuum? Do > rowid gaps ever get "compressed"? > You can rely on an INTEGER PRIMARY KEY being stable. > > Thanks > dw > > > ___ > sqlite-users mailing list > s

Re: [sqlite] Rowids, bit-arrays, recycling, and performance

2011-03-10 Thread Richard Hipp
On Thu, Mar 10, 2011 at 11:01 AM, Jay A. Kreibich wrote: > On Thu, Mar 10, 2011 at 10:37:14AM -0500, Richard Hipp scratched on the > wall: > > On Thu, Mar 10, 2011 at 10:31 AM, Dave White >wrote: > > > >1. Do I understand this correctly? > > > > N

Re: [sqlite] Optimization SQLite

2011-03-14 Thread Richard Hipp
ot;printf and pause" > and this is a hard way to debug a program that has more than 100.000 lines. > I'm using Dev-C++ and the debugger didn't support this code. Could you > recommend one good IDE to do that? > > Regards, > Thiago Fernando Gregolon. > > >

Re: [sqlite] Running TCL tests on 3.7.5

2011-03-15 Thread Richard Hipp
while compiling > "uplevel do_test $testname [list "execsql {$sql}"] [list [list {*}$result]] > This indicates that the version of TCL you have installed is 8.4 or earlier but you need version 8.5 or later. TCL version 8.5 was released 2008. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] How to detect existing TRANSACTION before performingSAVEPOINT?

2011-03-17 Thread Richard Hipp
y in a transaction. > -- > Igor Tandetnik > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Help me understand the sqlite query optimizer

2011-03-21 Thread Richard Hipp
mance problems. I don't think the OP groks the seriousness of this proverb: "Premature optimization is the root of all evil". -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] "transaction" method of the Tcl bindings to SQLite

2011-03-24 Thread Richard Hipp
___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Full Table Scan after Analyze

2011-03-25 Thread Richard Hipp
requires re-writing of many queries. > > I'm sure there are other good ideas-- I'm flexible, and open to suggestion. > I'd appreciate any suggestions the group might have. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Full Table Scan after Analyze

2011-03-25 Thread Richard Hipp
On Fri, Mar 25, 2011 at 6:30 PM, Simon Slavin wrote: > > On 25 Mar 2011, at 10:18pm, Richard Hipp wrote: > > > Suggestion: After you run ANALYZE, go back and modify values in > > sqlite_stat1 (and sqlite_stat2 if you are using SQLITE_ENABLE_STAT2) with > > "typic

Re: [sqlite] receive signal 7 bus error when heavily read/write in the mode Journal_mode = WAL

2011-03-28 Thread Richard Hipp
::run (this=0x38977008) at syncdb.cpp:123 > #14 0x10005fa0 in Thread::start_thread (arg=0x38977008) at thread.cpp:199 > #15 0x374db5cc in ?? () from /lib/libpthread.so.0 > #16 0x37865b88 in clone () from /lib/libc.so.6 > ___ > sqlite-us

Re: [sqlite] What stack size is required for SQLite to spin?

2011-03-28 Thread Richard Hipp
________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug report: sqlite3_column_name vs. LIKE clause in prepared statements

2011-03-28 Thread Richard Hipp
n"); >return(0); > } > ---/cut--- > > Output: (the SELECT returned two rows) > ---cut--- > Column name (1): 'LOG_MESSAGE' > Column name (2): 'LOG_MESSAGE' > Column name (3): 'Ø$Z' > result: '[...]' > Column name (3): 'Ø$Z' > result: '[...]' > Column name (3): &#x

Re: [sqlite] Extremely large values error

2011-03-29 Thread Richard Hipp
it be considered a bug? The worst part of this error is that one needs > very deep investigation especially for long queries to understand what is > going on. > > Thanks, > > Max > ___ > sqlite-users mailing list > sql

Re: [sqlite] What foolproof strategies for database file non-corruption are there, as regards app and OS crashes (not hardware) when in WAL mode?

2011-03-30 Thread Richard Hipp
o do this? > > Please give your point of view on how to do this the best way - what > strategies/utilities/methods/SQLite parameters and calls are needed to do > this. While I didn't find a clear answer to this in the list archives, I'

Re: [sqlite] WAL checkpoints not working

2011-03-31 Thread Richard Hipp
p://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

2011-04-03 Thread Richard Hipp
Others have responded with requests for information needed to help track down the root of this problem. (Thanks!) But in the meantime, let me just assure you that your subject line is absolutely, positively incorrect. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sql syntax grammar: single-source

2011-04-05 Thread Richard Hipp
language spec, we do not guarantee that we will continue to support it. > > Thanks in advance > Vitali > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/ma

Re: [sqlite] BEGIN DEFERRED TRANSACTION causes core dump in a heavily periodic load with BEGIN EXCLUSIVE/IMMEDIATE TRANSACTION in version 3.7.5

2011-04-05 Thread Richard Hipp
1_01_02232011/isg6000/isg6k/mgmt-crd/linuxapps/hwmon/hwmon.cpp:1993 > #12 0x10025c8c in Thread::start_thread (arg=0x106b28a8) at thread.cpp:199 > #13 0x334265cc in ?? () from /lib/libpthread.so.0 > #14 0x337b0b88 in clone () from /lib/libc.so.6 > Backtrace stopped: previous frame inner to t

Re: [sqlite] substr fails in a query: looks like a bug

2011-04-05 Thread Richard Hipp
f p2.path and p1.path for which the above expression returns false? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: Content filtered message notification

2011-04-06 Thread Richard Hipp
ot, Application Verifier and some profilers such as AQTime can be of help on Windows in tracking down such issues. Consider that a heap corruption is often caused long before the attempt is made to read/write the corrupted location(s). // Oliver -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Bug: SQLite Encryption Extension And Backup API

2011-04-07 Thread Richard Hipp
==SQLITE_OK || rc==SQLITE_BUSY || rc==SQLITE_LOCKED ); > > > > sqlite3_backup_finish(pBackup); > >} > >rc = sqlite3_errcode(pBackupDb); > > } > > > > sqlite3_close(pBackupDb); > > return rc; > > } > > > > Ulric Auger >

Re: [sqlite] Automatic index yields bad performance for a simple join

2011-04-09 Thread Richard Hipp
omatic query instead of creating 9 > temporary automatic indexes? Is this a bug or mis-use? > I can provide the database if necessary. > > PS: Please CC me directly, my corporate firewall does not allow me to > register to the list (port 8080). > > -- > Martin > ___

Re: [sqlite] Automatic index yields bad performance for a simple join

2011-04-09 Thread Richard Hipp
u (maybe > not on the list?). The size is around 7Mb. > > PS: I am now a registered sqlite-user. > PPS: thanks for a great product! Much smaller than Berkeley DB and so much > powerful! > > -- > Martin > -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Effect of using WAL on technical support

2011-04-10 Thread Richard Hipp
> > > > Simon. > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-u

Re: [sqlite] Help with error codes

2011-04-12 Thread Richard Hipp
d error code? > > Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > <330>819.4615 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Richard Hipp
On Tue, Apr 12, 2011 at 5:15 AM, James Green wrote: > My question is does anyone have pointers > to help us isolate the problems we are seeing. > http://www.sqlite.org/howtocorrupt.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-user

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Richard Hipp
rring as a result > > of anti-virus software perhaps? I might expect a higher rate of > > corruption if so. > > > > The only avenue apparently open to us is to use WAL mode. Would WAL + > > sync=normal provide a much better resistance to corruption? We > > (probabl

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Richard Hipp
f not, then that's probably why you're finding the use of 'sync' > to be too slow. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Richard Hipp
to happen at will. All > other test systems operate fine without corruption with sync=OFF. > > James > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-13 Thread Richard Hipp
us isolate the problems we are seeing. We can obviously > provide further detail to your questions. > > Many thanks, > > James > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/li

Re: [sqlite] Corruption on many Windows XP hosts

2011-04-14 Thread Richard Hipp
t right child: 2nd reference to page 92497 > > Page 92110 is never used > > Page 92494 is never used > > Page 92496 is never used > > Page 92499 is never used > > Page 92508 is never used > > Page 92511 is never used > > Page 92512 is never used > > P

Re: [sqlite] sqlite-3.7.6.1 coredump/hang

2011-04-15 Thread Richard Hipp
> /archive/cvs/src/lib/libpthread/pthread_cancelstub.c:424 > #1 0x7f7ff7ffba00 in ?? () > #2 0x in ?? () > > I'm not sure how to get more debugging info :( > > Suggestions where I shall add printfs? :) > Thomas > _

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
> > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
On Sat, Apr 16, 2011 at 5:57 PM, Richard Hipp wrote: > > > On Sat, Apr 16, 2011 at 5:35 PM, Kenneth Ballard < > kball...@kennethballard.com> wrote: > >> Good afternoon, >> >> Here is an issue I started to experience after upgrading from SQLite >> 3

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-16 Thread Richard Hipp
xes to the table > > definitions. But even adding additional indexes didn't help the > > performance of this trigger running as a trigger. > > > > So this begs the question: what changed? > > > > ___ > > sqlite-users mail

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-20 Thread Richard Hipp
l, but the trigger > simplifies the application code a little. Let me know if you have any luck > reproducing the issue. > > Kenneth > > > On 4/16/2011 8:09 PM, Richard Hipp wrote: > >> On Sat, Apr 16, 2011 at 6:29 PM, Kenneth Ballard< >> kball...@kennethballard.c

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA

2011-04-20 Thread Richard Hipp
windows DLL and a new build of the website has been uploaded. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation clarification

2011-04-20 Thread Richard Hipp
; > -- > Dennis Cote > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-20 Thread Richard Hipp
to the table > definitions. But even adding additional indexes didn't help the > performance of this trigger running as a trigger. > > So this begs the question: what changed? > > _______ >

Re: [sqlite] How to handle SQLITE_MISUSE in Android ?

2011-04-20 Thread Richard Hipp
> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A real newbie question: why brackets?

2011-04-20 Thread Richard Hipp
MS Sql Server. SQLite also supports grave-accent quoting: `Album` for compatibility with MySQL. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Richard Hipp
h to the maximum stack size. But if you run lots of maximum-length SQL statements with deeply nested expressions using very short (one-character) constants and column names, measure your maximum stack usage, then apply a 2x or 3x safety factor, you should be fine. > > Many thanks, > Mikae

Re: [sqlite] What stack size is required for SQLite to spin?

2011-04-22 Thread Richard Hipp
to > several megabytes, does not imply use of more stack space? > > Many thanks, > Mikael > > 2011/4/22 Richard Hipp > > The SQL parser and code generator are recursive. So given arbitrarily > > complex SQL, one can use arbitrarily much stack space. > > If you

Re: [sqlite] Segmentation fault when using triggers inside Freeswitch

2011-04-26 Thread Richard Hipp
> ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

2011-05-03 Thread Richard Hipp
(char > *)sqlite3_column_text(compiledStatement, 1)], > [NSString stringWithUTF8String:(char > *)sqlite3_column_text(compiledStatement, 2)]]; > } > sqlite3_finalize(compiledStatement); // release it... > sq

Re: [sqlite] Compiler Error

2011-05-03 Thread Richard Hipp
ITE_OMIT_TRIGGER, and (4) type "make sqlite3.c" > > Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > <330>819.4615 > ___ > sqlite-users mailing l

Re: [sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

2011-05-04 Thread Richard Hipp
> > This is an iPhone app, using XCode 4 for the build... > > Regards, > Rolf > > > > > > On 5/3/11 6:52 AM, Richard Hipp wrote: > > On Tue, May 3, 2011 at 9:46 AM, Rolf Marsh >wrote: > > > >> Here is my code, written in Obj-C. I can

Re: [sqlite] Backing up online SQLite data files

2011-05-06 Thread Richard Hipp
the data that is in the database is > not corrupted. > > Jaco > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Compile error's on Visual Studio 2010

2011-05-08 Thread Richard Hipp
his without lowering the compiler's > warning level? > No. See http://www.sqlite.org/testing.html#staticanalysis for additional information. > > > > Jan > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

2011-05-08 Thread Richard Hipp
have exactly this version of sqlite. > > > > > > > tom@linux1:~$ sqlite3 --version > > 3.6.16 > > tom@linux1:~$ sqlite3 > > SQLite version 3.6.16 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> select date('2011-04-29', quote(-3) || 'day'); > > 2011-04-26 > > sqlite> > > > > > > -- > thomas > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iOS Mem Alloc Issue - sqlite3_extended_errcode

2011-05-09 Thread Richard Hipp
___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] mutex assert_fail in sqlite3BtreeHoldsMutex in a heavily load DB access in 3.5.7 but not in 3.6.22

2011-05-10 Thread Richard Hipp
RomCLI/Sources/RcParse.c:606 > #13 0x101be784 in RcFiniteStateMachine (theConnectionPtr=0x11681900) >at ./RomCLI/Sources/RcCmdLin.c:913 > #14 0x101c5c44 in HandleConnectionTask (theConnectionPtr= out>) >at ./Engine/Sources/AsMain.c:1861 > #15 AllegroMainTask (theT

Re: [sqlite] fts virtual table questions

2011-05-12 Thread Richard Hipp
docs > on sqlite fts don't have much practical everyday usage information. > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] valgrind & WAL w/3.7.6.2

2011-05-13 Thread Richard Hipp
_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] valgrind & WAL w/3.7.6.2

2011-05-13 Thread Richard Hipp
On Fri, May 13, 2011 at 2:49 PM, Richard Hipp wrote: > > > On Fri, May 13, 2011 at 2:42 PM, Steven Parkes wrote: > >> I'm getting conditional branch warnings from valgrind that all percolate >> up via a WAL path. Anybody know if these are known & benign?

Re: [sqlite] FTS & sqlite3_last_insert_rowid

2011-05-13 Thread Richard Hipp
ww.sqlite.org/src/info/e569f18b98) and let me know if it works any better for you. > > I'd prefer not to manually mange them but ... > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] valgrind & WAL w/3.7.6.2

2011-05-13 Thread Richard Hipp
Upgrading zlib to the latest release (1.2.5) fixed all of my valgrind warnings in Fossil, including those that appeared to have been coming from SQLite WAL. On Fri, May 13, 2011 at 3:11 PM, Richard Hipp wrote: > > > On Fri, May 13, 2011 at 2:49 PM, Richard Hipp wrote: > >> &g

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Richard Hipp
believe this a real issue. > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing lis

Re: [sqlite] two threads in the same process accesssing the same DB will cause mutex assert_fail in 3.7.5

2011-05-16 Thread Richard Hipp
___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling in Xcode 3.1.3

2011-05-16 Thread Richard Hipp
_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling in Xcode 3.1.3

2011-05-16 Thread Richard Hipp
e Objective-C. > > R, > John > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto: > sqlite-users-boun...@sqlite.org] > > On Behalf Of Richard Hipp > > Sent: Monday, May 16, 2011 3:19 PM > > To: General Discussion of SQLite Data

Re: [sqlite] Bug or not: WAL file is not auto-checkpointed when transaction finishes

2011-05-18 Thread Richard Hipp
aus > > -- > »Time flies like an arrow, fruit flies like a Banana.« > > PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C > > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080

Re: [sqlite] Auto-checkpoint when read transaction finishes? (was: Bug or not: WAL file is not auto-checkpointed when transaction finishes)

2011-05-18 Thread Richard Hipp
On Wed, May 18, 2011 at 11:06 AM, Nikolaus Rath wrote: > > So considering this as feature request: do you have any thoughts on > making SQLite consider auto-checkpointing when a read transaction > finishes? > There might be performance implications. But we'll look into i

Re: [sqlite] How to build SQLite3 docs?

2011-05-18 Thread Richard Hipp
; be? > > Nico > -- > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] About Fossil usage

2011-05-18 Thread Richard Hipp
from if you have never synced before. > > These are minor issues, IMO. I expected Fossil to be painful (most > VCSes are), but aside from the above it's actually a pleasure. > Thanks, > > Nico > -- > ___ > sqlite-users

Re: [sqlite] OSX building in xcode leading to crashing lib.

2011-05-19 Thread Richard Hipp
> #12 0x025d0835 in sqlite3_exec at sqlite3.c:86281 > #13 0x0256fefe in ZoSqliteDb::RunSql at ZoSqliteDb.cpp:155 > > Any ideas? > > I have has apple specific locking issues when I tried older builds of > SQLlite also. > Like other use

Re: [sqlite] Fossil bugs?

2011-05-19 Thread Richard Hipp
NFS-mounted home directory? Something else out of the ordinary? > > I will try a newer version of Fossil. > > Nico > -- > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d..

Re: [sqlite] Fossil bugs?

2011-05-19 Thread Richard Hipp
On Thu, May 19, 2011 at 1:23 PM, Nico Williams wrote: > On Thu, May 19, 2011 at 12:01 PM, Richard Hipp wrote: > > Anythings possible. But we've been using Fossil heavily, daily, for 4 > years > > now without any hints of these kinds of problems. So fundamental bugs >

Re: [sqlite] Fossil bugs?

2011-05-19 Thread Richard Hipp
On Thu, May 19, 2011 at 1:40 PM, Nico Williams wrote: > On Thu, May 19, 2011 at 12:37 PM, Richard Hipp wrote: > > On Thu, May 19, 2011 at 1:23 PM, Nico Williams >wrote: > > Everything is protected by multiple cryptographic hashes, both SHA1 and > > MD5. On-the-

Re: [sqlite] apple-osx branch

2011-05-19 Thread Richard Hipp
so presumably the apple-osx branch is tested just as carefully. But you'll have to seek confirmation of that from them. > > Thanks, > > James > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sql

Re: [sqlite] Question: Performing Arithmetic Operations on Date Fields

2011-05-19 Thread Richard Hipp
rting it > back. To-date my attempts have been unsuccessful. > > Hoping someone can help. > > Tony > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help sqlite database corruption

2011-05-24 Thread Richard Hipp
l#how_to_corrupt http://www.sqlite.org/atomiccommit.html#sect_9_0 2. Using Sqlite version 3.5.6 > SQLite version 3.7.6.3 is faster and has fewer bugs. Recommend that you upgrade. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqli

Re: [sqlite] SEE encryption lib and odbc

2011-05-24 Thread Richard Hipp
; IT Business Devl Manager > Software XP LLP > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-

Re: [sqlite] [BUG] Silent change in intergeral overflow handling in 3.7.6

2011-05-25 Thread Richard Hipp
at you expect, unfortunately. > > I used the first, because it is more readable to me (while the later is > exact > alternative to the bitwise not, it's not common knowledge, because other > languages do have bitwise not). But it stopped working in 3.7.6 (the later > still doe

Re: [sqlite] Can't clone SQLite repository

2018-06-09 Thread Richard Hipp
On 6/9/18, Brian Nguyen wrote: > Lately it seems that I can't clone the official SQLite repository Permissions adjusted. Please try again. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

2018-06-11 Thread Richard Hipp
e only compile time option is -DSQLITE_ENABLE_COLUMN_METADATA > > Ref: > https://github.com/astlinux-project/astlinux/blob/master/package/sqlite/sqlite.mk > > I have looked as Richard's thread "[sqlite] Size of the SQLite library > Richard Hipp", but this seems much mor

Re: [sqlite] Checking for errors in sqlite3_column_*

2018-06-11 Thread Richard Hipp
potentially odd that many other > threads got replies but this didn’t. I clearly need to update the documentation. It is on my to-do list. That will be a big project. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

2018-06-11 Thread Richard Hipp
onfigure to turn off those two features. You ought to be able to do "./configure --disable-fts5 --disable-json1" but those two --disable options appear to be broken in the ./configure script. -- D. Richard Hipp d...@sqlite.org ___ sqlite-u

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

2018-06-11 Thread Richard Hipp
On 6/11/18, Richard Hipp wrote: > On 6/11/18, Lonnie Abelbeck wrote: >> >> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in >> library >> file size? >> > > See Dan's follow-up. Beginning with 3.24.0, the FTS5 and JSON1 > exten

Re: [sqlite] 3.24.0 is 20% larger than 3.23.1

2018-06-11 Thread Richard Hipp
On 6/11/18, Lonnie Abelbeck wrote: > >> On Jun 11, 2018, at 7:23 AM, Richard Hipp wrote: >> >> On 6/11/18, Lonnie Abelbeck wrote: >>> >>> What changed for 3.23.1 -> 3.24.0 to cause such a large increase in >>> library >>> file size

Re: [sqlite] Possible Input Parser Issue Inf How to convert SQL file into database when a column value is Inf?

2018-06-12 Thread Richard Hipp
On 6/12/18, Keith Medcalf wrote: > > The tip of trunk also does not parse "Inf" or "-Inf" floating point values Maybe use 1e999 and -1e999 instead? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-use

[sqlite] Mailing list shutting down...

2018-06-13 Thread Richard Hipp
r the same individual, apparently to harass them. I have already suspended new subscriptions. Existing subscribers will be able to continue using this list until I come up with a replacement (or a fix to the current problem) but no new subscribers will be accepted. -- D. Richard Hipp d...@

Re: [sqlite] Mailing list shutting down...

2018-06-13 Thread Richard Hipp
On 6/13/18, Tim Streater wrote: > Personally I'd be loath to see this list moved to a web page, for > instance. We invite you to submit working code that implements your desired solution. :-) -- D. Richard Hipp d...@sqlite.org ___ s

Re: [sqlite] Mailing list shutting down...

2018-06-13 Thread Richard Hipp
olves a different problem from the one we are having. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

<    1   2   3   4   5   6   7   8   9   10   >