[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.

     [ 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.

    [ 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.

    [ 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.

    [ 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.