db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: [jira] Updated: (DERBY-1862) Simple hash improves performance
Date Mon, 18 Sep 2006 16:24:41 GMT
Øystein Grøvlen <Oystein.Grovlen@Sun.COM> writes:

> Andreas Korneliussen (JIRA) wrote:
>> String.toUpperCase(..) with english locale, should return a string
>> with the same number of characters, and it should therefore be valid
>> to do a check of number of characters before doing any conversions.
> Is it correct to always use English locale in this case?  Ref the
> reference guide on SQL identifiers:

And is it correct to upcase the identifiers before comparing them in

  ResultSet rs = stmt.executeQuery("select \"x\", x from t");
  int smallX = rs.getInt("x"); // which x is this?
  int bigX = rs.getInt("X");   // and this?

In derby both smallX and bigX get the value of column 1, whereas I
would expect them to get the values from column 1 and 2,
respectively. I haven't checked what the spec says.

Knut Anders

View raw message