zhangguichuan opened a new issue, #13931: URL: https://github.com/apache/doris/issues/13931
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version branch: branch-1.1-lts commit: 844cfceb76ecd865454ba1d1600d55e69c22b316 ### What's Wrong? I got two problems: 1. execute sql report error: Malformed packet mysql> SELECT id,unix_timestamp() as created_at FROM t_test limit 10; ERROR 2027 (HY000): Malformed packet ` 2. I think unix_timestamp() should be same as unix_timestamp(now()) ，but actually it's different! ``` mysql> SELECT id,status,unix_timestamp() as created_at FROM t_test limit 5; +----------------------------------+--------+------------+ | id | status | created_at | +----------------------------------+--------+------------+ | 01b1e77810bfb185bc948820caf30bf6 | NULL | 1667447166 | | 04f484de77cd437c882ccf04be20f1c7 | NULL | | | 0510fe0eadb06d2abf5629f25a00dd3a | NULL | | | 06401164d02215fad983281e1e311e17 | NULL | | | 140fb6c0a610cedacff3e22d5d44427c | NULL | | +----------------------------------+--------+------------+ ``` ``` mysql> SELECT id,status,unix_timestamp(now()) as created_at FROM t_test limit 5; +----------------------------------+--------+------------+ | id | status | created_at | +----------------------------------+--------+------------+ | 0595eaf0b0efaf5dce90502ee22b8852 | NULL | 1667447170 | | 065e53ceb56cbacc8b13431caf9e82b8 | NULL | 1667447170 | | 171c8dbf252e1b9850f5b3b7cd1dcec0 | NULL | 1667447170 | | 173bc5ffbce5aed424b9232830bc9abb | NULL | 1667447170 | | 237ce2110c5c2356e7a78a96cc3e2d46 | NULL | 1667447170 | +----------------------------------+--------+------------+ ``` ### What You Expected? I expect two sql below get same result: ``` SELECT id,status,unix_timestamp() as created_at FROM events limit 5; ``` ``` SELECT id,status,unix_timestamp(now()) as created_at FROM events limit 5; ``` ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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
