MySQL isolation level problem
Original Reporter info from Mantis: xinyiman
-
Reporter name: francesco sammarco
Original Reporter info from Mantis: xinyiman
- Reporter name: francesco sammarco
Description:
I open two instances of the same program and on one I apply changes and I save them. When I go to refresh or close and reopen the query on the second instance I don't see the update. I have to close and reopen the connection.
Look at the attached example.
Example DDL:
CREATE TABLE `tabella1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`descrizione` varchar(45) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
Mantis conversion info:
- Mantis ID: 36404
- OS: Ubuntu
- OS Build: 19.10
- Platform: Linux
- Version: 3.3.1