org.yaml.snakeyaml.error.YAMLException: Invalid tag: !SQL_PARSER

方保彦 · 2022 年2 月 15 日 08:14

docker镜像启动的的容器提示 Invalid tag: !SQL_PARSER

使用环境：

shardingsphere5.0.0

场景、问题：

server.yaml 配置
rules:

!AUTHORITY
users:
- root@%:root
- sharding@:sharding
  provider:
  type: ALL_PRIVILEGES_PERMITTED
!SQL_PARSER
sqlCommentParseEnabled: true

props:
proxy-hint-enabled: true
sql-show: true

已进行操作：

现状：

方保彦 · 2022 年2 月 15 日 08:14

RaigorJiang · 2022 年2 月 15 日 09:17

SQL_PARSER 是 5.0.0 发布之后新增的配置，在 5.0.0 镜像中确实无法使用。

github.com/apache/shardingsphere

Consider about add parser rule in kernel layer

opened 11:53AM - 21 Nov 21 UTC

closed 12:47AM - 29 Dec 21 UTC

totalo

type: enhancement in: SQL parse

refer #13722. In the process of reading the code, I found that some parsing r…ule configurations are still hard-coded in the code, and there are enough parsing-related configurations so that we can extract them and assemble them into a parse rule. such as `sql-comment-parse-enabled`, sqlStatementCache option and parse tree cache option, and more about parse. after extract: ``` - !SQL_PARSER sqlCommentParseEnabled: true sqlCacheInitialCapacity: 2000 ...... ``` todo list: - [x] Support the configuration of rules - [x] DistSQL RDL - [x] DistSQL RQL - [x] add docs Do you think this is a good idea? please give me some advices.

方保彦 · 2022 年2 月 15 日 09:27

好的。感谢。!SQL_PARSER是5.1.0才支持的吗。我现在maven库找不到5.1.0的包

menghaoran · 2022 年2 月 15 日 09:30

5.1.0 正在发布