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
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.