HUE-7402 [core] Truncate SEARCH Column in Document2 for Oracle database

Review Request #11692 — Created Oct. 2, 2017 and submitted — Latest diff uploaded

yingc
hue
master
HUE-7402
hue
enricoberti, jgauthier, johan, krish, romain, weixia
commit 41746e058ab63eb10dbf64260be601dd301f91e2
Author: Ying Chen <yingchen@cloudera.com>
Date:   Mon Oct 2 14:25:29 2017 -0700

    HUE-7402 [core] Truncate SEARCH Column in Document2 for Oracle database
    
      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.

:000000 100644 0000000000... 593a415514... A    desktop/core/src/desktop/migrations/0027_truncate_documents.py
:100644 100644 aef7652dfe... 99e586238c... M    desktop/core/src/desktop/models.py
:100644 100644 dac1a9aa8c... 2dafdd9e2a... M    desktop/core/src/desktop/settings.py


Loading...