Bug #110577 Missing year function?

• Submitted: 31 Mar 9:35
• Modified: 31 Mar 11:06
• Reporter: Pedro Ferreira
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Ubuntu (22.04)
• CPU Architecture: x86 (x86_64)
• Tags: year

[31 Mar 9:35] Pedro Ferreira

Description:
I am not sure if this is a bug. If I run this:

mysql> select CAST(1985 AS YEAR);
+--------------------+
| CAST(1985 AS YEAR) |
+--------------------+
|               1985 |
+--------------------+
1 row in set (0,00 sec)

Runs fine, but if I do:

mysql> CREATE TABLE t5 (c1 YEAR AS (CAST(1985 AS YEAR)));
ERROR 1305 (42000): FUNCTION sys.cast_as_year does not exist

Is this a bug?

The compilation parameters are the same as issue 108148:

-DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77

How to repeat:
Run the statement above.

[31 Mar 11:06] MySQL Verification Team

Hello Pedro Ferreira,

Thank you for the report and feedback.

regards,
Umesh