No escaping of object names used in DatabaseMetaData calls

Description

I encountered a bug where GeoTools reported more attributes for an Oracle database table then there were in the table.
I have tables named GDB$G_POZ_40_MPZP_DUKLA_XL_, GDB$G_POZ_40_MPZP_DUKLA_XLI and GDB$G_POZ_40_MPZP_DUKLA_XL0.
For the GDB$G_POZ_40_MPZP_DUKLA_XL_ table GeoTools returned attributes from all 3 tables.

After some investigation I found that when calling DatabaseMetaData.getColumns or getTables schema, table and colum names are passed as exact names whereas the API specifies them as a pattern. Bacause GDB$G_POZ_40_MPZP_DUKLA_XL_ ends with _ which is a placeholder for a single character, all tables matching this pattern were processed and their attributes collected.

Environment

None

Status

Assignee

Unassigned

Reporter

codehaus

Triage

None

Components

Affects versions

Priority

High
Configure