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`