Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-81751

New reserved keywords in Aurora MySQL database engine

XMLWordPrintable

      Hello! :wave: 

       

      I wanted to bring to your attention that the Aurora MySQL database engine (version 3.06.0, compatible with MySQL 8.0.34) has introduced new reserved keywords, including "accept," "aws_bedrock_invoke_model," "aws_sagemaker_invoke_endpoint," "content_type," and "timeout_ms." I have noticed that "content_type" is used in "mod_hvp." 

      https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.3060.html

      Can you please advise on the best way to address this issue? Is it recommended to add the keywords in https://github.com/moodle/moodle/blob/main/lib/ddl/mysql_sql_generator.php#L592 ? (along with suggesting hvp to change the column name)

      Thank you for your assistance!

      Affected plugins:

      https://github.com/h5p/moodle-mod_hvp/issues/549

       

            jtomkinson Jordan Tomkinson
            guillermogomez@catalyst-au.net Guillermo Gomez Arias
            Marina Glancy Marina Glancy
            Huong Nguyen Huong Nguyen
            Ron Carl Alfon Yu Ron Carl Alfon Yu
            Votes:
            1 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 23 minutes
                2h 23m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.