You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/07/29 01:58:55 UTC
[GitHub] [doris] jacktengg opened a new issue, #11318: [Bug] group_concat regression test case fail
jacktengg opened a new issue, #11318:
URL: https://github.com/apache/doris/issues/11318
### 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
master b260a0221
### What's Wrong?
query result is wrong, expected:
```
\N \N
103 255
1001 1986, 1989
1002 1989, 32767
3021 1991, 1992, 32767
5014 1985, 1991
25699 1989
2147483647 255, 1991, 32767, 32767
```
actual result:
```
+------------+----------------------------------------------------------------------+
| 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, 255, 255, 32767 |
+------------+----------------------------------------------------------------------+
```
or
```
+------------+----------------------------------------------------------------+
| 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, 1992, 32767 |
| 5014 | 1985, 1991 |
| 25699 | 1989 |
| 2147483647 | 255, 255, 255, 32767 |
+------------+----------------------------------------------------------------+
```
### What You Expected?
result is OK
### How to Reproduce?
_No response_
### 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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] jacktengg commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
jacktengg commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198850088
The test result seems not stable, sometimes it's right, sometimes it's wrong, and the wrong answers can be different. Maybe you can try to run it mutiple times.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] yiguolei closed issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #11318: [Bug] regression test case test_group_concat fail
URL: https://github.com/apache/doris/issues/11318
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] jacktengg commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] jacktengg commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
jacktengg commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198846027
> ```sql
> | 3021 | 1991, 1991, 32767 |
> ```
>
> I can't reproduce this case, do you have any clue?
Nothing special in my test env. Just version master b260a02215033e87c67b2ae09ba2ac9ff0a50aef, build with ASAN, and the following config of BE:
```
enable_storage_vectorization=true
enable_low_cardinality_optimize=true
```
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] BiteTheDDDDt commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198851284
Why the to result have diffrent header?
```sql
| abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY abs(`k2`), `k1`) |
```
```sql
| abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY abs(`k2`)) |
```
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] BiteTheDDDDt commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198841288
```sql
| 3021 | 1991, 1991, 32767 |
```
I can't reproduce this case, do you have any clue?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] BiteTheDDDDt commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198848877
>
Do you have multiple BE?
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] jacktengg commented on issue #11318: [Bug] regression test case test_group_concat fail
Posted by GitBox <gi...@apache.org>.
jacktengg commented on issue #11318:
URL: https://github.com/apache/doris/issues/11318#issuecomment-1198849505
No, single FE and BE.
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org