Problems using BOOLEAN sql data type in SAP HANA

[Former Member]

Hi all,

I added a column to a column store table in my schema on SAP HANA: I used the following statement

"alter table ztest add (ATTIVO boolean)".

This statement works fine in development system, not the same in quality system where I receive the following error message:

"Could not execute 'alter table ztest add (ATTIVO boolean)'

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "boolean": line 1 col 31 (at pos 31)".

Tables ZTEST are identical in both systems, development and quality.

Please, could you tell me what's the reason for this different behaviour in my systems?

Thanks in advance

[pfefferf · Accepted solution]

Hello Mario,

can it be that your quality system is on a lower SPS level? The boolean type is supported since SPS10. Maybe your development system is already on a SPS >= SPS10 and your quality system on a lower level.

Regards,

Florian

[Former Member · Accepted solution]

Thank you very much Florian: your answer was very helpful