You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by "congxuebin (via GitHub)" <gi...@apache.org> on 2026/10/08 09:21:29 UTC

[I] [Bug] [sqlancer] PAX: IS NULL query returns fewer rows after DELETE [cloudberry]

congxuebin opened a new issue, #2091:
URL: https://github.com/apache/cloudberry/issues/2091

   ### Apache Cloudberry version
   
   
   **Version**
   ```
   PostgreSQL 14.4 (Apache Cloudberry 2.8.0 build 153099) (HashData Lightning 2.8.0 build 153099) on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7.7.0.2), 64-bit compiled on Sep 23 2026 22:47:39
   PostgreSQL 14.4 (Apache Cloudberry 2.1.0-devel+dev.15.g9485534a50 build 152581) (HashData Lightning 2.1.0-devel+dev.15.g9485534a50 build 152581) on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 12.2.1 20221121 (Red Hat 12.2.1-7.7.0.2), 64-bit compiled on Sep 19 2026 00:23:27
   ```
   
   
   ### What happened
   
   **Description**
   ```
   After a DELETE on a pax table, WHERE c0 IS NULL returns fewer rows than expected (2 NULL rows remain, the query returns 0). With SET pax.enable_sparse_filter = off the result is correct. See repro_pax_sparse_filter_isnull_after_delete.sql / repro_pax_sparse_filter_isnull_after_delete.log.
   ```
   
   
   ### What you think should happen instead
   
   _No response_
   
   ### How to reproduce
   
   
   [repro_pax_sparse_filter_isnull_after_delete.log](https://github.com/user-attachments/files/33196502/repro_pax_sparse_filter_isnull_after_delete.log)
   [repro_pax_sparse_filter_isnull_after_delete.sql](https://github.com/user-attachments/files/33196501/repro_pax_sparse_filter_isnull_after_delete.sql)
   
   **Steps to Reproduce**
   ```
   psql -e -d <db> -f repro_pax_sparse_filter_isnull_after_delete.sql
   ```
   
   ### Operating System
   
   rocky9
   
   ### 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://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).
   


-- 
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-unsubscribe@cloudberry.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org