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:19 UTC
[GitHub] [shardingsphere] novice-gamer opened a new issue, #16624: Case display results are different
novice-gamer opened a new issue, #16624:
URL: https://github.com/apache/shardingsphere/issues/16624
## Case display results are different
- Shardingsphere proxy version is 5.1.0
- SQL：
``` sql
mysql> SHOW FULL TABLES FROM `test` LIKE 'act_id_property';
+-----------------+------------+
| Tables_in_test | Table_type |
+-----------------+------------+
| act_id_property | BASE TABLE |
+-----------------+------------+
1 row in set (0.00 sec)
mysql> SHOW FULL TABLES FROM `test` LIKE 'ACT_ID_PROPERTY';
Empty set (0.00 sec)
mysql> select * from ACT_ID_PROPERTY;
+----------------+---------+------+
| NAME_ | VALUE_ | REV_ |
+----------------+---------+------+
| schema.version | 6.5.0.6 | 1 |
+----------------+---------+------+
1 row in set (0.01 sec)
```
MySQL is set to be case insensitive. The execution results of the two SQL statements are different. You can query the results in lowercase, but there is no result in uppercase.
Incompatible with such queries?
--
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] novice-gamer closed issue #16624: Case display results are different
Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #16624: Case display results are different
URL: https://github.com/apache/shardingsphere/issues/16624
--
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 #16624: Case display results are different
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16624:
URL: https://github.com/apache/shardingsphere/issues/16624#issuecomment-1091027118
@novice-gamer Thank you for your feedback. Are you interested in submitting a PR to solve 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 #16624: Case display results are different
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #16624:
URL: https://github.com/apache/shardingsphere/issues/16624#issuecomment-1272350100
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] novice-gamer commented on issue #16624: Case display results are different
Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #16624:
URL: https://github.com/apache/shardingsphere/issues/16624#issuecomment-1091037724
Sorry, I'm not a developer. Are you sure this is a bug in 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.
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 #16624: Case display results are different
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #16624: Case display results are different
URL: https://github.com/apache/shardingsphere/issues/16624
--
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