Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11
-
None
-
None
-
Debian bookworm
Description
CREATE VIEW generates broken SQL on week() function
creating this Example View, to get the week of the current date works.
create view view_name as select (week(curdate())) ;
with SHOW CREATE for it
show create view view_name \G
generates this broken SQL, it adds an "," without any following value.
CREATE VIEW `view_name` AS select week(curdate(),)