The current logic for generating UIN is incorrect.
As per, current logic, the below query fetches the approved drone whose record has the highest id.
|
@Query("SELECT MAX(id) FROM OperatorDrone od WHERE od.operatorDroneStatus ='UIN_APPROVED'") |
This can lead to multiple drones getting same UIN because record with highest id might not have the highest UIN. This will happen when a drone with higher id gets its UIN before a drone with lower id.
@sidd-shetty @sidhantgoel @charan1994 @suraj-shanbhag
The current logic for generating UIN is incorrect.
As per, current logic, the below query fetches the approved drone whose record has the highest id.
digital-sky-api/src/main/java/com/ispirit/digitalsky/repository/OperatorDroneRepository.java
Line 16 in 573899f
This can lead to multiple drones getting same UIN because record with highest id might not have the highest UIN. This will happen when a drone with higher id gets its UIN before a drone with lower id.
@sidd-shetty @sidhantgoel @charan1994 @suraj-shanbhag