db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2656) Run suites.All against a collated database
Date Wed, 16 May 2007 23:37:16 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12496438

Kathey Marsden commented on DERBY-2656:

I think ascii is the same as the default except for my favorite norwegian character 'aa' which
is one character and sorts after z in Norway and is two and sorts before z in the default

ij> connect 'jdbc:derby:wombat;create=true;collation=TERRITORY_BASED;territory=no';
WARNING 01J01: Database 'wombat' not created, connection made to existing database instead.
ij> create table t (vc varchar(30));
0 rows inserted/updated/deleted
ij> insert into t values('acorn');
1 row inserted/updated/deleted
ij> insert into t values('aacorn');
1 row inserted/updated/deleted
ij> insert into t values('zebra');
1 row inserted/updated/deleted
ij> select * from t order by vc;

> Run suites.All against a collated database
> ------------------------------------------
>                 Key: DERBY-2656
>                 URL: https://issues.apache.org/jira/browse/DERBY-2656
>             Project: Derby
>          Issue Type: Test
>          Components: Test
>    Affects Versions:
>            Reporter: Kathey Marsden
>         Assigned To: Kathey Marsden
>            Priority: Minor
>             Fix For:
>         Attachments: DERBY-2656_diff.txt
> It would be good to leverage the existing tests to exercise the collation code.  Investigate
running all the tests against a collated database.
> Kathey

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message