Bug #110725 View export incorrect
Submitted: 19 Apr 2023 7:28 Modified: 26 May 2023 12:36
Reporter: Vadak Terel Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[19 Apr 2023 7:28] Vadak Terel 
Description:
This view works fine:

CREATE VIEW `V_myview` 
 AS	SELECT `id`
         , `rtg`
         , ROW_NUMBER() OVER (PARTITION by `id` ORDER BY `modtime`) as `RNb` 
	FROM `Mytable`;

However, when exported to sql text, the result looks like this (useless):

CREATE ALGORITHM=UNDEFINED DEFINER=`definer`@`localhost` 
 SQL SECURITY DEFINER VIEW `V_myview`  
 AS SELECT `Mytable`.`id` AS `id`
         , `Mytable`.`rtg` AS `rtg`
         , row_number()  (PARTITION BY `Mytable`.`id` ORDER BY `Mytable`.`modtime` ) AS `OVER` 
      FROM `Mytable` ;

MySQL version: 8.0.32
PHPMyadmin is used for exporting: 7.4.33

How to repeat:
it is repetable anytime I export
[26 Apr 2023 12:36] MySQL Verification Team 
Hello Vadak,

Thank you for the bug report.
Could you please let us know the steps used to export?

Regards,
Ashwini Patil
[27 May 2023 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".