Uploaded image for project: 'Hue'
  1. Hue
  2. HUE-7402

[core] Truncate SEARCH Column in Document2 for Oracle database

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.2.0
    • Component/s: core.api
    • Labels:
      None

      Description

      Truncate Document2 SEARCH length to 2000

      Searching saved documents in Oracle returns following error:
      DatabaseError: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      This is caused by DBMS_LOB.SUBSTR(%s, 4000) in Django framework django/db/backends/oracle/base.py
      Django has a ticket for this issue but unfixed: https://code.djangoproject.com/ticket/11580.
      Buffer size 4000 limit the length of field equals or less than 2000 characters.

      For performance reasons and to avoid searching in huge fields, we also truncate to a max length 2000

        Attachments

          Activity

            People

            • Assignee:
              yingc Ying Chen
              Reporter:
              yingc Ying Chen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: