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/10/10 06:37:33 UTC
[GitHub] [shardingsphere] zt9788 opened a new issue, #19144: mysql max min function with select table.* use the subquery will lost some column
zt9788 opened a new issue, #19144:
URL: https://github.com/apache/shardingsphere/issues/19144
## Bug Report
### Which version of ShardingSphere did you use?
version=5.1.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
```
#this sql will error
select k.* from (
select a,b,min(a_b) as startTime max(a_c) as endTime ,d,e,f,g (8 column)
from table_number where ...... group by ...) k where ...
```
**## Edit begin**
mybatis read just have a,b,d... ,but startTime,endTime will lost when **select k.***
I try to use
```
select k.a,k.startTime....... from (...) k .... //it is right
```
<img width="522" alt="image" src="https://user-images.githubusercontent.com/15647179/178942035-41db6574-7965-47a1-9568-43711b2246ea.png">
The sharding use hasSelectExpandProjections will return 5 columns
when the else was 8 columns
<img width="845" alt="image" src="https://user-images.githubusercontent.com/15647179/178942697-c46007c8-0e8a-4fd5-be77-939221058756.png">
**Original question**
> How can i set `ShardingSphereResultSet`.`hasSelectExpandProjections` false or make it right?
**New**
It is a bug or i have to chang all the * to cloumn name?
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #19144: mysql max min function with select table.* use the subquery will lost some column
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #19144:
URL: https://github.com/apache/shardingsphere/issues/19144#issuecomment-1407563854
We generally use select * from table.
This issue has been inactive for a long time, and ShardingSphere has released several new versions, so I will close it.
Please try the latest version, and if the problem reproduces, please reopen it or submit a new one.
--
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] RaigorJiang closed issue #19144: mysql max min function with select table.* use the subquery will lost some column
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #19144: mysql max min function with select table.* use the subquery will lost some column
URL: https://github.com/apache/shardingsphere/issues/19144
--
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] github-actions[bot] closed issue #19144: mysql max min function with select table.* use the subquery will lost some column
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19144: mysql max min function with select table.* use the subquery will lost some column
URL: https://github.com/apache/shardingsphere/issues/19144
--
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] github-actions[bot] commented on issue #19144: mysql max min function with select table.* use the subquery will lost some column
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19144:
URL: https://github.com/apache/shardingsphere/issues/19144#issuecomment-1272349364
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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