You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/07/15 08:37:28 UTC

[GitHub] [shardingsphere] mazhaoshuo opened a new issue #6354: 关于mysql json字段中抽取一个字段问题

mazhaoshuo opened a new issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354


   在我执行下列语句的时候,我获取的是两个字段，可是结果返回的是一个字段
   `select content_json->>'$.nation' as nation,content_json->>'$.title' as title from  tb_content_json b where b.content_id=1`
   ![image](https://user-images.githubusercontent.com/39507157/87523098-09917b00-c6b9-11ea-8d74-49f3f3869842.png)
   这张表没有进行分表，想问下 不分片的表，能否不通过shardingsphere解析sql，直接把我的sql放到mysql中执行，或者怎么支持我上面的sql


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354


   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] mazhaoshuo commented on issue #6354: 关于mysql json字段中抽取一个字段问题

Posted by GitBox <gi...@apache.org>.
mazhaoshuo commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-658651469


   > @mazhaoshuo仅适用于英语。
   
   I have translated the question


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-662377111


   @mazhaoshuo Can you give the error stack of proxy？


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-662377111


   @mazhaoshuo Can you give the  stack info of proxy？


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-659294419


   @tristaZero @mazhaoshuo The sql is not ok on master branch,i'll trace it.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-659284390


   @mazhaoshuo No matter It is a sharding table or not, `SQL Parsing` is required.
   
   @jingshanglu Could you give this SQL a check? Parsed well nor not on our master branch and previous release?
   
   Trista


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-659294419


   @tristaZero @mazhaoshuo The sql is not ok on master branch,i'll trance it.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] mazhaoshuo removed a comment on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
mazhaoshuo removed a comment on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-658651469


   > @mazhaoshuo仅适用于英语。
   
   I have translated the question


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-662951824


   @mazhaoshuo The issue of parsing `->>` has been fixed at [#6423](https://github.com/apache/shardingsphere/pull/6423) by @jingshanglu . Our next release will include this one.
   
   Thanks,
   Trista


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] mazhaoshuo commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
mazhaoshuo commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-658653399


   @menghaoranss I have translated the question


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-662952381


   @mazhaoshuo BTW, could you provide the more detailed log of ShardingProxy? If so, we can make sure what @jingshanglu did is exactly for your issue.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] menghaoranss commented on issue #6354: 关于mysql json字段中抽取一个字段问题

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-658649668


   @mazhaoshuo For English only.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] mazhaoshuo edited a comment on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
mazhaoshuo edited a comment on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-660009767


   > @mazhaoshuo Which version do you use? do you use mysql client to connect to shardingsphere proxy?
   
   @jingshanglu apache-shardingsphere-4.1.1-sharding-proxy      I've changed it to the following
   `select JSON_UNQUOTE(JSON_EXTRACT(content_json,'$.title') as title from tb_content_json b where b.content_id=1`
   Does not seem to support - > >
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] mazhaoshuo commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
mazhaoshuo commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-660009767


   > @mazhaoshuo Which version do you use? do you use mysql client to connect to shardingsphere proxy?
   
   @jingshanglu apache-shardingsphere-4.1.1-sharding-proxy      I've changed it to the following
   `select JSON_UNQUOTE(JSON_EXTRACT(content_json,'$.#(x.title')) as title from tb_content_json b where b.content_id=1`
   Does not seem to support - > >
   


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu commented on issue #6354: How to get the result in MySQL JSON field

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6354:
URL: https://github.com/apache/shardingsphere/issues/6354#issuecomment-659774010


   @mazhaoshuo Which version do you use? do you use mysql client to connect to shardingsphere proxy?


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org