Re: Rows missing in a query using upper() function
David Hughes <dfh-SSyVZMUXQxBawGkVQGIbBlpr/1R2p/[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
Ed Pasma wrote:
> ....
>
>> 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
You are right, Ed. Thanks.
I downloaded the latest sqlite3.exe, which is now version 3.3.7, and
that shows the same problem that I see using pysqlite. I will try and
report it to sqlite.org
In my original example with the query:
*select refcode, name from t1 where upper(refcode) in ('1000', '10-10',
'WXYZ')*
the work around seems to be that if a value in the search set can be
converted to an integer or float then do not enclose it in quotes , even
though it is a string.
--
Regards,
David Hughes
_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/pysqlite