laizuan opened a new issue, #330: URL: https://github.com/apache/doris-flink-connector/issues/330
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version flink-doris-connector-1.18-1.5.2.jar flink: 1.18.1 mysql: 8.0 doris: 2.0.5 ### What's Wrong? 数据库字段`xxx`是bit类型，并且不为空。生成Doris预计如下： ```sql CREATE TABLE IF NOT EXISTS `xx`.`xx`( `id` BIGINT COMMENT '主键', `xxx` BOOLEAN DEFAULT 'b' 0 '' COMMENT 'xxx' ) UNIQUE KEY(`id`) DISTRIBUTED BY HASH(`id`) BUCKETS AUTO PROPERTIES ( 'replication_num' = '1', 'light_schema_change' = 'true' ) ``` 在控制执行SQL后的异常： ```txt Failed to execute sql: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 3: `xxx` BOOLEAN DEFAULT 'b' 0 '' COMMENT 'xxx' ^ Encountered: INTEGER LITERAL Expected: COMMA ``` ### What You Expected? ```sql CREATE TABLE IF NOT EXISTS `cm`.`xx`( `id` BIGINT COMMENT '主键', `xxx` BOOLEAN DEFAULT 'false' COMMENT 'xxx' ) UNIQUE KEY(`id`) DISTRIBUTED BY HASH(`id`) BUCKETS AUTO PROPERTIES ( 'replication_num' = '1', 'light_schema_change' = 'true' ) ``` ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
