db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stan Bradbury (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2896) DatabaseMetaData.getTables() fails in TERRORITY_BASED collation database with 42818 Comparisions between CHAR and CHAR not allowed.
Date Wed, 11 Jul 2007 04:12:04 GMT

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

Stan Bradbury commented on DERBY-2896:
--------------------------------------

Performed a basic test on a database (toursdb) created with territory=territory=es_MX - a
simple progam that lists tables, exported keys and columns works fine  (DbMD.getTables then
getExportedKeys then getColumns).  This could be a test issue or under a specific configuration.
 Since basic functionality is not impaired I think the priority of this issue can be lowered.
 Attached is a zipfile with the simple test program and toursDB created with es_MX territory
for any one who might find this helpful.

Db build:
ij> connect 'jdbc:derby:work\dbs\toursMx;create=true;territory=es_MX';
ij> run 'ToursDB_schema.sql';
ij> run 'loadCOUNTRIES.sql';
ij>  exit;

%% java  DBMetaData2
Loaded the derby JDBC driver.
Get Tables Results Loop
Got a TABLE named: AIRLINES
 . . Getting Exported Keys
 . . . Getting Columns
 . . . .  Col: AIRLINE - Type: 1 Size: 2
 . . . .  Col: AIRLINE_FULL - Type: 12 Size: 24
 . . . .  Col: BASIC_RATE - Type: 8 Size: 52
 . . . .  Col: DISTANCE_DISCOUNT - Type: 8 Size: 52
 . . . .  Col: BUSINESS_LEVEL_FACTOR - Type: 8 Size: 52
 . . . .  Col: FIRSTCLASS_LEVEL_FACTOR - Type: 8 Size: 52
 . . . .  Col: ECONOMY_SEATS - Type: 4 Size: 10
 . . . .  Col: BUSINESS_SEATS - Type: 4 Size: 10
 . . . .  Col: FIRSTCLASS_SEATS - Type: 4 Size: 10
Got a TABLE named: CITIES
 . . Getting Exported Keys
 . . . Getting Columns
 . . . .  Col: CITY_ID - Type: 4 Size: 10
 . . . .  Col: CITY_NAME - Type: 12 Size: 24
 . . . .  Col: COUNTRY - Type: 12 Size: 26
 . . . .  Col: AIRPORT - Type: 12 Size: 3
 . . . .  Col: LANGUAGE - Type: 12 Size: 16
 . . . .  Col: COUNTRY_ISO_CODE - Type: 1 Size: 2
Got a TABLE named: CIUDAD_DE_MEXICO
 . . Getting Exported Keys
 . . . Getting Columns
 . . . .  Col: NOMBRE - Type: 12 Size: 24
 . . . .  Col: ESTADO - Type: 12 Size: 24
 . . . .  Col: EXCEPCI?N - Type: 4 Size: 10
Got a TABLE named: CIUDAD_DE_MEXICO2
 . . Getting Exported Keys
 . . . Getting Columns
 . . . .  Col: NOMBRE - Type: 12 Size: 24
 . . . .  Col: ESTADO - Type: 12 Size: 24
 . . . .  Col: EXCEPCI?N - Type: 4 Size: 10

 == REST of OUTPUT not included


> DatabaseMetaData.getTables() fails in TERRORITY_BASED collation database with 42818 Comparisions
between CHAR and CHAR not allowed.
> -----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2896
>                 URL: https://issues.apache.org/jira/browse/DERBY-2896
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.3.0.0, 10.3.1.0, 10.4.0.0
>            Reporter: Daniel John Debrunner
>            Priority: Critical
>
> I tried adding DatabaseMetaDataTest.suite() to be run within CollationTest so that it
would test DatabaseMetaData within a collated database.
> I had to fix one item in JDBC.dropSchema() where a string constant was being compared
to a system column while not in a system schema,
> but with that fixed the next error hit was executing DatabaseMetaData.getTables().
> I will add the code to collation test with the use of DatabaseMetaDataTest commented
out with this bug number.

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


Mime
View raw message