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/04/16 03:37:27 UTC
[GitHub] [shardingsphere] wangkang09 opened a new issue #10105: rewrite sql error when using keyGenerator and encrypt together
wangkang09 opened a new issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105
shardingjdbc 4.1.1
Logic SQL: INSERT INTO rs_order ( member_id,billno,email ) VALUES ( ?,?,? )
Actual SQL: db1 ::: INSERT INTO rs_order_1 ( member_id,billno,email, email_hash, email_plain , id) VALUES (?, ?, ?, ?, ?, ?) :::
[1, 1, UTJNS0lVSmdLa0R4WEtHUcDbeXenQrmrOnpZHD32TYA=, 2021041605424943106, 4fc82b26aecb47d2868c4efbe3581732a3e7cbcc6c2efb32062c08170a05eeb8, 11]
but, expected actual sql parameter value is [1, 1, UTJNS0lVSmdLa0R4WEtHUcDbeXenQrmrOnpZHD32TYA=, ,4fc82b26aecb47d2868c4efbe3581732a3e7cbcc6c2efb32062c08170a05eeb8, 11, 2021041605424943106]
sorted sqlTokens:
![image](https://user-images.githubusercontent.com/41175635/114967974-00337a00-9ea8-11eb-8052-3427beb315ab.png)
parameters:
![image](https://user-images.githubusercontent.com/41175635/114968004-0cb7d280-9ea8-11eb-8d76-8f0f5e43fb33.png)
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huanghao495430759 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-829888817
Hi @wangkang09 @tristaZero I had use sharding-sphere-5.0.0-alpha and debug the case, and it can work normal.
`
2021-04-30 14:59:23.946 INFO 40464 --- [ main] ShardingSphere-SQL : Logic SQL: insert into user(user_id,user_name) values (?,?)
2021-04-30 14:59:23.946 INFO 40464 --- [ main] ShardingSphere-SQL : SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional.empty)
2021-04-30 14:59:23.946 INFO 40464 --- [ main] ShardingSphere-SQL : Actual SQL: ds0 ::: insert into user_0(user_id,user_name_encrypt, id, user_name_assisted, user_name) values (?, ?, ?, ?, ?) ::: [CT1, bfb2ec1a9c3083ceff0591431e29f169, 594904826799173632, CT11619765963895, CT1]
`
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-821033239
Could you try the 5.0.0-alpha? I suppose we fixed it already.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huanghao495430759 removed a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 removed a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-829888060
Hi @wangkang09 @tristaZero I had use sharding-sphere-5.0.0-alpha and debug the case, and i can work normal.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-830776498
Thanks @huanghao495430759,
@wangkang09 @huanghao495430759 tries the 5.0.0-alpha with your case, and everything works well. Please provide more details here.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826070317
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
![image](https://user-images.githubusercontent.com/41175635/115955484-42545f80-a529-11eb-91f4-11739df3ce96.png)
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826065971
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
i use 5.0.0-alpha. it has this problem too.
```yaml
spring:
shardingsphere:
datasource:
names: db0,db1,db0-slave,db1-slave
common:
type: com.alibaba.druid.pool.DruidDataSource
username: sa
password: ""
initialSize: 5
minIdle: 5
maxActive: 500
maxWait: 60000
timeBetweenEvictionRunsMillis: 20000
minEvictableIdleTimeMillis: 200000
maxEvictableIdleTimeMillis: 200000
db0:
url: jdbc:h2:mem:db0;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db0-slave:
url: jdbc:h2:mem:db0-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1:
url: jdbc:h2:mem:db1;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1-slave:
url: jdbc:h2:mem:db1-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
rules:
sharding:
tables:
rs_order:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
rs_order_hint:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-hint
database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-hint
default-database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-complex
default-table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-complex
default-key-generate-strategy:
column: id
key-generator-name: rs-order-generator
#sharding 中的 key generator 配置
key-generators:
# rs-order-generator 为 generator 的名字。供上面的 key-generator-name 使用
rs-order-generator:
type: DbSnowflakeKeyGenerator
props:
key.snow.type: rs_order # 传入 DbSnowflakeKeyGenerator 对应的 generator 实例
sharding-algorithms:
table-complex:
type: tableComplex
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
db-complex:
type: dbComplex
props:
xx: xx
table-hint:
type: tableHint
props:
xx: xx
db-hint:
type: dbHint
props:
xx: xx
replica-query:
data-sources:
db0:
primary-data-source-name: db0
replica-data-source-names: db0-slave
load-balancer-name: round-robin
db1:
primary-data-source-name: db1
replica-data-source-names: db1-slave
load-balancer-name: round-robin
load-balancers:
round-robin:
type: ROUND_ROBIN
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
encrypt:
tables:
rs_order:
columns:
email:
plain-column: email_plain
cipher-column: email
assisted-query-column: email_hash
encryptor-name: my-aes
encryptors:
my-aes:
type: my-AssistQuery
props:
business-key: 'privateDWK'
my-aes1:
type: my-AssistQuery
props:
business-key: 'privateDWK'
# shadow:
# column: shadow
# source-data-source-names: db0,db1
# shadow-data-source-names: db0-shadow,db1-shadow
props:
sql-show: true
query-with-cipher-column: 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-833236416
@tristaZero @huanghao495430759i found if i use mybatis it works well, but if i use mybatis-plus,that problem is appear
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826065858
> Hi we suggest users to try 5.0.0-alpha, since it fixed many issues of 4.x releases and supported more complex SQLs. Besides, more maintenance work will be done on this series.
i use 5.0.0-alpha,it has this problem too。
my config:
spring:
shardingsphere:
datasource:
names: db0,db1,db0-slave,db1-slave
common:
type: com.alibaba.druid.pool.DruidDataSource
username: sa
password: ""
initialSize: 5
minIdle: 5
maxActive: 500
maxWait: 60000
timeBetweenEvictionRunsMillis: 20000
minEvictableIdleTimeMillis: 200000
maxEvictableIdleTimeMillis: 200000
db0:
url: jdbc:h2:mem:db0;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db0-slave:
url: jdbc:h2:mem:db0-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1:
url: jdbc:h2:mem:db1;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1-slave:
url: jdbc:h2:mem:db1-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
rules:
sharding:
tables:
rs_order:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
rs_order_hint:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-hint
database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-hint
default-database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-complex
default-table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-complex
default-key-generate-strategy:
column: id
key-generator-name: rs-order-generator
#sharding 中的 key generator 配置
key-generators:
# rs-order-generator 为 generator 的名字。供上面的 key-generator-name 使用
rs-order-generator:
type: DbSnowflakeKeyGenerator
props:
key.snow.type: rs_order # 传入 DbSnowflakeKeyGenerator 对应的 generator 实例
sharding-algorithms:
table-complex:
type: tableComplex
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
db-complex:
type: dbComplex
props:
xx: xx
table-hint:
type: tableHint
props:
xx: xx
db-hint:
type: dbHint
props:
xx: xx
replica-query:
data-sources:
db0:
primary-data-source-name: db0
replica-data-source-names: db0-slave
load-balancer-name: round-robin
db1:
primary-data-source-name: db1
replica-data-source-names: db1-slave
load-balancer-name: round-robin
load-balancers:
round-robin:
type: ROUND_ROBIN
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
encrypt:
tables:
rs_order:
columns:
email:
plain-column: email_plain
cipher-column: email
assisted-query-column: email_hash
encryptor-name: my-aes
encryptors:
my-aes:
type: my-AssistQuery
props:
business-key: 'privateDWK'
my-aes1:
type: my-AssistQuery
props:
business-key: 'privateDWK'
# shadow:
# column: shadow
# source-data-source-names: db0,db1
# shadow-data-source-names: db0-shadow,db1-shadow
props:
sql-show: true
query-with-cipher-column: 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 removed a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 removed a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826065858
> Hi we suggest users to try 5.0.0-alpha, since it fixed many issues of 4.x releases and supported more complex SQLs. Besides, more maintenance work will be done on this series.
i use 5.0.0-alpha,it has this problem too。
my config:
spring:
shardingsphere:
datasource:
names: db0,db1,db0-slave,db1-slave
common:
type: com.alibaba.druid.pool.DruidDataSource
username: sa
password: ""
initialSize: 5
minIdle: 5
maxActive: 500
maxWait: 60000
timeBetweenEvictionRunsMillis: 20000
minEvictableIdleTimeMillis: 200000
maxEvictableIdleTimeMillis: 200000
db0:
url: jdbc:h2:mem:db0;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db0-slave:
url: jdbc:h2:mem:db0-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1:
url: jdbc:h2:mem:db1;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1-slave:
url: jdbc:h2:mem:db1-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
rules:
sharding:
tables:
rs_order:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
rs_order_hint:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-hint
database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-hint
default-database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-complex
default-table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-complex
default-key-generate-strategy:
column: id
key-generator-name: rs-order-generator
#sharding 中的 key generator 配置
key-generators:
# rs-order-generator 为 generator 的名字。供上面的 key-generator-name 使用
rs-order-generator:
type: DbSnowflakeKeyGenerator
props:
key.snow.type: rs_order # 传入 DbSnowflakeKeyGenerator 对应的 generator 实例
sharding-algorithms:
table-complex:
type: tableComplex
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
db-complex:
type: dbComplex
props:
xx: xx
table-hint:
type: tableHint
props:
xx: xx
db-hint:
type: dbHint
props:
xx: xx
replica-query:
data-sources:
db0:
primary-data-source-name: db0
replica-data-source-names: db0-slave
load-balancer-name: round-robin
db1:
primary-data-source-name: db1
replica-data-source-names: db1-slave
load-balancer-name: round-robin
load-balancers:
round-robin:
type: ROUND_ROBIN
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
encrypt:
tables:
rs_order:
columns:
email:
plain-column: email_plain
cipher-column: email
assisted-query-column: email_hash
encryptor-name: my-aes
encryptors:
my-aes:
type: my-AssistQuery
props:
business-key: 'privateDWK'
my-aes1:
type: my-AssistQuery
props:
business-key: 'privateDWK'
# shadow:
# column: shadow
# source-data-source-names: db0,db1
# shadow-data-source-names: db0-shadow,db1-shadow
props:
sql-show: true
query-with-cipher-column: 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 edited a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 edited a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826070317
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
Actual SQL: db1 ::: INSERT INTO rs_order_1 ( member_id,billno,email, email_hash, email_plain , id) VALUES (?, ?, ?, ?, ?, ?) ::: [1, 1, NEQ2VjNrWU5VT3N1VXM4Ul4EwtHvtZ7u3vHxb/iiEsA=, 2021042408597934083, 6b86b273ff34fce19d6b804eff5a3f5747ada4eaa22f1d49c01e52ddb7875b4b, 1]
![image](https://user-images.githubusercontent.com/41175635/115955484-42545f80-a529-11eb-91f4-11739df3ce96.png)
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huanghao495430759 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-829888060
Hi @wangkang09 @tristaZero I had use sharding-sphere-5.0.0-alpha and debug the case, and i can work normal.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-823972422
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
recently I started using 5.0.0-alpha,it really better than 4.1.1。and i want to persuade my leader to use 5.0.0-alpha。so,I need to collect some useful information about 5.0.0
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 removed a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 removed a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-822554620
alpha version can be used in production? could you give same related information to help me persuade my leader
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 removed a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 removed a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826065858
> Hi we suggest users to try 5.0.0-alpha, since it fixed many issues of 4.x releases and supported more complex SQLs. Besides, more maintenance work will be done on this series.
i use 5.0.0-alpha,it has this problem too。
my config:
spring:
shardingsphere:
datasource:
names: db0,db1,db0-slave,db1-slave
common:
type: com.alibaba.druid.pool.DruidDataSource
username: sa
password: ""
initialSize: 5
minIdle: 5
maxActive: 500
maxWait: 60000
timeBetweenEvictionRunsMillis: 20000
minEvictableIdleTimeMillis: 200000
maxEvictableIdleTimeMillis: 200000
db0:
url: jdbc:h2:mem:db0;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db0-slave:
url: jdbc:h2:mem:db0-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1:
url: jdbc:h2:mem:db1;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
db1-slave:
url: jdbc:h2:mem:db1-slave;DB_CLOSE_ON_EXIT=FALSE;database_to_upper=false
rules:
sharding:
tables:
rs_order:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
rs_order_hint:
actual-data-nodes: db0.rs_order_0,db0.rs_order_2,db1.rs_order_1,db1.rs_order_3
table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-hint
database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-hint
default-database-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: db-complex
default-table-strategy:
complex:
sharding-columns: member_id,billno
sharding-algorithm-name: table-complex
default-key-generate-strategy:
column: id
key-generator-name: rs-order-generator
#sharding 中的 key generator 配置
key-generators:
# rs-order-generator 为 generator 的名字。供上面的 key-generator-name 使用
rs-order-generator:
type: DbSnowflakeKeyGenerator
props:
key.snow.type: rs_order # 传入 DbSnowflakeKeyGenerator 对应的 generator 实例
sharding-algorithms:
table-complex:
type: tableComplex
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
db-complex:
type: dbComplex
props:
xx: xx
table-hint:
type: tableHint
props:
xx: xx
db-hint:
type: dbHint
props:
xx: xx
replica-query:
data-sources:
db0:
primary-data-source-name: db0
replica-data-source-names: db0-slave
load-balancer-name: round-robin
db1:
primary-data-source-name: db1
replica-data-source-names: db1-slave
load-balancer-name: round-robin
load-balancers:
round-robin:
type: ROUND_ROBIN
props:
xx: xx # https://github.com/apache/shardingsphere/pull/8331
encrypt:
tables:
rs_order:
columns:
email:
plain-column: email_plain
cipher-column: email
assisted-query-column: email_hash
encryptor-name: my-aes
encryptors:
my-aes:
type: my-AssistQuery
props:
business-key: 'privateDWK'
my-aes1:
type: my-AssistQuery
props:
business-key: 'privateDWK'
# shadow:
# column: shadow
# source-data-source-names: db0,db1
# shadow-data-source-names: db0-shadow,db1-shadow
props:
sql-show: true
query-with-cipher-column: 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-823170472
> Hi we suggest users to try 5.0.0-alpha, since it fixed many issues of 4.x releases and supported more complex SQLs. Besides, more maintenance work will be done on this series.
think you for reply~
i wonder why this version has not been released。Is it because of advanced features, such as Scaling、 sidecar。or have some other reasons? and how long will it take to release?
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-822869415
Hi we suggest users to try 5.0.0-alpha, since it fixed many issues of 4.x releases and supported more complex SQLs. Besides, more maintenance work will be done on this series.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-927294772
Sorry to reply late.
mybatis-plus is the ORM framework of JDBC.
Actually, , ShardingSphere community have no time to read source codes of other ORM framework, we are focusing on JDBC(or proxy) only.
So, please do some investigate, and then we can locate about SQL and JDBC interface.
--
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] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-822555145
> Could you try the 5.0.0-alpha? I suppose we fixed it already.
alpha version can be used in production? could you give same related information to help me persuade my leader
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-833231405
@tristaZero @huanghao495430759 https://github.com/wangkang09/sharding-test.git this is my test project~~
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105
--
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] huanghao495430759 removed a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 removed a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-829888238
Hi @wangkang09 @tristaZero I had use sharding-sphere-5.0.0-alpha and debug the case, and it can work normal.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 edited a comment on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 edited a comment on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826070317
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
Actual SQL: db1 ::: INSERT INTO rs_order_1 ( member_id,billno,email, email_hash, email_plain , id) VALUES (?, ?, ?, ?, ?, ?) ::: [1, 1, NEQ2VjNrWU5VT3N1VXM4Ul4EwtHvtZ7u3vHxb/iiEsA=, 2021042408597934083, 6b86b273ff34fce19d6b804eff5a3f5747ada4eaa22f1d49c01e52ddb7875b4b, 1]
![image](https://user-images.githubusercontent.com/41175635/115955484-42545f80-a529-11eb-91f4-11739df3ce96.png)
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huanghao495430759 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-827639654
> Hi @huanghao495430759
> I am curious whether you can give this issue a look?
> The detailed log from @wangkang09 budges me on our master branch.
> From your nice work, i.e., #10181 and #10177, I guess you are qualified to handle this one.
OK,I'll look at 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-827426579
Hi @huanghao495430759
I am curious whether you can give this issue a look?
The detailed log from @wangkang09 budges me on our master branch.
From your nice work, i.e., #10181 and #10177, I guess you are qualified to handle this one.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huanghao495430759 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
huanghao495430759 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-829888238
Hi @wangkang09 @tristaZero I had use sharding-sphere-5.0.0-alpha and debug the case, and it can work normal.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-823914104
Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-826065858
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-823968883
> Hi 5.0.0-alpha has been released for a long time. Maybe you have no interests on Scaling etc. But this issue was fixed from 5.x release.
sorry, what i mean is how long will 5.0.0 version take to release。not 5.0.0-alpha, not 5.0.0-beta。and i wonder what is the diff between them
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wangkang09 commented on issue #10105: rewrite sql error when using keyGenerator and encrypt together
Posted by GitBox <gi...@apache.org>.
wangkang09 commented on issue #10105:
URL: https://github.com/apache/shardingsphere/issues/10105#issuecomment-822554620
alpha version can be used in production? could you give same related information to help me persuade my leader
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org