1.9.0 (and also 1.8.0) - the result of some generated SQL queries is not portable

[neilyoung]

...at least not from MySQL to MS SQL Server.

I'm not talking about this monster statement here, which I could only convert to MSSQL by use of ChatGPT (thanks, btw):

DJI-Cloud-API-Demo/sample/src/main/java/com/dji/sample/manage/dao/IDeviceFirmwareMapper.java

Line 17 in c196f70

String sql = "<script> \n" +

But also here: "LIMIT 1" might work in MySQL, but doesn't work in MSSQL.

Found at various places. Some constructs look like "overkill security", like suspenders AND belt, because their formulation cannot bring more than max result record at a time. Please review your tables to find another way to ensure uniqueness. One way would be to capture all candidates and then deliver just the last (if) by code.

Here the candidates:

DJI-Cloud-API-Demo/sample/src/main/java/com/dji/sample/manage/service/impl/DeviceDictionaryServiceImpl.java

Line 32 in c196f70

return Optional.ofNullable(

DJI-Cloud-API-Demo/sample/src/main/java/com/dji/sample/map/service/impl/FlightAreaFileServiceImpl.java

Line 83 in c196f70

public Optional<FlightAreaFileDTO> getLatestByWorkspaceId(String workspaceId) {

DJI-Cloud-API-Demo/sample/src/main/java/com/dji/sample/map/service/impl/GroupServiceImpl.java

Line 49 in c196f70

public Optional<GetMapElementsResponse> getCustomGroupByWorkspaceId(String workspaceId) {