cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Unique Index gets not generated using PD

former_member217396
Participant
0 Kudos

Hi,

I would need to get sure, I'm not doing anything wrong.

We have a simple HANA table with one unique index on it:

Now, we are generating the DDL script for this table... the code for creation of the index gets generated.. but it's not a unique index anymore...

Am I doing something wrong, or is it a bug?

Thanks,

Rafal

Accepted Solutions (1)

Accepted Solutions (1)

former_member185199
Contributor
0 Kudos

Hi Rafal

i dont know if its a bug or a feature

but here is the fix:

Please Backup the file Hanadb10.xdb before doing this quickfix!

go to Database>Edit current dbms

locate to SAPHANA10::Script\Objects\Index\Create

you will see:

.if (%Parent.isCatalogTable%==true)

create[ %INDEXTYPE%] index %INDEX% on [%TABLQUALIFIER%]%TABLE% (%CIDXLIST%)[%DescIndex%? desc]

.endif

in the value window

change it like this:

.if (%Parent.isCatalogTable%==true)

create[ %UNIQUE%][ %INDEXTYPE%] index %INDEX% on [%TABLQUALIFIER%]%TABLE% (%CIDXLIST%)[%DescIndex%? desc]

.endif

Please Backup the file Hanadb10.xdb before doing this quickfix!

HTH

dj

former_member217396
Participant
0 Kudos

Thanks Dirk!

we will report it as a bug ...

Regards,

Rafal

former_member192453
Active Participant
0 Kudos

Hi Rafal,

This issue has already been submitted as a bug on CR 777365 and is scheduled to be fixed in 16.5 SP04 PL03.

Regards,

Anthony

Answers (0)