Yukang-Lian opened a new issue, #15813: URL: https://github.com/apache/doris/issues/15813
### 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 master ### What's Wrong? #15339 When @TangSiyang2001 was developing `group_uniq_array` function and doing regression test, he found a `datetimev2` bug. 1. creat a test table. ```sql create table test ( c_id INT, c_date DATE, c_datev2 DATEV2, c_date_time DATETIME, c_date_timev2 DATETIMEV2(6)) DISTRIBUTED BY HASH(c_id) BUCKETS 3 PROPERTIES ( "replication_num" = "1" ) ; Query OK, 0 rows affected (0.05 sec) ``` 2. insert data. ```sql insert into test values( 1, '2022-12-01', '2022-12-01', '2022-12-01 22:23:23', '2022-12-01 22:23:24.999999'); Query OK, 1 row affected (0.14 sec) {'label':'insert_b85de801adae47db_a6f1d6297468dbfb', 'status':'VISIBLE', 'txnId':'1006'} insert into test values( 2, '2022-12-02', '2022-12-02', '2022-12-02 22:23:23', '2022-12-02 22:23:24.999999'); Query OK, 1 row affected (0.06 sec) {'label':'insert_8b8fd04b50674ffe_9ff5e5c2955abf50', 'status':'VISIBLE', 'txnId':'1007'} ``` 3. select from test table. ```sql select * from test; +------+------------+------------+---------------------+----------------------------+ | c_id | c_date | c_datev2 | c_date_time | c_date_timev2 | +------+------------+------------+---------------------+----------------------------+ | 2 | 2022-12-02 | 2022-12-02 | 2022-12-02 22:23:23 | 2022-12-02 22:23:24.999999 | | 1 | 2022-12-01 | 2022-12-01 | 2022-12-01 22:23:23 | 2022-12-01 22:23:24.999999 | +------+------------+------------+---------------------+----------------------------+ 2 rows in set (0.04 sec) select group_uniq_array(c_date), group_uniq_array(c_datev2), group_uniq_array(c_date_time), group_uniq_array(c_date_timev2) from test; +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ | group_uniq_array(`c_date`) | group_uniq_array(`c_datev2`) | group_uniq_array(`c_date_time`) | group_uniq_array(`c_date_timev2`) | +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ | [2022-12-02, 2022-12-01] | [2022-12-01, 2022-12-02] | [2022-12-02 22:23:23, 2022-12-01 22:23:23] | [, ] | +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ 1 row in set (0.09 sec) ``` We have tested functions `add`, `merge`, `insert_result_into` in `aggregate_function_group_uniq_array.h` return the right results for `datetimev2`. ### What You Expected? ```sql select group_uniq_array(c_date), group_uniq_array(c_datev2), group_uniq_array(c_date_time), group_uniq_array(c_date_timev2) from test; +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ | group_uniq_array(`c_date`) | group_uniq_array(`c_datev2`) | group_uniq_array(`c_date_time`) | group_uniq_array(`c_date_timev2`) | +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ | [2022-12-02, 2022-12-01] | [2022-12-01, 2022-12-02] | [2022-12-02 22:23:23, 2022-12-01 22:23:23] | [2022-12-02 22:23:24.999999, 2022-12-01 22:23:24.999999] | +----------------------------+------------------------------+--------------------------------------------+-----------------------------------+ ``` ### 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
