You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "McClone (via GitHub)" <gi...@apache.org> on 2023/02/15 03:58:55 UTC
[GitHub] [shardingsphere] McClone opened a new issue, #24173: likeQueryColumnName in PostgreSQL does not take effect
McClone opened a new issue, #24173:
URL: https://github.com/apache/shardingsphere/issues/24173
### Which version of ShardingSphere did you use? 5.3.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy
### Expected behavior
select * from xx where a like '%a%' has result;
### Actual behavior
select * from xx where a like '%a%' has no result;
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1432905383
when use distsql on postgresql can not work, but same distsql on mysql can work.
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1433990611
> e2e test already had this situation.
>
> https://github.com/apache/shardingsphere/blob/8bfd61e0f881cfe3e934b0d4790b8a0472fcb6fe/test/e2e/suite/src/test/resources/cases/dql/dql-integration-select.xml#L171-L174
>
>
> Maybe you can check logs to get more details.
logs show sql is wrong. like query value is not CHAR DIGEST value,just like encrypted value
--
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] gxxiong commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "gxxiong (via GitHub)" <gi...@apache.org>.
gxxiong commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1433051733
Try the keyword like in uppercase
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1433978267
e2e test already had this situation.
https://github.com/apache/shardingsphere/blob/8bfd61e0f881cfe3e934b0d4790b8a0472fcb6fe/test/e2e/suite/src/test/resources/cases/dql/dql-integration-select.xml#L171-L174
Maybe you can check logs to get more details.
--
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] mainidear commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "mainidear (via GitHub)" <gi...@apache.org>.
mainidear commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1437763378
Can you provide the sample code of "Like query column"? @McClone
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434377096
OK,I'll figure it out.
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1431416017
Hi @McClone
Please provide encrypt rule configuration and table structure.
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434298448
> Or after crete rule. execute `show encrypt rules` to check the rule is created.
it is have rules.
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434327539
Can you provide complete steps to do it? I can try to reproduce this problem.
And sql please use \``` select... \```
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1432903627
![_cgi-bin_mmwebwx-bin_webwxgetmsgimg__ MsgID=3762822829519345228 skey=@crypt_a483e9a3_ea8e947805d191749b3d3654adf9fdec mmweb_appid=wx_webfilehelper](https://user-images.githubusercontent.com/20875807/219347000-dafc92b4-9f18-4c26-85bd-db739f2baa61.jpg)
![_cgi-bin_mmwebwx-bin_webwxgetmsgimg__ MsgID=6708885929683913169 skey=@crypt_a483e9a3_ea8e947805d191749b3d3654adf9fdec mmweb_appid=wx_webfilehelper](https://user-images.githubusercontent.com/20875807/219347019-45b9d1bf-c5ef-4708-b858-57832f9464f3.jpg)
--
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] gxxiong commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "gxxiong (via GitHub)" <gi...@apache.org>.
gxxiong commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434308140
@tuichenchuxin
2023-02-17 16:42:18 [INFO ] 2023-02-17 08:42:18.846 [Connection-2-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SELECT * FROM t_encrypt WHERE user_name like '熊%'
2023-02-17 16:42:18 [INFO ] 2023-02-17 08:42:18.846 [Connection-2-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT "t_encrypt"."id", "t_encrypt"."user_name" AS "user_name" FROM t_encrypt WHERE user_name_like like 'rvRclQPExJDkhss3DQsRkQ=='
2023-02-17 16:42:32 [INFO ] 2023-02-17 08:42:32.417 [Connection-2-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SELECT * FROM t_encrypt WHERE user_name LIKE '熊%'
2023-02-17 16:42:32 [INFO ] 2023-02-17 08:42:32.418 [Connection-2-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT "t_encrypt"."id", "t_encrypt"."user_name" AS "user_name" FROM t_encrypt WHERE user_name_like LIKE '佹%'
table logic_column cipher_column plain_column assisted_query_column like_query_column encryptor_type encryptor_props assisted_query_type assisted_query_props like_query_type like_query_props query_with_cipher_column
t_encrypt user_name user_name user_name_like AES aes-key-value=123456abc CHAR_DIGEST_LIKE true
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434391383
Fixed by https://github.com/apache/shardingsphere/pull/23771/
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1433994031
This will not happen through configuration file configuration, but distsql will.I think is a bug on distsql.
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434297743
The number in like is calculated incorrectly.
This value 963eddd18... is wrong.
--
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] McClone closed issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone closed issue #24173: likeQueryColumnName in PostgreSQL does not take effect
URL: https://github.com/apache/shardingsphere/issues/24173
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434333473
> Can you provide complete steps to do it? I can try to reproduce this problem. And sql please use ``` select... ```
1.start postgresql proxy server
2.create database,create storge unit
3.create encrypt rule distsql
4.select * from xxx_table where xxx_field like '%xxx%'
Just the fuzzy query uses lowercase like on postgresql,nothing special about the others.
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434292725
Or after crete rule. execute `show encrypt rules` to check the rule is created.
--
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 #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434290175
Is there any error logs?
--
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 closed issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin closed issue #24173: likeQueryColumnName in PostgreSQL does not take effect
URL: https://github.com/apache/shardingsphere/issues/24173
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1434295896
![_cgi-bin_mmwebwx-bin_webwxgetmsgimg__ MsgID=5137752149934886846 skey=@crypt_a483e9a3_4a5602b69e1f20f5f9b6b7e1c3ea2de3 mmweb_appid=wx_webfilehelper](https://user-images.githubusercontent.com/20875807/219593659-9cc1da7e-e50c-4998-966a-8561e2268e25.jpg)
--
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] McClone commented on issue #24173: likeQueryColumnName in PostgreSQL does not take effect
Posted by "McClone (via GitHub)" <gi...@apache.org>.
McClone commented on issue #24173:
URL: https://github.com/apache/shardingsphere/issues/24173#issuecomment-1433965146
> Try the keyword like in uppercase
Is it reasonable to capitalize, or is it a bug?
--
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