juntaozhang opened a new issue, #8015: URL: https://github.com/apache/paimon/issues/8015
### Search before asking - [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar. ### Paimon version master ### Compute Engine spark ### Minimal reproduce step ```sql CREATE DATABASE IF NOT EXISTS my_db1; USE spark_catalog.my_db1; DROP TABLE IF EXISTS `my_db1`.`chain_test`; CREATE TABLE IF NOT EXISTS `chain_test` ( `t1` BIGINT, `t2` BIGINT, `t3` STRING ) PARTITIONED BY (`dt` STRING) TBLPROPERTIES ( 'bucket-key' = 't1', 'primary-key' = 'dt,t1', 'partition.timestamp-pattern' = '$dt', 'partition.timestamp-formatter' = 'yyyyMMdd', 'chain-table.enabled' = 'true', 'bucket' = '1', 'merge-engine' = 'deduplicate', 'sequence.field' = 't2' ); SET spark.paimon.branch = delta; INSERT OVERWRITE TABLE `my_db1`.`chain_test` PARTITION (dt = '20250810') VALUES (1, 2, '1'); INSERT OVERWRITE TABLE `my_db1`.`chain_test$branch_delta` PARTITION (dt = '20250811') VALUES (2, 2, '1'); SELECT * FROM `my_db1`.`chain_test$snapshots`; RESET spark.paimon.branch; // ① SELECT * FROM `my_db1`.`chain_test$branch_snapshot` WHERE dt = '20250811'; // ② SET spark.paimon.branch = snapshot; SELECT * FROM `my_db1`.`chain_test` where dt = '20250811'; DROP TABLE IF EXISTS `my_db1`.`chain_test`; ``` ### What doesn't meet your expectations? ① ② should be empty. but currently ② is not empty. ### Anything else? #5460 deprecated the branch option. #7084 discussed the priority between Paimon dynamic options and table identifiers. Before the branch option is fully removed, we should unify their behaviors first. ### Are you willing to submit a PR? - [x] I'm 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]
