slfan1989 opened a new issue, #1219:
URL: https://github.com/apache/paimon-rust/issues/1219

   ### Search before asking
   
   - [x] I searched in the 
[issues](https://github.com/apache/paimon-rust/issues) and found nothing 
similar.
   
   
   ### Please describe the bug 🐞
   
   MERGE incorrectly skips subsequent clauses when an earlier predicate 
evaluates to NULL.
   
   For a matched row with `s.flag = NULL`:
   
   ```sql
   WHEN MATCHED AND s.flag = 1 THEN UPDATE SET label = 'first'
   WHEN MATCHED THEN UPDATE SET label = 'fallback'
   ```
   
   Expected: `label` becomes `'fallback'`.
   Actual: the row remains unchanged.
   
   This also affects DELETE fallbacks and multiple WHEN NOT MATCHED INSERT 
clauses.
   
   
   ### Solution
   
   Replace NOT (previous_predicate) with (previous_predicate) IS NOT TRUE so 
NULL rows remain eligible for subsequent clauses.
   
   
   ### 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]

Reply via email to