Although this won't help anyone solve the immediate problem immediately,
this issue would be addressed by DERBY-455 (expression indexes).
Regards,
-Rick
Craig L Russell wrote:
If you are concerned about performance, please note that there is a
huge difference between these two statements:
If you are concerned about performance, please note that there is a
huge difference between these two statements:
1. SELECT * FROM CITY_INFO WHERE UPPER(?) = CITY_NAME
and
2. SELECT * FROM CITY_INFO WHERE ? = UPPER(CITY_NAME)
Query 1 will work if your data is already upper case. You can do a
Is there a way to bypass this, so when querying the database it does not
look at uppercases or lowercases. è Detroit = detroit = dEtRoIt = …
Try using the UPPER function:
select * from city_info where UPPER(city_name) = 'DETROIT';
thanks,
bryan
Hello,
could anyone help me with the following problem:
When I do a SELECT query and I search for e.g. “Detroit” but the data in the derby db is “detroit” then the
query has no results.
Is there a way to bypass this, so when querying the
database it does not look at uppercases or l