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 Sat, 07 Apr 2007 06:24:13 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

------------------------------------------------------------------------------
  
  h)Add tests to set the collation attribute on the jbdc url and testing it later with VALUES
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.database.collation') Some possible tests are
  
- i)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it'; //no collaiton attribute
but is should get set to UCS_BASIC.
+ h1)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it'; //no collaiton attribute
but is should get set to UCS_BASIC.
  
- ii)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=UCS_BASIC';
+ h2)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=UCS_BASIC';
  
- iii)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED';
+ h3)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED';
  
- iv)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=CUSTOM_COLLATION';
//invalid value for collation attribute
+ h4)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=CUSTOM_COLLATION';
//invalid value for collation attribute
  
- v)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED;collation=TERRITORY_BASED';//give
same value twice
+ h5)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED;collation=TERRITORY_BASED';//give
same value twice
  
- vi)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED;collation=UCS_BASIC';//give
2 different values. The last value should get picked
+ h6)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED;collation=UCS_BASIC';//give
2 different values. The last value should get picked
  
- vii)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=UCS_BASIC;collation=TERRITORY_BASED';//same
as vi but valid values in different order
+ h7)connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=UCS_BASIC;collation=TERRITORY_BASED';//same
as vi but valid values in different order
  
- viii)After database create time, try to give collation attribute again. It should get quitely
ignored.
+ h8)After database create time, try to give collation attribute again. It should get quitely
ignored.
  connect 'jdbc:derby:c:/dellater/db1;create=true;territory=it;collation=TERRITORY_BASED';
  connect 'jdbc:derby:c:/dellater/db1;collation=UCS_BASIC';
  
- ix)connect 'jdbc:derby:c:/dellater/db1;create=true;collation=TERRITORY_BASED';//give collation
attribute w/o the locale attribute. We might need to discuss this to decide what happens.
Will put it under outstanding items.
+ h9)connect 'jdbc:derby:c:/dellater/db1;create=true;collation=TERRITORY_BASED';//give collation
attribute w/o the locale attribute. We might need to discuss this to decide what happens.
Will put it under outstanding items.
  
- x)Connect to a pre-10.3 database in soft upgrade mode
+ h10)Connect to a pre-10.3 database in soft upgrade mode
  connect 'jdbc:derby:c:/dellater/db102';
  
- xi)Upgrade a pre-10.3 database
+ h11)Upgrade a pre-10.3 database
  connect 'jdbc:derby:c:/dellater/db102;upgrade=true';
  
+ i)When adding tests for ALTER TABLE, try both add character column AND increase the length
of an existing character column.
  
  '''[[GetText(Metadata query changes)]]'''
  

Mime
View raw message