travis-mann
commented
4 months ago Issue is a MySQL issue, can be reproduced with query below
WITH CombinedFlights AS (SELECT * FROM deltas UNION SELECT * FROM southwests)
SELECT A.DepartAirport AS StartAirport, A.ArriveAirport AS Connection1, B.ArriveAirport AS FinalAirport, A.DepartDateTime
AS StartDepartDateTime, A.ArriveDateTime AS Leg1ArriveDateTime, B.DepartDateTime AS Leg2DepartDateTime, B.ArriveDateTime
AS FinalArriveDateTime, A.FlightNumber AS FlightNumber1, B.FlightNumber AS FlightNumber2
FROM CombinedFlights A JOIN CombinedFlights B ON A.ArriveAirport = B.DepartAirport
WHERE A.DepartAirport = 'Atlanta (ATL)' AND B.ArriveAirport = 'Tuscon (TUS)' AND B.DepartDateTime >= A.ArriveDateTime
AND ABS(TIMESTAMPDIFF(MINUTE, A.ArriveDateTime, B.DepartDateTime))
BETWEEN '60' AND '1440'
AND ('2023-01-01T00:00:00' IS NULL OR A.DepartDateTime BETWEEN '2023-01-01T00:00:00' AND '2023-01-02T00:00:00')
ORDER BY CASE WHEN ('Depart' = 'Depart') THEN StartDepartDateTime WHEN ('Depart' = 'TravelTime') THEN ABS(TIMESTAMPDIFF(MINUTE, StartDepartDateTime, FinalArriveDateTime))
ELSE FinalArriveDateTime END * CASE WHEN ('ASC' = 'ASC') THEN 1 ELSE -1 END;
All flight searches with > 0 connections throw the following error when the backend is hosted on the EC2. The error does not occur in my local environment.