To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52997 Issue #:|52997 Summary:|renaming of table via GUI is not case sensitive Component:|Database access Version:|680m122 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Sun Aug 7 07:34:40 -0700 2005 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]