You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Michael Dick (JIRA)" <ji...@apache.org> on 2010/10/19 19:58:26 UTC

[jira] Updated: (OPENJPA-1841) Allow DBDictionary to optimize IS [NOT] NULL SQL for specific data types.

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

Michael Dick updated OPENJPA-1841:
----------------------------------

    Description: 
Some databases do not support IS [NOT] NULL on all datatypes. 

For example Sybase does not allow it's clob / blob types (TEXT and IMAGE respectively) to be used with the IS NULL and IS NOT NULL clauses. The datalength() function to determine if the column has any data instead of the generic IS [NOT] NULL clause. 

Oracle has a similar restriction with BLOB / CLOB types. 

  was:
Sybase does not allow it's clob / blob types (TEXT and IMAGE respectively) to be used with the IS NULL and IS NOT NULL clauses. 

Instead we should use the datalength() function to determine if the column has any data. 

     Issue Type: Improvement  (was: Bug)
        Summary: Allow DBDictionary to optimize IS [NOT] NULL SQL for specific data types.  (was: Do not generate IS NULL and IS NOT NULL clause for blob / clob types on Sybase)

> Allow DBDictionary to optimize IS [NOT] NULL SQL for specific data types.
> -------------------------------------------------------------------------
>
>                 Key: OPENJPA-1841
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1841
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: jdbc
>    Affects Versions: 2.1.0
>            Reporter: Michael Dick
>            Assignee: Michael Dick
>             Fix For: 2.1.0
>
>
> Some databases do not support IS [NOT] NULL on all datatypes. 
> For example Sybase does not allow it's clob / blob types (TEXT and IMAGE respectively) to be used with the IS NULL and IS NOT NULL clauses. The datalength() function to determine if the column has any data instead of the generic IS [NOT] NULL clause. 
> Oracle has a similar restriction with BLOB / CLOB types. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.