db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "BuiltInLanguageBasedOrderingDERBY-1478" by MamtaSatoor
Date Tue, 05 Jun 2007 06:40:52 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by MamtaSatoor:
http://wiki.apache.org/db-derby/BuiltInLanguageBasedOrderingDERBY-1478

------------------------------------------------------------------------------
  
  1)When a character column is added using CREATE TABLE/ALTER TABLE, make sure that the correct
collate type is populated in the TypeDescriptor's scale field in the SYS.SYSCOLUMNS table.
In order to do this, CREATE TABLE/ALTER TABLE need to get their schema descriptor's collation
type. The collation type of the schema descriptor will decide the collation type of the character
columns defined in CREATE TABLE/ALTER TABLE. This comes from item 2 under Collation Determination
section on this page. ALTER TABLE changes should work for both ADD COLUMN and MODIFY character
column increase length. Part of the code changes required for this item has gone in revision
526385 and 526454 as part of DERBY-2530. Some more language changes and some store changes
need to go in for this task to finish. Those changes involve passing the collation type from
language to the store layer as part of CREATE TABLE and ALTER TABLE. Mike is planning to look
into that.
  
- 2)Store needs a way to determine the collation type for a given DVD. This collation type
will then be saved in the column metadata. Provide the api on DVD to return the correct collation
type.
+ 2)Store needs a way to determine the collation type for a given DVD. This collation type
will then be saved in the column metadata. Provide the api on DVD to return the correct collation
type. 
  
  '''[[GetText(Question)]]''' Will there be an api like DVD.getCollationType()?
+ 
+ '''[[GetText(Answer)]]''' Mike, sorry, I forget the requirement for this one. Do we still
have a todo here?
  
  3)Cleanup the new interface DTD.comparable to use isXXX methods rather than looking for
StoredFormatIds. DERBY-2569
  

Mime
View raw message