SQL query started failing since 5 days ago with "Unknown column" error

[abriginets]

Hello. I have a query in my project that is responsible for finding closest airports to a chosen one:

SELECT neighbour.*,
        (
          6371 *
          acos(cos(radians(main.latitude)) *
          cos(radians(neighbour.latitude)) *
          cos(radians(neighbour.longitude) -
          radians(main.longitude)) +
          sin(radians(main.latitude)) *
          sin(radians(neighbour.latitude)))
        ) AS distance
        FROM flautru.Airport neighbour
        JOIN flautru.Airport main ON neighbour.code <> main.code
        WHERE main.code = "HKG"
        HAVING distance < 250
        ORDER BY distance;

It was working just fine until I started seeing elevated error rate since 5 days ago. It now fails with the following error:

Raw query failed. Code: `1054`. Message: `target: flautru.-.primary: vttablet: rpc error: code = NotFound desc = Unknown column 'main.latitude' in 'having clause' (errno 1054) (sqlstate 42S22) (CallerID: planetscale-admin): Sql: "select neighbour.*, :vtg1 * acos(cos(radians(main.latitude)) * cos(radians(neighbour.latitude)) * cos(radians(neighbour.longitude) - radians(main.longitude)) + sin(radians(main.latitude)) * sin(radians(neighbour.latitude))) as distance from Airport as neighbour join Airport as main on neighbour.`code` != main.`code` where main.`code` = :v1 having :vtg1 * acos(cos(radians(main.latitude)) * cos(radians(neighbour.latitude)) * cos(radians(neighbour.longitude) - radians(main.longitude)) + sin(radians(main.latitude)) * sin(radians(neighbour.latitude))) < :vtg2 order by distance asc", BindVars: {#maxLimit: "type:INT64 value:\"100001\""v1: "type:VARBINARY value:\"HKG\""vtg1: "type:INT64 value:\"6371\""vtg2: "type:INT64 value:\"250\""}

I don't see any announcements regarding changes to underlying Planetscale infrastructure nor didn't I recieve any emails regarding any possible changes. Did something change in MySQL/Vitess in that time? And how should I fix this issue?

[fooforge]

Hey @abriginets, we'll be taking a look shortly and respond to the ticket you have also created.