Issue 52997 - renaming of table via GUI is not case sensitive
Summary: renaming of table via GUI is not case sensitive
Status: CLOSED DUPLICATE of issue 44200
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m122
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-07 15:34 UTC by drewjensen.inbox
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description drewjensen.inbox 2005-08-07 15:34:40 UTC 
When working with the embedded database names of objects are case sensitive.

If you attempt to rename an object changing only the case the GUI tools disallow
it. It appears that the comparison of the old and new names is made case
insensitive.

Example:

Created a table named students, attempted to rename it to STUDENTS. GUI reports
that and object named STUDENTS already exists. However if you execute the SQL
command select * from "STUDENTS" the HSQLDB engine reports that 'Table not found
in statement [SELECT * FROM "STUDENTS"]

I have only tested this on 1.9.122 and WinXP
Comment 1 Frank Schönheit 2005-08-23 13:11:50 UTC 
confirming, targeting, assigning
Comment 2 ocke.janssen 2006-01-02 08:00:50 UTC 
.

*** This issue has been marked as a duplicate of 44200 ***
Comment 3 ocke.janssen 2006-01-02 08:01:33 UTC 
Closing