[I] [Bug] Incorrect sequenceNumber in manifest after row-tracking compaction [paimon]

["juntaozhang (via GitHub)" <gi...@apache.org>]

juntaozhang opened a new issue, #7408:
URL: https://github.com/apache/paimon/issues/7408

   ### 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 TABLE t (id INT, data INT) TBLPROPERTIES ('row-tracking.enabled' = 'true', 'compaction.min.file-num'='2')")
   
         sql("INSERT INTO t VALUES (1, 1)")
         sql("INSERT INTO t VALUES (2, 2)")
         sql("INSERT INTO t VALUES (3, 3)")
   
         sql("CALL sys.compact(table => 't')")
   
   
         sql("INSERT INTO t VALUES (4, '4')")
         sql("INSERT INTO t VALUES (5, '5')")
         sql("CALL sys.compact(table => 't')")
   
         sql("SELECT min_sequence_number, max_sequence_number FROM `t$files`").show(false)
   
   ### What doesn't meet your expectations?
   
   currently:
   ```
   +-------------------+-------------------+
   |min_sequence_number|max_sequence_number|
   +-------------------+-------------------+
   |6                  |10                 |
   +-------------------+-------------------+
   ```
   
   should be:
   ```
   +-------------------+-------------------+
   |min_sequence_number|max_sequence_number|
   +-------------------+-------------------+
   |1                  |5                 |
   +-------------------+-------------------+
   ```
   
   ### Anything else?
   
   _No response_
   
   ### 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: issues-unsubscribe@paimon.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Bug] Incorrect sequenceNumber in manifest after row-tracking compaction [paimon]

["JingsongLi (via GitHub)" <gi...@apache.org>]

JingsongLi closed issue #7408: [Bug] Incorrect sequenceNumber in manifest after row-tracking compaction
URL: https://github.com/apache/paimon/issues/7408


-- 
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: issues-unsubscribe@paimon.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org