Right, then for Derby we'd need to add this to the unit tests' connection URI
which create the database:
collation=TERRITORY_BASED:SECONDARY
No idea yet how to do the other databases... needs a little research.
Ari
On 18/05/12 2:31pm, Dzmitry Kazimirchyk wrote:
The problem here is that we need to set underlying db to use case insensitive
collations. The option I've added just tells Cayenne that database is in CI
mode and there is no any special tricks needed to be done from its side to
perform case insensitive queries, etc.
Dima
On 5/18/2012 5:50 AM, Aristedes Maniatis wrote:
Some while ago Dima added code which better handles case insensitive database
collations. I recently added those tests to Jenkins and they are now failing:
Failed tests:
testSelectNotLikeIgnoreCaseSingleWildcardMatch(org.apache.cayenne.query.SelectQueryTest)
testSelectLikeIgnoreCaseObjects1(org.apache.cayenne.query.SelectQueryTest)
https://builds.apache.org/job/Cayenne-trunk/
I haven't done any more investigation, and we could potentially leave this
until after M4 since the feature hasn't yet been promoted.
Ari
--
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
