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/11/25 08:35:51 UTC
[GitHub] [shardingsphere] princess-yanyan opened a new issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
princess-yanyan opened a new issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793
## Question
**For English only**, other languages will not accept.
Before asking a question, make sure you have:
- Googled your question.
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
When I used 4.0.1 version,config <prop key="query.with.cipher.column">false</prop>, use plain column to query is correct,like you see "1" and "2" are plain column


but when I used 5.0.0 version,config query-with-cipher-column="false",use plain column to query is not correct


so i want to say ,can 5.0.0 version the rewrite sql same as 4.0.1?
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979036983
> @princess-yanyan Thank you for your feedback. I see you are using the table-level `query.with.cipher.column` parameter, which is great. And I will investigate this issue.
You tested it In UnitTest ?
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979009030
<xsd:schema xmlns="http://shardingsphere.apache.org/schema/shardingsphere/encrypt"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:beans="http://www.springframework.org/schema/beans"
targetNamespace="http://shardingsphere.apache.org/schema/shardingsphere/encrypt"
elementFormDefault="qualified">
<xsd:import namespace="http://www.springframework.org/schema/beans" schemaLocation="http://www.springframework.org/schema/beans/spring-beans.xsd" />
<xsd:element name="rule">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="table" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="query-with-cipher-column" type="xsd:boolean" default="true" />
</xsd:complexType>
</xsd:element>
<xsd:element name="table">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="column" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute name="name" type="xsd:string" use="required" />
<xsd:attribute name="query-with-cipher-column" type="xsd:boolean" />
</xsd:complexType>
</xsd:element>
<xsd:element name="column">
<xsd:complexType>
<xsd:attribute name="logic-column" type="xsd:string" use="required" />
<xsd:attribute name="cipher-column" type="xsd:string" use="required" />
<xsd:attribute name="assisted-query-column" type="xsd:string" />
<xsd:attribute name="plain-column" type="xsd:string" />
<xsd:attribute name="encrypt-algorithm-ref" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
<xsd:element name="encrypt-algorithm">
<xsd:complexType>
<xsd:all>
<xsd:element ref="beans:props" minOccurs="0" />
</xsd:all>
<xsd:attribute name="id" type="xsd:string" use="required" />
<xsd:attribute name="type" type="xsd:string" use="required" />
</xsd:complexType>
</xsd:element>
</xsd:schema>
--
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] princess-yanyan commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
princess-yanyan commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-978954492
I mean when query-with-cipher-column="false", 1 and 3 all should card_no (plain column)
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979656696
@princess-yanyan install code in local and test 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] wuguanyu removed a comment on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu removed a comment on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979036621
> > @princess-yanyan Can you try rule level ?
>
> As @wuguanyu said, you can use the rule-level `query.with.cipher.column` parameter. The `query.with.cipher.column` parameter at the table level is a new feature. I just tested it and there are indeed some rewriting problems. I will fix this as soon as possible.
You tested it In UnitTest ?
--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979032433
> @strongduanmu ruleLevel or tableLevel query.with.cipher.column ,Does it have priority?
@wuguanyu If the queryWithCipherColumn at the table level is configured, it has a higher priority.
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979611996

--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-978961887
@princess-yanyan Thank you for your feedback. I see you are using the table-level `query.with.cipher.column` parameter, which is great. And I will investigate 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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979655824
@strongduanmu I see source code ,we set query.with.cipher.column in rule-level, It worked.
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979010755
@princess-yanyan Can you try rule level ?
--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979024148
> @princess-yanyan Can you try rule level ?
As @wuguanyu said, you can use the rule-level `query.with.cipher.column` parameter. The `query.with.cipher.column` parameter at the table level is a new feature. I just tested it and there are indeed some rewriting problems. I will fix this as soon as possible.
--
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] princess-yanyan commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
princess-yanyan commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979804086
@strongduanmu @wuguanyu sorry,The internet in the company is not good,i can't download the source code,when i go home i will try,thank you for your reply
--
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 closed issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793
--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979054878
> > @princess-yanyan Thank you for your feedback. I see you are using the table-level `query.with.cipher.column` parameter, which is great. And I will investigate this issue.
>
> You tested it In UnitTest ?
@wuguanyu Test with 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] princess-yanyan commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
princess-yanyan commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-982241223
I install code in local with 5.0.1-SNAPSHOT and test this problem with table level query.with.cipher.column param,then it worked, table level has a higher priority.
--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979629754
Hi @princess-yanyan @wuguanyu, can you help test this issue on master branch?
--
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 #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979657466
> @princess-yanyan install code in local and test issue?
@wuguanyu Yes, test this problem with table level query.with.cipher.column param.
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979036621
> > @princess-yanyan Can you try rule level ?
>
> As @wuguanyu said, you can use the rule-level `query.with.cipher.column` parameter. The `query.with.cipher.column` parameter at the table level is a new feature. I just tested it and there are indeed some rewriting problems. I will fix this as soon as possible.
You tested it In UnitTest ?
--
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] wuguanyu commented on issue #13793: config query-with-cipher-column="false" rewrite sql is not correct
Posted by GitBox <gi...@apache.org>.
wuguanyu commented on issue #13793:
URL: https://github.com/apache/shardingsphere/issues/13793#issuecomment-979027693
@strongduanmu ruleLevel or tableLevel query.with.cipher.column ,Does it have priority?
--
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