openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Closed: (OPENJPA-269) Informix doesn't support subselects or using table aliases in a delete statement.
Date Mon, 24 Sep 2007 15:59:50 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Michael Dick closed OPENJPA-269.
--------------------------------


> Informix doesn't support subselects or using table aliases in a delete statement. 
> ----------------------------------------------------------------------------------
>
>                 Key: OPENJPA-269
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-269
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>             Fix For: 1.0.0
>
>
> Informix doesn't support using table aliases in a delete statement if you have an index
on the table.  For example if we issue the SQL statement : 
> "delete from quoteejb t0" a Syntax error will be thrown by the Informix JDBC driver.
Whereas "delete from quoteejb" would work. 
> This problem seems to be fixed by setting allowAliasInBulkClause to false in InformixDBDictionary.
Another possibility is to check whether there is an index on the table, if no index is present
we should be able to use the alias. I haven't verified whether that approach works though.

> A second problem occurred when we tried to issue the following statement : 
> DELETE FROM holdingejb WHERE holdingID IN (SELECT DISTINCT t0.holdingID FROM holdingejb
t0 WHERE (t0.ACCOUNT_ACCOUNTID IS NULL))
> The second problem was resolved by setting supportsSubselect to false in InformixDBDictionary.

> In the current implementation when supportsSubselect is false we never check allowAliasInBulkClause
so the first change might not be necessary. If the implementation changes we might run into
the problem again, so I'd prefer to change both variables.

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