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 2021/07/14 09:59:39 UTC
[GitHub] [shardingsphere] MingxingLAI opened a new issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
MingxingLAI opened a new issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331
## Question
* Apache ShardingSphere also plans to cite Hint through special notation in SQL, so that users can use that function in a more transparent way.
* Can you give me some hints, let me try to implement this function
--
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 #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-880317196
@MingxingLAI There is no official plan yet, and you are very welcome to implement this feature.
--
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] MingxingLAI edited a comment on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
MingxingLAI edited a comment on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-881151204
Hi，tristaZero，I quote this question from your official documentation，see [here](https://shardingsphere.apache.org/document/current/en/features/sharding/concept/hint/)
I think the hint syntax like [this](https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html). for example:
```SQL
SELECT /*+ NO_RANGE_OPTIMIZATION(t3 PRIMARY, f2_idx) */ f1
FROM t3 WHERE f1 > 30 AND f1 < 33;
SELECT /*+ BKA(t1) NO_BKA(t2) */ * FROM t1 INNER JOIN t2 WHERE ...;
SELECT /*+ NO_ICP(t1, t2) */ * FROM t1 INNER JOIN t2 WHERE ...;
SELECT /*+ SEMIJOIN(FIRSTMATCH, LOOSESCAN) */ * FROM t1 ...;
EXPLAIN SELECT /*+ NO_ICP(t1) */ * FROM t1 WHERE ...;
SELECT /*+ MERGE(dt) */ * FROM (SELECT * FROM t1) AS dt;
INSERT /*+ SET_VAR(foreign_key_checks=OFF) */ INTO t2 VALUES(2);
```
--
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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-880319864
Hi could you give more explanation on this feature? What does HINT means?
--
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] MingxingLAI commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
MingxingLAI commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-881151204
Hi，tristaZero，I quote this question from your official documentation，see [here](https://shardingsphere.apache.org/document/current/en/features/sharding/concept/hint/)
I understand the hint syntax like [this](https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html). for example:
```SQL
SELECT /*+ NO_RANGE_OPTIMIZATION(t3 PRIMARY, f2_idx) */ f1
FROM t3 WHERE f1 > 30 AND f1 < 33;
SELECT /*+ BKA(t1) NO_BKA(t2) */ * FROM t1 INNER JOIN t2 WHERE ...;
SELECT /*+ NO_ICP(t1, t2) */ * FROM t1 INNER JOIN t2 WHERE ...;
SELECT /*+ SEMIJOIN(FIRSTMATCH, LOOSESCAN) */ * FROM t1 ...;
EXPLAIN SELECT /*+ NO_ICP(t1) */ * FROM t1 WHERE ...;
SELECT /*+ MERGE(dt) */ * FROM (SELECT * FROM t1) AS dt;
INSERT /*+ SET_VAR(foreign_key_checks=OFF) */ INTO t2 VALUES(2);
```
--
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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882947808
--
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 commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-999253797
Hi all, there is already a new issue to deal with sql hint, so I will close this one.
Please refer to #13771.
--
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 commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882996053
This feature is great! But I think we still need more time to think and make plan.
@MingxingLAI if you have good ideas, please feel free to put forward them, 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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882948379
@MingxingLAI BTW, are you interested in other issues currently? All the issues labeling with `OSD` are ready to be assigned. Have a good day.
--
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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882947808
--
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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882947808
Hi @MingxingLAI ,
Thanks for your explanation. That will be a good feature. Actually, we have a plan to do such things. I'd welcome you to join!
@RaigorJiang Could you look at this one and get @MingxingLAI involved?
--
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 commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882996053
This feature is great! But I think we still need more time to think and make plan.
@MingxingLAI if you have good ideas, please feel free to put forward them, 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] RaigorJiang closed issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331
--
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 commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-882996053
This feature is great! But I think we still need more time to think and make plan.
@MingxingLAI if you have good ideas, please feel free to put forward them, 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] tristaZero commented on issue #11331: ShardingSphere plans to cite Hint through special notation in SQL, When is this feature ready to start？
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11331:
URL: https://github.com/apache/shardingsphere/issues/11331#issuecomment-880320027
It will be appreciated if you can give some examples.
--
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