Re: Rows missing in a query using upper() function
Ed Pasma <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
David Hughes wrote: > The attached example shows the problem. It happens in Pysqlite2 > using the form ...where upper(X) in (.......) when X has numeric > values. > > Using ...where upper(X) = .... produces the correct result, as > does everything in a sqlite3.exe command window. > > Am I doing something iffy, or is there a bug here? .. > SQLite version 3.3.6 .. > SQLite version 3.3.5 Hello David, Thanks to your all-inclusive reporting, I saw the difference in the sqlite versions. This must be the reason for the different results. I dare to call it a bug in sqlite 3.3.6 Regards, E Pasma _______________________________________________ pysqlite mailing list pysqlite-IAPFreCvJWPBWskQ1e/[email protected] http://lists.initd.org/mailman/listinfo/pysqlite