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/18 23:44:27 UTC

[jira] Created: (OPENJPA-1841) Do not generate IS NULL and IS NOT NULL clause for blob / clob types on Sybase

Do not generate IS NULL and IS NOT NULL clause for blob / clob types on Sybase
------------------------------------------------------------------------------

                 Key: OPENJPA-1841
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1841
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 2.1.0
            Reporter: Michael Dick
            Assignee: Michael Dick
             Fix For: 2.1.0


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. 

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

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

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.

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

Michael Dick closed OPENJPA-1841.
---------------------------------

    Resolution: Fixed

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

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

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.

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