I am referring to this knowledge base article:
https://confluence.atlassian.com/bamkb/unable-to-change-the-current-build-number-in-bamboo-759858218.html
I am at Version7.2.4 of Bamboo but when I run the suggested query for newer versions than 5.10.0 to locate the build plan:
SELECT * FROM BUILD_NUMBERS JOIN BUILD USING (BUILD_ID) ORDER BY FULL_KEY;
I get this error:
Msg 321, Level 15, State 1, Line 1
"BUILD_ID" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.
However, if I run the query suggested for older than 5.10.0, it seems to work so I am not sure which suggested update query to run to change the plan number. If the one for older version works, then the article needs to be corrected.
