cancel
Showing results for 
Search instead for 
Did you mean: 

GENERATED ALWYAS - TEXT data type not allowed?

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

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

Answers (0)