Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 520991

Summary: Scout needs more milestones
Product: Community Reporter: Matthias Zimmermann <zimmermann>
Component: BugzillaAssignee: Eclipse Webmaster <webmaster>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: denis.roy
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Matthias Zimmermann CLA 2017-08-15 13:29:43 EDT
We (Eclipse Scout) have run out of useful sortkeys for bugzilla milestones. 
It seems that you can not go over 32xxx with the sort key values. 

Could you please investigate how to fix this or propose alternatives?

Tx
Comment 1 Denis Roy CLA 2017-08-16 16:26:55 EDT
You have lots of blanks  :)

MariaDB [bugs]> select * from  milestones where product_id = 174;
+-------------------------+---------+------------+------+----------+
| value                   | sortkey | product_id | id   | isactive |
+-------------------------+---------+------------+------+----------+
| ---                     |       0 |        174 | 4216 |        1 |
| 3.10.0 Luna             |    4000 |        174 | 6603 |        1 |
| 3.10.0 M1               |    4001 |        174 | 6714 |        1 |
| 3.10.0 M2               |    4002 |        174 | 6715 |        1 |
| 3.10.0 M3               |    4003 |        174 | 6716 |        1 |
| 3.10.0 M4               |    4004 |        174 | 6936 |        1 |
| 3.10.0 M5               |    4005 |        174 | 6937 |        1 |
| 3.10.0 M6               |    4006 |        174 | 6938 |        1 |
| 3.10.0 M7               |    4007 |        174 | 7054 |        1 |
| 3.7.0 Indigo            |    1000 |        174 | 5070 |        1 |
| 3.7.1                   |    1100 |        174 | 5071 |        1 |
| 3.7.2                   |    1200 |        174 | 5072 |        1 |
| 3.7.3                   |    1300 |        174 | 5614 |        1 |
| 3.8.0 Juno              |    2000 |        174 | 5176 |        1 |
| 3.8.1                   |    2100 |        174 | 5863 |        1 |
| 3.8.2                   |    2200 |        174 | 6165 |        1 |
| 3.8.3                   |    2300 |        174 | 6366 |        1 |
| 3.9.0 Kepler            |    3000 |        174 | 5864 |        1 |
| 3.9.0 M2                |    3002 |        174 | 6182 |        1 |
| 3.9.0 M3                |    3003 |        174 | 6183 |        1 |
| 3.9.0 M4                |    3004 |        174 | 6184 |        1 |
| 3.9.0 M5                |    3005 |        174 | 6185 |        1 |
| 3.9.0 M6                |    3006 |        174 | 6186 |        1 |
| 3.9.0 M7                |    3007 |        174 | 6187 |        1 |
| 3.9.0 RC1               |    3011 |        174 | 6188 |        1 |
| 3.9.0 RC2               |    3012 |        174 | 6189 |        1 |
| 3.9.0 RC3               |    3013 |        174 | 6190 |        1 |
| 3.9.0 RC4               |    3014 |        174 | 6191 |        1 |
| 3.9.1 RC1               |    3101 |        174 | 6598 |        1 |
| 3.9.1 RC2               |    3102 |        174 | 6764 |        1 |
| 3.9.1 RC3               |    3103 |        174 | 6765 |        1 |
| 3.9.1 RC4               |    3104 |        174 | 6766 |        1 |
| 3.9.2 RC1               |    3201 |        174 | 6607 |        1 |
| 3.9.2 RC2               |    3202 |        174 | 7051 |        1 |
| 3.9.2 RC3               |    3203 |        174 | 7052 |        1 |
| 3.9.2 RC4               |    3204 |        174 | 7053 |        1 |
| 4.0.0 M6                |   10060 |        174 | 7086 |        1 |
| 4.0.0 M7                |   10070 |        174 | 7087 |        1 |
| 4.0.0 RC1               |   10080 |        174 | 7088 |        1 |
| 4.0.0 RC2               |   10090 |        174 | 7089 |        1 |
| 4.0.0 RC3               |   10100 |        174 | 7090 |        1 |
| 4.0.0 RC4               |   10110 |        174 | 7091 |        1 |
| 4.0.100 RC1             |   11010 |        174 | 7345 |        1 |
| 4.0.100 RC2             |   11020 |        174 | 7346 |        1 |
| 4.0.100 RC3             |   11030 |        174 | 7347 |        1 |
| 4.0.100 RC4             |   11040 |        174 | 7348 |        1 |
| 4.0.200 RC1             |   12010 |        174 | 7755 |        1 |
| 4.0.200 RC2             |   12020 |        174 | 7756 |        1 |
| 4.0.200 RC3             |   12030 |        174 | 7757 |        1 |
| 4.0.200 RC4             |   12040 |        174 | 7758 |        1 |
| 4.1.0                   |   11100 |        174 | 7673 |        1 |
| 5.0.0 M1                |   20010 |        174 | 7441 |        1 |
| 5.0.0 M2                |   20020 |        174 | 7442 |        1 |
| 5.0.0 M3                |   20030 |        174 | 7443 |        1 |
| 5.0.0 M4                |   20040 |        174 | 7716 |        1 |
| 5.0.0 M5                |   20050 |        174 | 7717 |        1 |
| 5.0.0 M6                |   20060 |        174 | 7848 |        1 |
| 5.0.0 M7                |   20070 |        174 | 7849 |        1 |
| 5.0.0 Mars              |   20000 |        174 | 7291 |        1 |
| 5.0.0 RC1               |   20110 |        174 | 7850 |        1 |
| 5.0.0 RC2               |   20120 |        174 | 7851 |        1 |
| 5.0.0 RC3               |   20130 |        174 | 7852 |        1 |
| 5.0.0 RC4               |   20140 |        174 | 7853 |        1 |
| 5.0.100 RC1             |   21010 |        174 | 8124 |        1 |
| 5.0.100 RC2             |   21020 |        174 | 8125 |        1 |
| 5.0.100 RC3             |   21030 |        174 | 8126 |        1 |
| 5.0.100 RC4             |   21040 |        174 | 8127 |        1 |
| 5.0.200 RC1             |   22010 |        174 | 8370 |        1 |
| 5.0.200 RC2             |   22020 |        174 | 8371 |        1 |
| 5.0.200 RC3             |   22030 |        174 | 8372 |        1 |
| 5.0.200 RC4             |   22040 |        174 | 8373 |        1 |
| 5.0.300                 |   23000 |        174 | 8580 |        1 |
| 5.1.0                   |   21100 |        174 | 7759 |        1 |
| 6.0.0 M1                |   30010 |        174 | 7938 |        1 |
| 6.0.0 M2                |   30020 |        174 | 8168 |        1 |
| 6.0.0 M3                |   30030 |        174 | 8169 |        1 |
| 6.0.0 M4                |   30040 |        174 | 8170 |        1 |
| 6.0.0 M5                |   30050 |        174 | 8171 |        1 |
| 6.0.0 M6 API Freeze     |   30060 |        174 | 8172 |        1 |
| 6.0.0 M7 Feature Freeze |   30070 |        174 | 8173 |        1 |
| 6.0.100 RC1             |   31010 |        174 | 8893 |        1 |
| 6.0.100 RC2             |   31020 |        174 | 8894 |        1 |
| 6.0.100 RC3             |   31030 |        174 | 8895 |        1 |
| 6.0.100 RC4             |   31040 |        174 | 8896 |        1 |
| 6.0.200 RC1             |   32010 |        174 | 8897 |        1 |
| 7.0.0 M1                |   32767 |        174 | 8898 |        1 |
| 7.0.0 M2                |   32767 |        174 | 8899 |        1 |
| 7.0.0 M3                |   32767 |        174 | 8900 |        1 |
| 7.0.0 M4                |   32767 |        174 | 8901 |        1 |
| 7.0.0 M5                |   32767 |        174 | 8902 |        1 |
+-------------------------+---------+------------+------+----------+

