Bug #113481 mysql8.0.18版本无法使用select nextval(); 被视为关键词了
Submitted: 21 Dec 2023 6:45 Modified: 21 Dec 2023 10:09
Reporter: mm anner Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: User-defined functions ( UDF ) Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[21 Dec 2023 6:45] mm anner 
Description:
自定义函数nextval  使用时无法使用select nextval(); 被视为关键词了
必须加关键词标识符号才行select `nextval`()  如何解决 5.7以及8.0.20版本中都可以

 8.0.18版本执行报错   在8.0.20版本中确可以

How to repeat:
自定义函数nextval  使用时无法使用select nextval(); 被视为关键词了
必须加关键词标识符号才行select `nextval`()  如何解决 5.7以及8.0.20版本中都可以

 8.0.18版本执行报错   在8.0.20版本中确可以
[21 Dec 2023 7:20] mm anner 
处理加关键词标识  没其他方案了吗
[21 Dec 2023 10:09] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.  

Thank you for your interest in MySQL.