Oracle DBMS_LOB.SUBSTR() is being called in a wrong way.

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 Alpha 1
• Fix Version/s: 7.0.0 Alpha 2
• Component/s: Environments, Environments > Databases
• Labels:
  • backend_test
• Story Points: 15
• Fix Priority: 3
• Git Pull Request: https://github.com/shuyangzhou/liferay-portal/pull/1870

LPS-56674 introduced the CLOB_CAST_TEXT pseudo function to avoid oracle issues like ORA-00932.

The SQLTransformer, for Oracle databases, substitutes this pseudo function for DBMS_LOB.SUBSTR($1, 1, 4000)

According to the oracle documentation, the function takes 3 args:

• lob_loc
• amount
• offset

We are calling this function DBMS_LOB.SUBSTR($1, 1, 4000) so:

• lob_loc = LOB field to compute the sub string
• amount = 1
• offset = 4000

So we are getting the 4001th character, which seems not we'd like to get