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

   ### Search before asking
   
   - [x] I searched in the 
[issues](https://github.com/apache/paimon-rust/issues) and found nothing 
similar.
   
   
   ### Please describe the bug 🐞
   
   When a temporary table or view shadows a persistent table, SELECT reads the 
temporary object, but UPDATE and DELETE can modify the hidden persistent table.
   
   ### Reproduction
   
   ```sql
   CREATE TABLE default.t (id INT);
   INSERT INTO default.t VALUES (1), (2);
   
   CREATE TEMPORARY VIEW default.t AS
   SELECT CAST(999 AS INT) AS id;
   
   SELECT * FROM default.t; -- Returns 999
   
   DELETE FROM default.t WHERE id = 1;
   
   DROP TEMPORARY VIEW default.t;
   SELECT * FROM default.t; -- Returns only 2
   ```
   
   The same issue affects UPDATE and temporary tables.
   
   ### Solution
   
   Reject unsupported UPDATE and DELETE operations on temporary objects before 
modifying the underlying persistent table.
   
   ### 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