View Issue Details

IDProjectCategoryView StatusLast Update
0036404FPCDatabasepublic2019-12-07 11:38
Reporterfrancesco sammarcoAssigned ToMichael Van Canneyt 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
PlatformLinuxOSUbuntuOS Version19.10
Product Version3.3.1Product Build 
Target VersionFixed in Version 
Summary0036404: MySQL isolation level problem
DescriptionI 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

TagsNo tags attached.
Fixed in Revision
FPCOldBugId
FPCTarget-
Attached Files

Activities

francesco sammarco

2019-12-07 11:27

reporter  

mysql.zip (110,034 bytes)

Michael Van Canneyt

2019-12-07 11:38

administrator   ~0119677

This is normal. Refreshing does not refresh the transaction.

You must do a
SQLTransaction1.commit;
SQLTransaction1.starttransaction;
before opening/closing or refreshing the dataset in the Button2Click/Button3Click.

Issue History

Date Modified Username Field Change
2019-12-07 11:27 francesco sammarco New Issue
2019-12-07 11:27 francesco sammarco File Added: mysql.zip
2019-12-07 11:38 Michael Van Canneyt Assigned To => Michael Van Canneyt
2019-12-07 11:38 Michael Van Canneyt Status new => resolved
2019-12-07 11:38 Michael Van Canneyt Resolution open => no change required
2019-12-07 11:38 Michael Van Canneyt FPCTarget => -
2019-12-07 11:38 Michael Van Canneyt Note Added: 0119677