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 2022/02/24 09:02:59 UTC
[GitHub] [shardingsphere] myfairys opened a new issue #15613: About select column num is not match result column ,and always less one.
myfairys opened a new issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613
it's version:4.1.0
i use ShardingSphere-Proxy.
when i use the sub query on select column, i can't get the correct result. i always get a result that the result column numbers is less one than select column. For example:
i use this sql:
`SELECT
im.id AS id,
im.inquiry_code AS inquiryCode,
im.visitor_id AS visitorId,
im.content AS content,
im.chat_box_mark AS chatBoxMark,
im.access_user AS accessUser,
im.STATUS AS STATUS,
im.create_time AS createTime,
im.update_time AS updateTime,
im.top AS top,
im.deleted AS deleted,
im.user_type AS userType,
b.content AS lastMessage
,(
SELECT
count(*) AS msg
FROM
leshan_visitor_record
WHERE
is_read = 0
AND im.inquiry_code = inquiry_code
GROUP BY
inquiry_code
) as msgcount,
b.create_time AS lastRecordTime,
'aaa' as aaa
FROM
im_inquiry im
LEFT JOIN ( SELECT * FROM ( SELECT * FROM `leshan_visitor_record` ORDER BY create_time DESC LIMIT 10000 ) a GROUP BY a.inquiry_code ) b ON im.inquiry_code = b.inquiry_code`.
**i can get result but don't have "aaa",and is that i use sub query on select column???**
such as :
`1 ZX202202231057001 12345 测试 GROUP-431401804259393537 5 0 2022-02-23 10:57:15 2022-02-23 10:57:15 0 0 0 测试 1 2022-02-23 10:57:15
2 ZX202202231058001 123456 测试1 0 2022-02-23 10:58:49 2022-02-23 10:58:49 0 0 0 测试 2 2022-02-24 10:58:49`
and i don't know why happen.
Can you tell me how to resolve this bug? Thanks.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] myfairys commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
myfairys commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053776798
> Can you try 5.1.0 version?
Is it resolve this bug when use 5.1.0 version? If that, i can change to 5.1.0 sometime. And Thank you!
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] myfairys commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
myfairys commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053782522
> > > Can you try 5.1.0 version?
> >
> >
> > Is it resolve this bug when use 5.1.0 version? If that, i can change to 5.1.0 sometime. And Thank you!
>
> We have solved these similar problems. Maybe you can try it.
Okay, and can you tell me which issue?I want to look at 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053772543
Can you try 5.1.0 version?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053789848
@myfairys like this #13703
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053779396
> > Can you try 5.1.0 version?
>
> Is it resolve this bug when use 5.1.0 version? If that, i can change to 5.1.0 sometime. And Thank you!
We have solved these similar problems. Maybe you can try 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] myfairys commented on issue #15613: About select column num is not match result column ,and always less one.
Posted by GitBox <gi...@apache.org>.
myfairys commented on issue #15613:
URL: https://github.com/apache/shardingsphere/issues/15613#issuecomment-1053790259
> @myfairys like this #13703
Ok,thanks.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org