[
https://issues.apache.org/jira/browse/DDLUTILS-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12567100#action_12567100
]
Sebastian Niezgoda commented on DDLUTILS-192:
---------------------------------------------
Sure. We have a DDL we create the DB from. The relevant line reads:
Create index idx on table using btree (data_id,type);
Here's an export of that index from Squirrel SQL:
index_qualifier,index_name,ordinal_position,column_name,asc_or_desc,non_unique,type,cardinality,pages,filter_condition
<Other>,idx,2,"type",<Other>,true,3,0,1,<Other>
Notice the "" around type.
> 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.
