Priority: P1: Critical
Affects Version/s: 5.15.0
Fix Version/s: None
Component/s: SQL Support
Environment:Tested on macOS 10.14.6 with Qt 5.15.0. Using a MySql Database
Also tested on Windows 10 with MinGW64.
Using removeRows on a QSqlTableModel to remove a row that has been externally deleted from the table (i.e. not using the model) leaves a row in cache with Invalid data for all columns. This row with invalid data cannot be removed from the model other than a full reselect().
RemoveRows returns "true" and no error is reported. It should either properly erase the row from the cache since it is not in the table or report an error.
Current behavior leaves the model in a non working state and there is no way to detect it.
|For Gerrit Dashboard: QTBUG-88014|
|396667,2||qsql: Qsqltablemodel::RemoveRows() return value exceeded expectations||dev||qt/qtbase||Status: NEW||0||0|