Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1841

Allow DBDictionary to optimize IS [NOT] NULL SQL for specific data types.

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: jdbc
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              mikedd Michael Dick
              Reporter:
              mikedd Michael Dick
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: