[GitHub] [cloudstack] weizhouapache commented on issue #3934: Zones are returned in a random order

[GitBox <gi...@apache.org>]

weizhouapache commented on issue #3934:
URL: https://github.com/apache/cloudstack/issues/3934#issuecomment-721731075


   @resmo this workaround should work for you.
   
   ```
   UPDATE `cloud`.`data_center` SET `sort_key` = `id` WHERE `sort_key` = 0;
   ```
   this change will break the ordering of zones if users set sort_key to a non-zero value and use sort_key to order zones. so I will not sure if we can merge this change into 4.14.1.0 or 4.15.0.0
   
   this issue might exists with template, disk offering, service offering, network offering as well.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org