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/10/25 07:07:09 UTC
[GitHub] [doris] Wilson-BT opened a new issue, #13640: [Bug] [Bug] Sql Exec Failed Raise IndexOutOfBoundsException
Wilson-BT opened a new issue, #13640:
URL: https://github.com/apache/doris/issues/13640
### 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
1.1.3
### What's Wrong?
when i exec sql like this，IndexOutOfBoundsException will be raised. we don`t know why.
```
with b as (
select store_no,order_unit_no,item_no,max(item_name) as item_naa
from retail_gms_ods.inventory
group by store_no,order_unit_no,item_no
order by store_no,order_unit_no,item_no
limit 100
)
SELECT
a.store_no,
a.order_unit_no,
a.item_code,
a.item_name,
a.item_no,
a.color_no,
a.sku_no,
a.size_kind,
a.balance_qty
FROM
retail_gms_ods.inventory a
INNER JOIN
b
ON a.store_no = b.store_no
AND a.order_unit_no = b.order_unit_no
AND a.item_no = b.item_no
```
but we can explain it success.
### What You Expected?
Sql exec can be more robust.
### 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] dataalive commented on issue #13640: [Bug] [Bug] Sql Exec Failed Raise IndexOutOfBoundsException
Posted by GitBox <gi...@apache.org>.
dataalive commented on issue #13640:
URL: https://github.com/apache/doris/issues/13640#issuecomment-1290513501
this bug has been fixed by https://github.com/apache/doris/pull/13300 and pull the latest code of branch 1.1-lts to fix
--
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] Wilson-BT closed issue #13640: [Bug] [Bug] Sql Exec Failed Raise IndexOutOfBoundsException
Posted by GitBox <gi...@apache.org>.
Wilson-BT closed issue #13640: [Bug] [Bug] Sql Exec Failed Raise IndexOutOfBoundsException
URL: https://github.com/apache/doris/issues/13640
--
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