flyer5200 opened a new issue, #34178:
URL: https://github.com/apache/shardingsphere/issues/34178
## Bug Report
### Failed to execute create encrypt rule
### Version: ShardingSphere-Proxy 5.5.1 cluster mode (zookeeper)
### Logs: the debug log output is as follows:
`[DEBUG] 2024-12-27 15:38:04.027 [ShardingSphere-Command-0]
o.a.s.p.f.m.c.MySQLCommandExecutorFactory - Execute packet type: COM_QUERY,
sql: CREATE ENCRYPT RULE sms_send_record (
COLUMNS (
(
NAME = mobile,
CIPHER = mobile_cipher,
ENCRYPT_ALGORITHM(TYPE(NAME = 'AES',
PROPERTIES('aes-key-value' = 'test-key-1111111')))
)
),
QUERY_WITH_CIPHER_COLUMN = TRUE
)
[INFO ] 2024-12-27 15:38:04.027 [ShardingSphere-Command-0]
o.a.s.i.m.ShardingSphereMetaData - contains database [qts-neptune].
[INFO ] 2024-12-27 15:38:04.027 [ShardingSphere-Command-0]
o.a.s.i.m.ShardingSphereMetaData - contains database [qts-neptune].
[INFO ] 2024-12-27 15:38:04.027 [ShardingSphere-Command-0]
o.a.s.i.m.ShardingSphereMetaData - Get database [qts-neptune].
[DEBUG] 2024-12-27 15:38:04.082 [ShardingSphere-Command-0]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
org.apache.shardingsphere.infra.exception.dialect.exception.syntax.sql.DialectSQLParsingException:
You have an error in your SQL syntax: no viable alternative at input
'CREATEENCRYPT'
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.getException(ShardingSphereSQLParserEngine.java:66)
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:59)
at
org.apache.shardingsphere.proxy.backend.handler.ProxySQLComQueryParser.parse(ProxySQLComQueryParser.java:50)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:64)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:84)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:59)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:120)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)`
--
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-unsubscr...@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
