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:41:00 UTC
[GitHub] [shardingsphere] VeejaLiu opened a new issue, #17402: Doesn't support IFNULL ?
VeejaLiu opened a new issue, #17402:
URL: https://github.com/apache/shardingsphere/issues/17402
## Bug Report
### Which version of ShardingSphere did you use?
5.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
# max():
SQL:
```
MySQL [hireez_sharding_db]> select max(email_campaign_account_id) from EMAIL_CAMPAIGN;
+--------------------------------+
| max(email_campaign_account_id) |
+--------------------------------+
| NULL |
+--------------------------------+
1 row in set (0.010 sec)
```
log:
```
[INFO ] 2022-05-07 02:11:25.914 [ShardingSphere-Command-16] ShardingSphere-SQL - Logic SQL: select max(email_campaign_account_id) from EMAIL_CAMPAIGN
[INFO ] 2022-05-07 02:11:25.914 [ShardingSphere-Command-16] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
[INFO ] 2022-05-07 02:11:25.914 [ShardingSphere-Command-16] ShardingSphere-SQL - Actual SQL: database_team_default ::: select max(email_campaign_account_id) from EMAIL_CAMPAIGN_TEAM_0 UNION ALL select max(email_campaign_account_id) from EMAIL_CAMPAIGN_TEAM_1 UNION ALL select max(email_campaign_account_id) from EMAIL_CAMPAIGN_TEAM_2
```
# IFNULL():
```
MySQL [hireez_sharding_db]> select IFNULL(max(email_campaign_account_id),0) from EMAIL_CAMPAIGN;
+------------------------------------------+
| IFNULL(max(email_campaign_account_id),0) |
+------------------------------------------+
| 0 |
| 0 |
| 0 |
+------------------------------------------+
3 rows in set (0.007 sec)
```
```
[INFO ] 2022-05-07 02:14:03.723 [ShardingSphere-Command-17] ShardingSphere-SQL - Logic SQL: select IFNULL(max(email_campaign_account_id),0) from EMAIL_CAMPAIGN
[INFO ] 2022-05-07 02:14:03.725 [ShardingSphere-Command-17] ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
[INFO ] 2022-05-07 02:14:03.725 [ShardingSphere-Command-17] ShardingSphere-SQL - Actual SQL: database_team_default ::: select IFNULL(max(email_campaign_account_id),0) from EMAIL_CAMPAIGN_TEAM_0 UNION ALL select IFNULL(max(email_campaign_account_id),0) from EMAIL_CAMPAIGN_TEAM_1 UNION ALL select IFNULL(max(email_campaign_account_id),0) from EMAIL_CAMPAIGN_TEAM_2
```
Maybe we need to aggregate the results again after finding the results in slices. Although this sounds very troublesome.
--
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] strongduanmu commented on issue #17402: Doesn't support IFNULL ?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1166272854
@iisheng Welcome, I will assign this issue to 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] hailin0 commented on issue #17402: Doesn't support IFNULL ?
Posted by "hailin0 (via GitHub)" <gi...@apache.org>.
hailin0 commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1519109391
Can I work on this 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #17402: Doesn't support IFNULL ?
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1120118058
@VeejaLiu Thank you for your feedback, ShardingSphere doesn't suppot ifnull function now. Are you interested in submitting a PR to improve 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
Re: [I] Doesn't support IFNULL ? [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-2026020296
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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] iisheng commented on issue #17402: Doesn't support IFNULL ?
Posted by GitBox <gi...@apache.org>.
iisheng commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1166248910
Can I work on this 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.
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 #17402: Doesn't support IFNULL ?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1272349860
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
[GitHub] [shardingsphere] strongduanmu commented on issue #17402: Doesn't support IFNULL ?
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1519221214
@hailin0 Of course, I will assign this issue to 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] github-actions[bot] closed issue #17402: Doesn't support IFNULL ?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #17402: Doesn't support IFNULL ?
URL: https://github.com/apache/shardingsphere/issues/17402
--
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] hailin0 commented on issue #17402: Doesn't support IFNULL ?
Posted by "hailin0 (via GitHub)" <gi...@apache.org>.
hailin0 commented on issue #17402:
URL: https://github.com/apache/shardingsphere/issues/17402#issuecomment-1519280351
> @hailin0 Of course, I will assign this issue to you.
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org