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
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
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 ...
3 matches
Mail list logo