[I] [Bug] The output time format of the lag/lead function is inconsistent with the input field. [doris]

[via GitHub]

asdf555111 opened a new issue, #50288:
URL: https://github.com/apache/doris/issues/50288

   ### Search before asking
   
   - [x] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   2.1.8
   
   ### What's Wrong?
   
   
![Image](https://github.com/user-attachments/assets/8ac09137-54b2-471d-a94e-bc4e2b572de6)
   
   The data type of created_time is datetime(6)
   
   ### What You Expected?
   
   Return the same data type and format as the original field.
   
   ### How to Reproduce?
   
   create table test(
        created_time    datetime(6)
   );
   
   insert into test 
   VALUES       ('2025-04-21 17:57:32.064000'),
                ('2025-04-21 17:57:33.804000'),
                ('2025-04-21 17:57:34.156000');
   
   select 
        created_time,
        lag(created_time,1,0) over(order by created_time) as lg_created_time 
   from test 
   ;
   
   select 
        created_time,
        lead(created_time,1,0) over(order by created_time) as lg_created_time 
   from test 
   ;
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org