We have a cloud hosted instance of Appian using MySQL. I've tried to create

steveb over 8 years ago

We have a cloud hosted instance of Appian using MySQL. I've tried to create an index on a table with one of the keys being descending rather than the default of ascending, but it is not working.

The SQL I'm using is

ALTER TABLE `Demand_Notes`
ADD UNIQUE KEY `IX1_Demand_Notes` (`demandId`,`createdDateTime` desc,`noteId`);

Can someone explain what I'm doing wrong.

Discussion posts and replies are publicly visible

0 mayankk718 over 8 years ago

Descending index is not supported in MySQL (till 5.7). Keywords may be given, but they are anyways ignored and only ascending index is supported, which is default.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 steveb over 8 years ago

Thanks for that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mayankk718 over 8 years ago

No problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel