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 "Sebastian Niezgoda (JIRA)" <ji...@apache.org> on 2008/02/08 16:10:07 UTC
[jira] Created: (DDLUTILS-192) Model exception thrown when index
references an undefined column
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.
[jira] Commented: (DDLUTILS-192) Model exception thrown when index
references an undefined column
Posted by "Sebastian Niezgoda (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DDLUTILS-192) Model exception thrown when index
references an undefined column
Posted by "Jim Ivers (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DDLUTILS-192) Model exception thrown when index
references an undefined column
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12567095#action_12567095 ]
Thomas Dudziak commented on DDLUTILS-192:
-----------------------------------------
How does PostgreSQL reference the column incorrectly ? Could you perhaps post some table creation SQL that leads to this error ?
> 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.
[jira] Updated: (DDLUTILS-192) Model exception thrown when index
references an undefined column
Posted by "Sebastian Niezgoda (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sebastian Niezgoda updated DDLUTILS-192:
----------------------------------------
Attachment: Table.java
Attached is a modified Table.java.
> 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.
[jira] Commented: (DDLUTILS-192) Model exception thrown when index
references an undefined column
Posted by "sunil (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12913927#action_12913927 ]
sunil commented on DDLUTILS-192:
--------------------------------
Dear Thomas Dudziak
Can u send me the ddutils-1.1.jar
please its urgent for me
b'coz i have same problem while configuring symmetricDS2.0.x version
in postgresql 8.0 and 8.2 primary key shows index as ("first column",second)
means column name in ("")
and throws the same exception
waiting for ur reply
> 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.