0

How does Amazon Aurora handle conditional queries based on MySQL version? I was unable to find any documentation on this.

For example, the code below inserts into a database for MySQL 5.6.4 or newer. What is result in Aurora?

I could spin up an instance but wanted to read the documentation about this to understand what incompatible features there are.

/*!50604 REPLACE INTO `phppos_app_config` (`key`, `value`) VALUES ('supports_full_text', '1')*/;
4
  • What is the problem with REPLACE in Aurora? (Please provide link.)
    – Rick James
    Commented Jan 13, 2018 at 19:26
  • It isn't a problem with replace I just want to make sure the query isn't ignored as I don't think Aurora follows the same versioning of mysql and all I want to know is if there query will run and not be ingored Commented Jan 13, 2018 at 19:29
  • Then simply try it: SELECT /*!50604 "inside comment", */ NOW(); -- You will either see inside comment or not. The current time will show up in either case, as confirmation that the query was executed.
    – Rick James
    Commented Jan 13, 2018 at 19:36
  • I just booted up an Aurora instance and it was running 5.6.10 and it worked. I was hoping not to boot one up as I don't need it; but it will only cost a small amount. This might help someone else when they have this issue. Commented Jan 13, 2018 at 19:53

1 Answer 1

0

Aurora runs as mysql 5.6.10a so the comment queries still work as expected in regular mysql

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.