db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tobias Kalbitz (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-138) writeschematofile - Database model fails to find column names of indices with qualifiers (postgres)
Date Tue, 19 Dec 2006 20:41:21 GMT
writeschematofile - Database model fails to find column names of indices with qualifiers (postgres)
---------------------------------------------------------------------------------------------------

                 Key: DDLUTILS-138
                 URL: http://issues.apache.org/jira/browse/DDLUTILS-138
             Project: DdlUtils
          Issue Type: Bug
          Components: Ant Tasks
         Environment: JDK 1.6, Postgresql 8.2, SVN version of DdlUtills
            Reporter: Tobias Kalbitz
         Assigned To: Thomas Dudziak


Example Table:

CREATE TABLE users (
  id BIGSERIAL PRIMARY KEY,
  username VARCHAR(30) NOT NULL UNIQUE
) WITHOUT OIDS;

CREATE INDEX users_username ON users(username);
CREATE INDEX users_username_lower ON users(LOWER(username));

The problem is located on line 390 of the database model.

The first index column (username) will be found by the database model
In the second case indexColumn.getName() returns  "LOWER(username)" which can't be find as
column -> exception 

Workaround for me is to use a substring of the columnname, but this isn't a solution which
is portable across databases.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message