|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Table and fields names case-sensitive | ||
|---|---|---|---|
| Product: | Base | Reporter: | pmelchiobe <pmelchiobe> |
| Component: | code | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | OOo 2.2.1 | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | Windows XP | ||
| Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
Issue 80342 looks same/similar problem? allowing different cases is a feature, not a bug. HSQL automatically upper-cases all identifiers it finds, unless you quote them, which you can do with quote = connection.MetaData.IdentifierQuoteString "SELECT * FROM " + quote + "table" + quote => send further to the requirements team reopen issue set to 'new' |
OoBase allows the ceation of table names that are case sensitive. If a table is named with a non-uppercase name; SQL sentences do not find the table. In OoBasic, if you try to run the macro below, you will get an error message "Table not found" databasecontext = createUnoService("com.sun.star.sdb.DatabaseContext") datasource = databaseContext.GetByname("demo_db") connection = datasource.GetConnection("","") statement = Connection.createStatement() resultSet = Statement.executeQuery("SELECT Field1, Field2 FROM Table1") If you try to connect to the Db from an SQL tool (like hsqldb.jar or JDBStudio), you will see the table definition. But a "select * from table1" will get the same error. For compatibility purposes, tables and fields should be uppercase only?