We can simply renumber them with smaller "gaps" so that you can insert new milestones.  WDYT?
Comment 2 Denis Roy CLA 2017-08-16 16:27:22 EDT
Are there any that can be cleaned up?
Comment 3 Denis Roy CLA 2017-08-16 16:36:56 EDT
I've since taken the liberty of condensing your milestones:

MariaDB [bugs]> select * from  milestones where product_id = 174;
+-------------------------+---------+------------+------+----------+
| value                   | sortkey | product_id | id   | isactive |
+-------------------------+---------+------------+------+----------+
| ---                     |       0 |        174 | 4216 |        1 |
| 3.10.0 Luna             |     400 |        174 | 6603 |        1 |
| 3.10.0 M1               |     400 |        174 | 6714 |        1 |
| 3.10.0 M2               |     400 |        174 | 6715 |        1 |
| 3.10.0 M3               |     400 |        174 | 6716 |        1 |
| 3.10.0 M4               |     400 |        174 | 6936 |        1 |
| 3.10.0 M5               |     401 |        174 | 6937 |        1 |
| 3.10.0 M6               |     401 |        174 | 6938 |        1 |
| 3.10.0 M7               |     401 |        174 | 7054 |        1 |
| 3.7.0 Indigo            |       0 |        174 | 5070 |        1 |
| 3.7.1                   |     100 |        174 | 5071 |        1 |
| 3.7.2                   |     200 |        174 | 5072 |        1 |
| 3.7.3                   |     300 |        174 | 5614 |        1 |
| 3.8.0 Juno              |     200 |        174 | 5176 |        1 |
| 3.8.1                   |     210 |        174 | 5863 |        1 |
| 3.8.2                   |     220 |        174 | 6165 |        1 |
| 3.8.3                   |     230 |        174 | 6366 |        1 |
| 3.9.0 Kepler            |     300 |        174 | 5864 |        1 |
| 3.9.0 M2                |     300 |        174 | 6182 |        1 |
| 3.9.0 M3                |     300 |        174 | 6183 |        1 |
| 3.9.0 M4                |     300 |        174 | 6184 |        1 |
| 3.9.0 M5                |     301 |        174 | 6185 |        1 |
| 3.9.0 M6                |     301 |        174 | 6186 |        1 |
| 3.9.0 M7                |     301 |        174 | 6187 |        1 |
| 3.9.0 RC1               |     301 |        174 | 6188 |        1 |
| 3.9.0 RC2               |     301 |        174 | 6189 |        1 |
| 3.9.0 RC3               |     301 |        174 | 6190 |        1 |
| 3.9.0 RC4               |     301 |        174 | 6191 |        1 |
| 3.9.1 RC1               |     310 |        174 | 6598 |        1 |
| 3.9.1 RC2               |     310 |        174 | 6764 |        1 |
| 3.9.1 RC3               |     310 |        174 | 6765 |        1 |
| 3.9.1 RC4               |     310 |        174 | 6766 |        1 |
| 3.9.2 RC1               |     320 |        174 | 6607 |        1 |
| 3.9.2 RC2               |     320 |        174 | 7051 |        1 |
| 3.9.2 RC3               |     320 |        174 | 7052 |        1 |
| 3.9.2 RC4               |     320 |        174 | 7053 |        1 |
| 4.0.0 M6                |    1006 |        174 | 7086 |        1 |
| 4.0.0 M7                |    1007 |        174 | 7087 |        1 |
| 4.0.0 RC1               |    1008 |        174 | 7088 |        1 |
| 4.0.0 RC2               |    1009 |        174 | 7089 |        1 |
| 4.0.0 RC3               |    1010 |        174 | 7090 |        1 |
| 4.0.0 RC4               |    1011 |        174 | 7091 |        1 |
| 4.0.100 RC1             |    1101 |        174 | 7345 |        1 |
| 4.0.100 RC2             |    1102 |        174 | 7346 |        1 |
| 4.0.100 RC3             |    1103 |        174 | 7347 |        1 |
| 4.0.100 RC4             |    1104 |        174 | 7348 |        1 |
| 4.0.200 RC1             |    1201 |        174 | 7755 |        1 |
| 4.0.200 RC2             |    1202 |        174 | 7756 |        1 |
| 4.0.200 RC3             |    1203 |        174 | 7757 |        1 |
| 4.0.200 RC4             |    1204 |        174 | 7758 |        1 |
| 4.1.0                   |    1110 |        174 | 7673 |        1 |
| 5.0.0 M1                |    2001 |        174 | 7441 |        1 |
| 5.0.0 M2                |    2002 |        174 | 7442 |        1 |
| 5.0.0 M3                |    2003 |        174 | 7443 |        1 |
| 5.0.0 M4                |    2004 |        174 | 7716 |        1 |
| 5.0.0 M5                |    2005 |        174 | 7717 |        1 |
| 5.0.0 M6                |    2006 |        174 | 7848 |        1 |
| 5.0.0 M7                |    2007 |        174 | 7849 |        1 |
| 5.0.0 Mars              |    2000 |        174 | 7291 |        1 |
| 5.0.0 RC1               |    2011 |        174 | 7850 |        1 |
| 5.0.0 RC2               |    2012 |        174 | 7851 |        1 |
| 5.0.0 RC3               |    2013 |        174 | 7852 |        1 |
| 5.0.0 RC4               |    2014 |        174 | 7853 |        1 |
| 5.0.100 RC1             |    2101 |        174 | 8124 |        1 |
| 5.0.100 RC2             |    2102 |        174 | 8125 |        1 |
| 5.0.100 RC3             |    2103 |        174 | 8126 |        1 |
| 5.0.100 RC4             |    2104 |        174 | 8127 |        1 |
| 5.0.200 RC1             |    2201 |        174 | 8370 |        1 |
| 5.0.200 RC2             |    2202 |        174 | 8371 |        1 |
| 5.0.200 RC3             |    2203 |        174 | 8372 |        1 |
| 5.0.200 RC4             |    2204 |        174 | 8373 |        1 |
| 5.0.300                 |    2300 |        174 | 8580 |        1 |
| 5.1.0                   |    2110 |        174 | 7759 |        1 |
| 6.0.0 M1                |    3001 |        174 | 7938 |        1 |
| 6.0.0 M2                |    3002 |        174 | 8168 |        1 |
| 6.0.0 M3                |    3003 |        174 | 8169 |        1 |
| 6.0.0 M4                |    3004 |        174 | 8170 |        1 |
| 6.0.0 M5                |    3005 |        174 | 8171 |        1 |
| 6.0.0 M6 API Freeze     |    3006 |        174 | 8172 |        1 |
| 6.0.0 M7 Feature Freeze |    3007 |        174 | 8173 |        1 |
| 6.0.100 RC1             |    3101 |        174 | 8893 |        1 |
| 6.0.100 RC2             |    3102 |        174 | 8894 |        1 |
| 6.0.100 RC3             |    3103 |        174 | 8895 |        1 |
| 6.0.100 RC4             |    3104 |        174 | 8896 |        1 |
| 6.0.200 RC1             |    3201 |        174 | 8897 |        1 |
| 7.0.0 M1                |    3277 |        174 | 8898 |        1 |
| 7.0.0 M2                |    3277 |        174 | 8899 |        1 |
| 7.0.0 M3                |    3277 |        174 | 8900 |        1 |
| 7.0.0 M4                |    3277 |        174 | 8901 |        1 |
| 7.0.0 M5                |    3277 |        174 | 8902 |        1 |
+-------------------------+---------+------------+------+----------+
90 rows in set (0.00 sec)

Let me know if you need values changed.
Comment 4 Matthias Zimmermann CLA 2017-09-04 04:45:50 EDT
perfect! tx for your support