Skip to content

database-compatibility-issues - Add new section Groupby Clob #224

@thekingofspain

Description

@thekingofspain

On page https://github.com/OutSystems/docs-product/blob/master/src/ref/data/database/database-compatibility-issues.md, add a section for:

Grouping on Text Length Above 2000 Characters

Issue
The following error is generated at runtime when grouping on a entity text attribute defined to store more than 2000 characters in an Aggregate action:

[2] ORA-00932: inconsistent datatypes: expected - got CLOB
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)

Note, in ServiceStudio, no such error is generated when using the Test Value tab in the Aggregate screen.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions