Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Message-ID: <810986897.1214232046197.JavaMail.jira@brutus>
Date: Mon, 23 Jun 2008 07:40:46 -0700 (PDT)
From: "prasanna (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Created: (DDLUTILS-212)
 org.apache.ddlutils.model.ModelException: The index in table references the
 undefined column
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

org.apache.ddlutils.model.ModelException: The index in table references the undefined column
--------------------------------------------------------------------------------------------

                 Key: DDLUTILS-212
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-212
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - PostgreSql
    Affects Versions: 1.0
         Environment: RHEL 4 Linux
            Reporter: prasanna
            Assignee: Thomas Dudziak


I created a postgres database and ran this SQL:

/*create LANGUAGE plpgsql;*/
CREATE OR REPLACE  FUNCTION FUNC (/*id*/ INTEGER, /*status*/ INTEGER)
      RETURNS NUMERIC AS'
 BEGIN
   RETURN 0;
 END;

'LANGUAGE plpgsql IMMUTABLE;

create table test_list
 (
 test_list_id integer not null, --pk
 test_id integer not null, --fk
 status_id integer not null --fk
 );

create unique index uq_test_list on test_list(test_list_id, test_id, func(test_list_id, status_id));


When trying to load the database schema in Jasper Server it fails with this exception:

Caused by: org.apache.ddlutils.model.ModelException: The index uq_test_list in table test_list references the undefined column func(test_list_id, status_id)
        at org.apache.ddlutils.model.Database.initialize(Database.java:393)
        at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:484)
        at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
        at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.getMetaData(BaseJdbcMetaDataFactoryImpl.java:82)

I applied the fix mentioned here:
https://issues.apache.org/jira/browse/DDLUTILS-192

Still it fails with the same exception.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.