HUE-7402 [core] Truncate SEARCH Column in Document2 for Oracle database
Review Request #11692 — Created Oct. 2, 2017 and submitted — Latest diff uploaded
Information | |
---|---|
yingc | |
hue | |
master | |
HUE-7402 | |
Reviewers | |
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