The generated SQL statement order by is incorrect

[MindaDai]

Description

The generated SQL statement order by is incorrect
PagedList<CasePageCloseResp> pagedList = factory .select( Projections.bean( CasePageCloseResp.class, qClose.closeResult, qClose.closeTime, qClose.verdictAmount, qClose.closeAmount, qCase.id, qCase.name, qCase.type, qCase.causeId, qCase.number, qCase.status, qCase.amount, qCase.lawsuitStatus, qCase.createTime, qCase.updateTime, qCase.director)) .from(qCase) .leftJoin(qClose) .on(qCase.id.eq(qClose.caseId)) .where(where) .orderBy(qCase.number.desc(), qCase.id.desc()) .fetchPage((int) pageable.getOffset(), pageable.getPageSize());

Expected behavior

ORDER BY
CASE

	WHEN casepojo0_.number IS NULL THEN
	1 ELSE 0 
END,
casepojo0_.number DESC

Actual behavior

ORDER BY
casepojo3_.numbercase
WHEN IS NULL THEN
1 ELSE 0
END
The 'number' property and 'CASE' need space

Steps to reproduce

Environment

Version: 1.6.11
JPA-Provider: Hibernate 5.6.15
DBMS: MYSQL 5.7
Application Server: jdk8

[beikov]

Hey and thanks for the report. Please provide a test case for this based on one of our quickstarts.