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)>='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 ... where FUNCTION(x)>'Y'
>
> This is SQLITE version 3.7.3 as we are still having performance issues
> with 3.7.9
>
> In this specific case FUNCTION(x) just skips some characters at the start
> of the string X and returns an alloc'ed string of the rest. e.g
>
> FUNCTION('RE: this') produces 'this'
>
--
View this message in context:
http://old.nabble.com/Difference-between-FUNCTION%28X%29%3E%3D%27Y%27-and-FUNCTION%28X%29%3E%3DFUNCTION%28%27Y%27%29-tp32875942p32876040.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
