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
On 25 November 2011 09:53, Soundfaction wrote:
>
> 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 quer
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 ... where FUNCTION(X)>=
3 matches
Mail list logo