'Upgrading AWS RDS MySQL 5.7 to 8.0, failing at PrePatchCompatibility with false positive errors

I'm scratching my head off, but basically I'm upgrading my RDS instance from MySQL 5.7 to 8.0.

However, it's returning a very odd error during the PrePatchCompatibiity check.

12) Usage of removed functions
Following DB objects make use of functions that have been removed in version 8.0. Please make sure to update them to use supported alternatives before upgrade.
More Information:
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals

app-website-org-staging.eav_value_point.value_point_value - COLUMN uses removed functions X (consider using ST_X instead), Y (consider using ST_Y instead)

The odd thing here is, I'm NOT using the functions X and Y on this stored generated column. I am ALREADY using ST_X and ST_Y in the generated column function. I was wondering how I can get rid of that error.

What I have tried:

  1. In phpMyAdmin, edit, and save again.
  2. In phpMyAdmin, edit, change the functions to uppercase, and save again.
  3. Used mysqldump to export the table, and verified that indeed I was using ST_X and ST_Y.
  4. Removed the problematic column.

1-3 did not work, 4 worked, but that was not my intention. I want to know the true reason.

Please see my table dump below:

CREATE TABLE `eav_value_point` (
  `value_point_id` int(11) UNSIGNED NOT NULL,
  `value_point_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `value_point_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `value_point_modified_by` int(11) UNSIGNED DEFAULT NULL,
  `value_point_attribute_id` int(11) UNSIGNED NOT NULL,
  `value_point_entity_id` int(11) UNSIGNED NOT NULL,
  `value_point_value_real` point NOT NULL,
  `value_point_value` varchar(255) COLLATE utf8mb4_unicode_520_ci GENERATED ALWAYS AS (concat(st_x(`value_point_value_real`),',',st_y(`value_point_value_real`))) STORED
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

If anyone can shed me some light I'd appreciate it! Thanks all in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source