maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Alexander!

On Apr 24, Alexander Barkov wrote:
> Hello,
> 
> I noticed that UTC_TIME, UTC_DATE, UTC_DATETIME are reserved keywords:
> 
> MariaDB [test]> SELECT * FROM utc_time;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the 
> manual that corresponds to your MariaDB server version for the right 
> syntax to use near 'utc_time' at line 1
> 
> I think they should not.

agree

> - These keywords are not mentioned in the SQL standard
> - They are not involved in any complex grammar that would prevent them
>    from being non-reserved keywords
>
> Looks like a bug...
> 
> Any objections to make them non-reserved keywords in 10.2?

Not from me :)

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx