apache / apache/incubator-seata

seata1.4.2版本不支持mysql加解密函数吗

Open
#4,140 2 comments 0 reactions 0 assignees View on GitHub
status: waiting-for-feedback
Dominant language
Java
Stars
26k
Forks
8.8k
Avg merge
1d 8h
Merged PRs (30d)
4

Description

- [ ] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate.

### Ⅰ.问题描述
我的mysql里边会对部分数据字段加密处理,用的是mysql自带的加解密函数,当我开启一个全局事务,插入一条数据后,seata会报一个异常错误,显示不支持的sql

### Ⅱ. 异常现象:
`Caused by: io.seata.common.exception.NotSupportYetException: not support sql [insert into config_info (apartment_id, branch_id, config_key, config_value, create_time, customer_id, floor_id, modify_time, room_id, id) values (?, ?, ?, encryptInfo(?, 'password'), ?, ?, ?, ?, ?, ?)]`

### Ⅲ. 寻求帮助

我想问下目前seata还不支持加解密sql吗,或者是说目前有没有什么好的解决方案

### Ⅳ 环境

- JDK version :1.8
- Seata version: 1.4.2
- OS : Centos7
- mysql:5.7

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported INSERT using MySQL 5.7, Seata 1.4.2, and the shown encryptInfo(...) expression. Trace the SQL handling that produces NotSupportYetException and check whether function expressions are covered. Done requires a confirmed compatibility answer or a clearly scoped change with regression coverage.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql, sql
Domain
databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.