[sqlite] 3.7.3 -> 3.7.8 changes

I just upgraded SQLITE to 3.7.8 from 3.7.3. I have found queries I was previously doing have become extremely slow, and wondered if its a problem with my understanding of SQL or a bug in the QUERY PLAN in newer versions: I wouldn't expect query times to change from 100ms to several minutes due t

[sqlite] Difference between FUNCTION(X)>='Y' and FUNCTION(X)>=FUNCTION('Y')

I have a situation where I get different results for this: select ... where FUNCTION(X)>='Y' vs select ... where FUNCTION(X)>=FUNCTION('Y') And FUNCTION('Y') == 'Y' so I thought there should be no difference between the two queries. For some reason in the latter case it behaves as: select

Re: [sqlite] Difference between FUNCTION(X)>='Y' and FUNCTION(X)>=FUNCTION('Y')

Thanks for the tip for doing hex() on the results. My function wasn't returning what I expected due to sqlite3_result_text16 taking bytes not characters. it now works fine. Soundfaction wrote: > > I have a situation where I get different results for this: > > select ...