MoanasDaddyXu opened a new issue, #65383: URL: https://github.com/apache/doris/issues/65383
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues) and found no similar issues. ### Version Reproduced with the table stream regression case on local Doris HEAD `d4a077caf8a`. Test environment: ```text regression-test/suites/table_stream_p0/test_binlog_property_alter_exception.groovy remote log: /mnt/disk1/jianxu/case_output/doris/testrun/table_stream_p0_20260708/test_binlog_property_alter_exception.final.log FE: 172.20.49.4:9030 ``` ### What's Wrong? When a table is created with ROW binlog enabled, changing `binlog.format` by `ALTER TABLE ... SET` should be rejected by the binlog format validation path. The regression case expects an exception message containing: ```text not support change binlog format ``` However, Doris currently returns a generic light schema change error: ```text errCode = 2, detailMessage = only support light schema change operator when use table with binlog<Row> ``` This makes `test_binlog_property_alter_exception` fail on the first `ALTER TABLE` check. ### What You Expected? Changing `binlog.format` after table creation should fail with a clear binlog format error, for example: ```text not support change binlog format ``` ### How to Reproduce? Regression case: ```text regression-test/suites/table_stream_p0/test_binlog_property_alter_exception.groovy ``` Failing SQL: ```sql ALTER TABLE tbl_row_fmt SET ("binlog.format" = "STATEMENT_AND_SNAPSHOT"); ``` Minimal flow: ```sql CREATE TABLE tbl_row_fmt ( k1 INT, v1 INT ) UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 1 PROPERTIES ( "replication_num" = "1", "enable_unique_key_merge_on_write" = "true", "binlog.enable" = "true", "binlog.format" = "ROW" ); ALTER TABLE tbl_row_fmt SET ("binlog.format" = "STATEMENT_AND_SNAPSHOT"); ``` ### Regression Test Result ```text suite: test_binlog_property_alter_exception command: ALTER TABLE tbl_row_fmt SET ("binlog.format" = "STATEMENT_AND_SNAPSHOT") expected: exception message contains "not support change binlog format" actual: errCode = 2, detailMessage = only support light schema change operator when use table with binlog<Row> ``` Log excerpt: ```text 2026-07-08 18:04:09.369 INFO - Execute sql: ALTER TABLE tbl_row_fmt SET ("binlog.format" = "STATEMENT_AND_SNAPSHOT") 2026-07-08 18:04:09.382 ERROR - Exception: java.sql.SQLException: errCode = 2, detailMessage = only support light schema change operator when use table with binlog<Row> Caused by: java.lang.AssertionError: Expect exception msg contains 'not support change binlog format', but meet 'java.sql.SQLException: errCode = 2, detailMessage = only support light schema change operator when use table with binlog<Row>' ``` ### Anything Else? Tracking issue: #65265 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
