3737477 - Text search on CDS view dumps due to contains on string column without fuzzy index or missing searchmode=text

• Text search on a CDS view element annotated with @Search.defaultSearchElement: true causes a runtime dump.
• Error: "feature not supported: CONTAINS predicates on LOB or BINARY column without fuzzy search index".
• Error: "SQL code: 2048 ... column store error: search table error: [2018] A received argument has an invalid value; Option 'searchMode=text' is mandatory on NCLOB columns with fuzzy search text index".
• The generated WHERE clause uses CONTAINS on a string/NCLOB column but lacks the required searchMode=text parameter, resulting in a database error when a text index exists.

SAP BTP ABAP environment

cds search, contains, fuzzy search index, nclob, string column, searchMode=text, sql 2048, error 2018, sadl, @Search.defaultSearchElement, @Search.textIndex.required, fulltext, text index, dump, abap environment , KBA , BC-ESI-ESF-BSA , Business Service Adaptation , Problem