Re: [Modeling-users] fetch qualifier problem

[Sebastien B. <sbi...@us...>]

        Hi,

  While making the test suite for all this and roaming around sqlite
source code, I incidentally found an other bug
https://sf.net/tracker/index.php?func=3Ddetail&aid=3D786217&group_id=3D5893=
5&atid=3D489335
      [ 786217 ] Qualifier LIKE can be case-insensitive

  --> When using 'LIKE' in qualifier strings, the match for MySQL and
  SQLite is case-*insensitive*. I did not noticed it, but the fact is
  that sql 'LIKE' operator is by default case-insensitive for these two
  databases.

About SQLite: the fix for the above bug is expected to fix bug #785913:
"LIKE qualifier w/ raw '%' and '_' does not work w/ SQLite" as well. Now
for case insensitive match, sqlite lacks the ability to escape the
special characters --I've submitted a patch to the sqlite ml today,
we'll see what happens,
cf. http://groups.yahoo.com/group/sqlite/message/4605

-- S=E9bastien.


Sebastien Bigaret <sbi...@us...> writes:

> Mario Ruggier <ma...@ru...> writes:
>=20
> > Sorry, I did not mention that this was running on sqlite.
> > The problem here occurs for string values that contain '_'
> > (for '@'. it actually works fine, sorry had it wrong the first time).
>=20
> This is a problem w/ sqlite. The problem happens for '_' and '%', and I
> can't even find out to do this on the sqlite commandline. I've just sent
> the question to the sqlite ml, we'll see then.
>=20
> > Small question: when i try the aove from inside a py program
> > (a unittest testcase test), setting this envvar to 'YES', nothing happe=
ns...
> > or so it seems. Where should i go to get stderr (osx) ?
>=20
>   How do you launch it? By dble-clicking on it? If yes, try to check the
>   console (there's an app named Console somewhere, can't recall where
>   but you'll probably find it).
>=20
> -- S=E9bastien.