Issue 81735 - Table and fields names case-sensitive
Summary: Table and fields names case-sensitive
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-19 10:28 UTC by pmelchiobe
Modified: 2013-02-07 22:42 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description pmelchiobe 2007-09-19 10:28:45 UTC
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?
Comment 1 pmelchiobe 2007-09-19 12:37:02 UTC
Issue 80342 looks same/similar problem?
Comment 2 Frank Schönheit 2007-09-20 06:24:06 UTC
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
Comment 3 christoph.lukasiak 2007-10-22 16:23:21 UTC
=> send further to the requirements team
Comment 4 christoph.lukasiak 2007-10-22 16:23:50 UTC
reopen issue
Comment 5 christoph.lukasiak 2007-10-22 16:24:23 UTC
set to 'new'