Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    1.0.7
 - 
    None
 
- 
        2017-12, 2017-13, 2017-14, 2017-15, 2017-16, 2017-17, 2017-18
 
Description
Original SQL:
SELECT mobile, nick_name, lead (nick_name, 1) over (PARTITION BY wm ORDER BY create_date ASC) AS next_name FROM ods_user;
Create View SQL:
SELECT `ods_user`.`MOBILE` AS `mobile`, `ods_user`.`NICK_NAME` AS `nick_name`, `lead`(
`test`.`ods_user`.`NICK_NAME`,1,NULL,1)  AS `next_name`
FROM `ods_user`