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 incorrect. I'm can't offer a definitive answer, however. > > select * from foo where splitstr( value, '@', 1 ) = 'foo'; > 4|f...@bar As a workaround, try: SELECT * FROM foo WHERE splitstr( value, '@', 1 ) COLLATE NOCASE = 'foo'; -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
