### 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 -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/019ae2ce-bcd3-46b4-9930-ee2ffbacb35an%40googlegroups.com.
