Re: [sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

Thanks for your help. On 6/16/10 8:11 AM, "Pavel Ivanov" wrote: > Is this working as designed and the 3.0.8 behavior was incorrect? Or is this > a valid bug? I'm not developer of SQLite and don't know what did they intend to do. But applying common sense I'd say that

Re: [sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

On Tue, Jun 15, 2010 at 03:46:17PM -0700, Jeff Webb scratched on the wall: > Is this working as designed and the 3.0.8 behavior was incorrect? It sounds like it. Collations are typically not "promoted" through operations. Having one promoted from a function parameter to the result seems

Re: [sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

> Is this working as designed and the 3.0.8 behavior was incorrect?  Or is this > a valid bug? I'm not developer of SQLite and don't know what did they intend to do. But applying common sense I'd say that behavior of 3.0.8 was incorrect and it's fixed in 3.6.23. To get the same result as you

[sqlite] Sqlite 3.6.23 string functions do not follow case sensitivity in comparions

I scanned through the bug list on the website and didn't see one that was related to this, so please forgive me if this has already been answered. We have created a function that takes a string and returns a substring that is split on a given character (I'll provide the source below), called