IgnoreCase problem

[AlexBaranowski]

deal.getInstrument().getName().toLowerCase().equals(instrumentNameLowerCase)
is working greatly
Unfortunately
deal.getInstrument().getName().equalsIgnoreCase(instrumentName) is not working as expected.

Is it possible to map that equaslsIgnoreCase match SQL UPPER (string1) UPPER(string2) or same thing for lower?

[my2iu]

I'm a little hesitant to do that because when you do operations like that on a database, it results in very bad performance since the database needs to scan the entire database to find the result. By not making the equalsIgnoreCase() method available, Jinq encourages people to do something more efficient.

I'll think about it, but since there's a work-around (just use toUpperCase()), I won't prioritize fixing this.

[karolhad]

Why deal.getInstrument().getName().equalsIgnoreCase(instrumentName) is not translated to exactly the same SQL query as deal.getInstrument().getName().toLowerCase().equals(instrumentName.toLowerCase())?

[my2iu]

That's how I would translate it. That's also really, really slow because the database needs to read the whole hard disk of data to execute it. I don't want people to accidentally do that, so that's why I don't want to provide a method for that.

[karolhad]

Ok, understand so maybe a good idea is to add some kind of warning if someone wants to execute methods like toLowerCase() or toUpperCase() on a column. My point is that if someone accidentally writes deal.getInstrument().getName().toLowerCase() DB will need to read all data from disk.