Re: [sqlite] union-having bug

2011/12/3 Gillman, David : > Is this behavior known?  The third query returns no rows even though bar = 1. > sqlite> select ind, sum(foo) foo, sum(bar) bar from (select 1 ind, 0 foo, 1 > bar union select 1 ind, 1 foo, 0 bar) group by ind having bar > 0; select ind, sum(foo) fooo, sum(bar) barr fr

Re: [sqlite] Most Frequent Occurrence Problem

On Fri, 2 Dec 2011 21:10:54 -0800 (PST), Macgyver7 wrote: > > I am not sure exactly how I am to work in the coalesce function to get the > result, I tried some experiments and I could get the first and or second > fields in another column, but not as part of the bracketed group. > > This is the

Re: [sqlite] WAL file size

Hello Richard, *The prgama PRAGMA journal_size_limit = **N , *does not seem to limit the size of the WAL log file. Is there any precondition to be satisfied before calling the pragma ? -Sreekumar On Wed, Nov 30, 2011 at 7:04 PM, Teg wrote: > Hello Richard, > > When does the WAL get trimmed do

[sqlite] Infinite Loop in MATCH on self written fts3 tokenizer

hi, I have written an fts3 tokenizer which generates all prefixes of the input text. After inserting, "hallo" into an fts4 table, the fts4aux table has entries for "h", "ha", "hal", "hall", and "hallo". If I try to do a "SELECT * FROM table WHERE string MATCH 'hal';", sqlite goes into an infin

Re: [sqlite] Most Frequent Occurrence Problem

I had been trying to learn proper use of the coalesce function via experimenting. After many tries I found that the coalesce function only was working for me with one set of brackets, I think I must have been causing a conflict due to the context of the function. If I introduced more than one se