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

2011-11-25 Thread Soundfaction
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')

2011-11-25 Thread Simon Davies
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

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

2011-11-25 Thread Soundfaction
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)>=