jacktengg commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198854215
The first one is result of:
```
SELECT abs(k3), group_concat(cast(abs(k2) as varchar) order by abs(k2), k1)
FROM test_query_db.baseall group by abs(k3) order by abs(k3)
```
the second is for:
```
SELECT abs(k3), group_concat(cast(abs(k2) as varchar) order by abs(k2)) FROM
test_query_db.baseall group by abs(k3) order by abs(k3)
```
```
mysql> SELECT abs(k3), group_concat(cast(abs(k2) as varchar) order by
abs(k2), k1) FROM test_query_db.baseall group by abs(k3) order by abs(k3)
-> ;
+------------+----------------------------------------------------------------------+
| abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY
abs(`k2`), `k1`) |
+------------+----------------------------------------------------------------------+
| NULL | NULL
|
| 103 | 255
|
| 1001 | 1986, 1989
|
| 1002 | 1989, 32767
|
| 3021 | 1991, 1991, 32767
|
| 5014 | 1985, 1991
|
| 25699 | 1989
|
| 2147483647 | 255, 1991, 32767, 32767
|
+------------+----------------------------------------------------------------------+
8 rows in set (0.78 sec)
mysql> SELECT abs(k3), group_concat(cast(abs(k2) as varchar) order by
abs(k2)) FROM test_query_db.baseall group by abs(k3) order by abs(k3)
-> ;
+------------+----------------------------------------------------------------+
| abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY
abs(`k2`)) |
+------------+----------------------------------------------------------------+
| NULL | NULL
|
| 103 | 255
|
| 1001 | 1986, 1989
|
| 1002 | 1989, 32767
|
| 3021 | 1991, 1991, 32767
|
| 5014 | 1985, 1991
|
| 25699 | 1989
|
| 2147483647 | 255, 255, 255, 32767
|
+------------+----------------------------------------------------------------+
8 rows in set (0.47 sec)
mysql> select * from test_query_db.baseall;
+------+------+--------+-------------+----------------------+------------+-------+------------+---------------------+-------------+-------------+-----------+-------------+------------------------------------------+
| k0 | k1 | k2 | k3 | k4 | k5 |
k6 | k10 | k11 | k7 | k8 | k9
| k12 | k13 |
+------+------+--------+-------------+----------------------+------------+-------+------------+---------------------+-------------+-------------+-----------+-------------+------------------------------------------+
| NULL | NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL |
| 0 | 1 | 1989 | 1001 | 11011902 | 123.123 |
true | 1989-03-21 | 1989-03-21 13:00:00 | wangjuoo4 | 0.1 |
6.333 | string12345 | 170141183460469231731687303715884105727 |
| 0 | 2 | 1986 | 1001 | 11011903 | 1243.5 |
false | 1901-12-31 | 1989-03-21 13:00:00 | wangynnsf | 20.268 |
789.25 | string12345 | -170141183460469231731687303715884105727 |
| 0 | 4 | 1991 | 3021 | -11011907 | 243243.325 |
false | 3124-10-10 | 2015-03-13 10:30:00 | yanvjldjlll | 2.06 |
-0.001 | string12345 | 20220101 |
| 0 | 5 | 1985 | 5014 | -11011903 | 243.325 |
true | 2015-01-01 | 2015-03-13 12:36:38 | du3lnvl | -0 |
-365 | string12345 | 20220102 |
| 1 | 15 | 1992 | 3021 | 11011920 | 0 |
true | 9999-12-12 | 2015-04-02 00:00:00 | | 3.141592653 |
20.456 | string12345 | 701411834604692317 |
| 1 | 10 | 1991 | 5014 | 9223372036854775807 | -258.369 |
false | 2015-04-02 | 2013-04-02 15:16:52 | wangynnsf | -123456.54 |
0.235 | string12345 | -11011903 |
| 1 | 12 | 32767 | -2147483647 | 9223372036854775807 | 243.325 |
false | 1991-08-11 | 2013-04-02 15:16:52 | lifsno | -564.898 |
3.1415927 | string12345 | 1701604692317316873037158 |
| 0 | 3 | 1989 | 1002 | 11011905 | 24453.325 |
false | 2012-03-14 | 2000-01-01 00:00:00 | yunlj8@nk | 78945 |
3654 | string12345 | 0 |
| 0 | 7 | -32767 | 1002 | 7210457 | 3.141 |
false | 1988-03-21 | 1901-01-01 00:00:00 | jiw3n4 | 0 |
6058 | string12345 | -20220101 |
| 1 | 8 | 255 | 2147483647 | 11011920 | -0.123 |
true | 1989-03-21 | 9999-11-11 12:12:00 | wangjuoo5 | 987456.123 |
12.14 | string12345 | -2022 |
| 1 | 9 | 1991 | -2147483647 | 11011902 | -654.654 |
true | 1991-08-11 | 1989-03-21 13:11:00 | wangjuoo4 | 0 |
69.123 | string12345 | 11011903 |
| 1 | 11 | 1989 | 25699 | -9223372036854775807 | 0.666 |
true | 2015-04-02 | 1989-03-21 13:11:00 | yunlj8@nk | -987.001 |
4.336 | string12345 | 1701411834604692317316873037158 |
| 1 | 13 | -32767 | 2147483647 | -9223372036854775807 | 100.001 |
false | 2015-04-02 | 2015-04-02 00:00:00 | wenlsfnl | 123.456 |
3.1415927 | string12345 | 701411834604692317316873037158 |
| 1 | 14 | 255 | 103 | 11011902 | 0 |
false | 2015-04-02 | 2015-04-02 00:00:00 | | 3.141592654 |
2.036 | string12345 | 701411834604692317316873 |
| 0 | 6 | 32767 | 3021 | 123456 | 604587 |
true | 2014-11-11 | 2015-03-13 12:36:38 | yanavnd | 0.1 |
80699 | string12345 | 20220104 |
+------+------+--------+-------------+----------------------+------------+-------+------------+---------------------+-------------+-------------+-----------+-------------+------------------------------------------+
16 rows in set (0.46 sec)
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
