[アップデート] Amazon RDS のデータベースプレビュー環境で MySQL 9.7（Long-Term Support）を評価出来るようになりました

% mysql -h hoge0724mysql97.ca0mg86saazc.us-east-2.rds-preview.amazonaws.com -u admin -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 9.7.0 Source distribution

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

mysql> SHOW VARIABLES LIKE 'version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 9.7.0               |
| version_comment         | Source distribution |
| version_compile_machine | aarch64             |
| version_compile_os      | Linux               |
| version_compile_zlib    | 1.3.1               |
+-------------------------+---------------------+
5 rows in set (0.20 sec)

mysql> SELECT @@optimizer_switch LIKE '%hypergraph%';
+----------------------------------------+
| @@optimizer_switch LIKE '%hypergraph%' |
+----------------------------------------+
|                                      1 |
+----------------------------------------+
1 row in set (0.20 sec)

mysql> SET optimizer_switch='hypergraph_optimizer=on';
ERROR 3999 (42000): The hypergraph optimizer does not yet support 'this build configuration; to enable it, build with CMake option WITH_HYPERGRAPH_OPTIMIZER=ON'

mysql> SELECT TIMEDIFF('2025-07-24 10:30:00', '2025-07-24') AS timediff_result;
+-----------------+
| timediff_result |
+-----------------+
| 10:30:00        |
+-----------------+
1 row in set (0.20 sec)

mysql> SELECT TIMEDIFF('invalid', '2025-07-24') AS timediff_invalid;
+------------------+
| timediff_invalid |
+------------------+
| NULL             |
+------------------+
1 row in set, 1 warning (0.19 sec)

mysql> SELECT FROM_DAYS(-1) AS negative, FROM_DAYS(0) AS zero, FROM_DAYS(1) AS one, FROM_DAYS(365) AS d365, FROM_DAYS(366) AS d366;
+----------+------+------------+------------+------------+
| negative | zero | one        | d365       | d366       |
+----------+------+------------+------------+------------+
| NULL     | NULL | 0000-01-01 | 0000-12-31 | 0001-01-01 |
+----------+------+------------+------------+------------+
1 row in set (0.19 sec)

mysql> SELECT DATE_ADD('9999-12-31', INTERVAL 1 DAY) AS overflow_date;
+---------------+
| overflow_date |
+---------------+
| NULL          |
+---------------+
1 row in set, 1 warning (0.19 sec)

mysql> SELECT DATE_ADD('9999-12-31 23:59:59', INTERVAL 1 SECOND) AS overflow_datetime;
+-------------------+
| overflow_datetime |
+-------------------+
| NULL              |
+-------------------+
1 row in set, 1 warning (0.19 sec)

mysql> SHOW VARIABLES LIKE 'replica_parallel_type';
Empty set (0.20 sec)

mysql> SET GLOBAL replica_parallel_type = 'LOGICAL_CLOCK';
ERROR 1193 (HY000): Unknown system variable 'replica_parallel_type'

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected, 1 warning (0.19 sec)

mysql> SHOW WARNINGS;
+---------+------+---------------------------------------------------------------------------+
| Level   | Code | Message                                                                   |
+---------+------+---------------------------------------------------------------------------+
| Warning | 1681 | 'FLUSH PRIVILEGES' is deprecated and will be removed in a future release. |
+---------+------+---------------------------------------------------------------------------+
1 row in set (0.19 sec)

mysql> SHOW VARIABLES LIKE 'innodb_log_writer_threads';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| innodb_log_writer_threads | OFF   |
+---------------------------+-------+
1 row in set (0.20 sec)

mysql> SHOW VARIABLES LIKE 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | OFF   |
+---------------+-------+
1 row in set (0.19 sec)