# Modifies connection state
---
- Properties: random-context
- suppressed: true

---
- Include: all-update-schema.yaml
---
- Statement: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED NO SNAPSHOT;
---
- Statement: UPDATE customers SET name = 'Kilroy' WHERE cid = 1;
- error: [25003]
---
- Statement: select * from customers;
- output: [[1,Smith],[2,Jones]]
---
- Statement: select * from orders 
- output: [[101,1,'2011-03-01'],[102,1,'2011-03-02'],[201,2,'2011-03-03']]
---
- Statement: select * from items 
- output: [[1011,101,1234,100],[1012,101,4567,50],[2011,201,9876,1]]
---
- Statement: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;
...

Add a test for read-only implication of long-running query.
Add a test for read-only implication of long-running query.
