When an API is called simultaneously with different arguments, the results are somehow merged together. The issue is not happening when the API is not called simultaneously. I don't think the issue is with database. Have you guys experienced this before? Thanks!
SELECT airSegment.PNRID, carrier, flightNumber, departureDateTime, arrivalDateTime
FROM AirSegment
WHERE (AirSegment.PNRID = )
ORDER BY AirSegment.segmentNumber;
When an API is called simultaneously with different arguments, the results are somehow merged together. The issue is not happening when the API is not called simultaneously. I don't think the issue is with database. Have you guys experienced this before? Thanks!