SAP Knowledge Base Article - Preview

2359486 - Executing a an SQL Statement with string concatenation function against an Attribute View results in an error.

Symptom

Executing a an SQL Statement with string concatenation function against an Attribute View results in an error.

SQL Statement:
select * from "_SYS_BIC"."USER/ATTRIBUTEVIEW" a
WHERE a.FIELD1 in (
SELECT f.FIELD1 || f.FIELD2
FROM "_SYS_BIC"."USER/ATTRIBUTEVIEW" f
);

Error Message:
Could not execute 'select 1 from "_SYS_BIC"."USER/ATTRIBUTEVIEW" a WHERE a.FIELD1 in ( SELECT f.FIELD1 || f.FIELD2 ...' in 17 ms 403 µs .
[129]: transaction rolled back by an internal error: general error (no further information available); $function$=addColumn; $message$=column expected


Read more...

Environment

SAP HANA Platform

Product

SAP HANA 1.0, platform edition

Keywords

KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.