Error querying database. Cause: java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

[gdlai cn]

### Error querying database. Cause: java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ### The error may exist in com/thoughtworks/go/server/dao/maps/Stage.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT stages.name as stageName, stages.counter as stageCounter, stages.pipelineId as pipelineId, pipelines.name as pipelineName, pipelines.counter as pipelineCounter, pipelines.label as pipelineLabel, stages.approvedBy, stages.cancelledBy, stages.createdTime, stages.orderId, stages.result as stageResult, stages.approvalType, stages.completedByTransitionId as completedByTransitionId, stages.state as stageState, stages.latestRun, stages.fetchMaterials, stages.cleanWorkingDir, stages.rerunOfCounter, stages.artifactsDeleted, stages.configVersion, stages.lastTransitionedTime, builds.*, builds.id as buildId, buildstatetransitions.currentState, buildstatetransitions.statechangetime, buildstatetransitions.id as stateId FROM stages INNER JOIN pipelines ON pipelines.id = stages.pipelineId AND pipelines.name = ? INNER JOIN builds ON stages.id = builds.stageId AND builds.ignored != true LEFT JOIN buildstatetransitions ON builds.id = buildstatetransitions.buildId WHERE stages.id in ( SELECT stages.id FROM stages INNER JOIN pipelines ON stages.pipelineId = pipelines.id AND stages.name = ? AND pipelines.name = ? AND result = 'Passed' ORDER BY id LIMIT ? OFFSET ?) AND stages.result = 'Passed' ORDER BY stages.id, builds.name, buildstatetransitions.statechangetime ### Cause: java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

MySql:8.0.22

gocd: 20.10.0

[Jason Smyth]

Hello,

I could be wrong but this looks to me like the sort of thing that should be raised as an issue on GitHub:

https://github.com/gocd/gocd/issues

Regards,

Jason