You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "young138120 (via GitHub)" <gi...@apache.org> on 2024/02/29 07:53:42 UTC
[I] [Bug] get_json_string not excected work [doris]
young138120 opened a new issue, #31590:
URL: https://github.com/apache/doris/issues/31590
### 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
2.0.5
### What's Wrong?
I can run this sql in 2.0.2 version
```sql
get_json_string(detail, '$.serviceType') as 'service_types',
```
but after upgrade version to 2.0.5 ,it run fail
data example :
```json
[{"bookTime":1708790327000,"bottomOrderId":64129010475336887552,"bottomOrderNumber":"FWAHHFHTDD29730","buildTimeoutMillisecond":1708790635574,"city":"合肥市","companyId":1037,"customerId":53460,"desLat":"31.797243","desLng":"117.352144","district":"肥西县","followMonitor":true,"isActive":0,"isDelete":0,"orderId":641289643401764864,"orderNumber":"SAAJY21431466","orderStatus":8,"orderType":0,"providerId":1726,"providerName":"xxx","province":"安徽省","publicNo":641289643380793344,"rescueLat":"31.622059","rescueLng":"117.208614","serviceType":"TC_3T","table":"or_rescue_order","triggerTimeoutMillisecond":1708790335574,"type":"INSERT"}]
```
### What You Expected?
just report this bug
### 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
Re: [I] [Bug] get_json_string not excected work [doris]
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 commented on issue #31590:
URL: https://github.com/apache/doris/issues/31590#issuecomment-1972587241
> Could you provide more info? I tried your case in 2.0.5 without table column, it can work: 
>
> Maybe you can offer your table create statement simplified and example data insert statement, so that we can reproduce your problem and debug~
you can follow there steps :
1. create a faker table
2. and set a field named xxx and json type
3. insert the example data
4. select get_json_string(xxx,$.serviceType)
you unable to reproduce select the example in direct
--
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
Re: [I] [Bug] get_json_string not excected work [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao commented on issue #31590:
URL: https://github.com/apache/doris/issues/31590#issuecomment-1972408897
Could you provide more info? I tried your case in 2.0.5 without table column, it can work:
Maybe you can offer your table create statement simplified and example data insert statement, so that we can reproduce your problem and debug~
--
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
Re: [I] [Bug] get_json_string not expected work [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31590:
URL: https://github.com/apache/doris/issues/31590#issuecomment-3287225598
We're closing this issue because it hasn't been updated in a while.
If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!
--
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
Re: [I] [Bug] get_json_string not expected work [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #31590: [Bug] get_json_string not expected work
URL: https://github.com/apache/doris/issues/31590
--
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
Re: [I] [Bug] get_json_string not expected work [doris]
Posted by "superdiaodiao (via GitHub)" <gi...@apache.org>.
superdiaodiao commented on issue #31590:
URL: https://github.com/apache/doris/issues/31590#issuecomment-1972595832
> by the way， another selectDB man confirm this a be server bug
OK
--
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
Re: [I] [Bug] get_json_string not excected work [doris]
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 commented on issue #31590:
URL: https://github.com/apache/doris/issues/31590#issuecomment-1972588946
by the way， another selectDB man confirm this a be server bug
--
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