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:
<span>SELECT</span> <span>*</span> <span>FROM</span> BUILD_NUMBERS <span>JOIN</span> BUILD <span>USING</span> <span>(</span>BUILD_ID<span>)</span> <span>ORDER</span> <span>BY</span> FULL_KEY<span>;</span>
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.