GENERATED ALWYAS - TEXT data type not allowed?

[former_member369164]

Hi,

I'm getting an error when I try to create a TEXT column based on another column in the table:

CREATE COLUMN TABLE TBL1

(

    COL1 TEXT,

    COL2 TEXT GENERATED ALWAYS AS COL1

);

Could not execute 'CREATE COLUMN TABLE TBL1 ( COL1 TEXT, COL2 TEXT GENERATED ALWAYS AS COL1 )' in 21 ms 848 µs .

SAP DBTech JDBC: [264]: invalid datatype: unsupported column type definition or expression

Are there any set of data types that are not supported?

I tried running this through an ALTER TABLE statement as well but got the same error (as expected).

Thanks,

Varun Vemala

[lbreddemann · Accepted solution]

Correct - as the documentation explains (Data Types - SAP HANA SQL and System Views Reference - SAP Library) TEXT is a rather special data type for character based data.

- Lars