db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-212) Support for indexes that use functions
Date Thu, 26 Jun 2008 02:32:45 GMT

    [ https://issues.apache.org/jira/browse/DDLUTILS-212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12608253#action_12608253
] 

Thomas Dudziak commented on DDLUTILS-212:
-----------------------------------------

Your particular problem requires DdlUtils to understand functions and to be able to read and
recreate them across all databases that support them, which is not a simple thing to implement.
One workaround would be to give DdlUtils the ability to execute arbitrary SQL at a given step
in the creation or alteration of a database (DDLUTILS-213).
For now, unfortunately you'll have to create the indexes manually (e.g. use the sql task in
Ant) as DdlUtils has no way of doing so.

> Support for indexes that use functions
> --------------------------------------
>
>                 Key: DDLUTILS-212
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-212
>             Project: DdlUtils
>          Issue Type: New Feature
>          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.


Mime
View raw message