You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Jim Ivers (JIRA)" <ji...@apache.org> on 2008/09/12 22:47:44 UTC
[jira] Commented: (DDLUTILS-192) Model exception thrown when index
references an undefined column
[ https://issues.apache.org/jira/browse/DDLUTILS-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12630680#action_12630680 ]
Jim Ivers commented on DDLUTILS-192:
------------------------------------
I noticed while using Sybase that indexes created by dbo were OK, but user created indexes on user created tables were not:
create nonclustered index someuser.idex1 on someuser.sometable ( somecolumn ) with max_rows_per_page = 74 on 'default'
Could not read the schema from the specified database: The index idex1 in table sometable references the undefined column somecolumn
> Model exception thrown when index references an undefined column
> ----------------------------------------------------------------
>
> Key: DDLUTILS-192
> URL: https://issues.apache.org/jira/browse/DDLUTILS-192
> Project: DdlUtils
> Issue Type: Bug
> Components: Core (No specific database)
> Affects Versions: 1.0
> Reporter: Sebastian Niezgoda
> Assignee: Thomas Dudziak
> Attachments: Table.java
>
>
> org.apache.ddlutils.model.ModelException: The index in table references the undefined column is thrown when referencing a column that exists but is referenced in Postgres incorrectly.
> Column type exists in a table. In an index, however, type is stored as "type". The quotes ("") disallow Java from finding the column.
> The fix is simple:
> add name = name.replace("\"", ""); to the very top of findColumn(String name, boolean caseSensitive) in org.apache.ddlutils.model.Table
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.