Issue Details (XML | Word | Printable)

Key: DERBY-50
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Satheesh Bandaram
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

getMaxColumnNameLength() database metadata function returns incorrect value.

Created: 26/Oct/04 07:10 PM   Updated: 05/Jun/05 05:44 AM
Return to search
Component/s: JDBC
Affects Version/s: 10.0.2.0
Fix Version/s: 10.0.2.0

Time Tracking:
Not Specified

Environment: Generic issue. Was reproduced on Windows platform.

Resolution Date: 24/Nov/04 12:32 AM


 Description  « Hide
Database Metadata function getMaxColumnNameLength() should return 30. It incorrectly returns 128. Derby restricts maximum column name length to be 30. Similarly, the following metadata functions also return incorrect values:

getMaxCursorNameLength() = 18
getMaxSchemaNameLength() = 30
getMaxProcedureNameLength() = 128
getMaxTableNameLength() = 128
getMaxUserNameLength() = 30

Note, there is some discussion in the derby developper list to increase maximum length of most identifiers to 128. If that happens, these metadata functions will need to be updated again. But for now, it these should return actual limits that are currently enforced.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Shreyas Kaushik added a comment - 19/Nov/04 09:34 AM
It returned the correct value of 30. Has it been already fixed?

Satheesh Bandaram added a comment - 24/Nov/04 12:32 AM
Checked in changes and submitted patch as 55630.

Satheesh Bandaram added a comment - 05/Jun/05 05:44 AM
Patch submitted.