Bug #94895 Operation failed: There was an error while applying the SQL script to the databa
Submitted: 3 Apr 2019 23:21 Modified: 14 Apr 2019 17:19
Reporter: Fábio Bonito Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S7 (Test Cases)
Version:8.0.15 OS:Windows (Microsoft Windows 10 Home Single Language)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[3 Apr 2019 23:21] Fábio Bonito
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\fabio\AppData\Roaming\MySQL\Workbench\log\wb.log]

How to repeat:
Executing:
UPDATE `escola_curso`.`notas` SET `id_nota` = '1' WHERE (`id_nota` = '8');
UPDATE `escola_curso`.`notas` SET `id_nota` = '3' WHERE (`id_nota` = '9');
UPDATE `escola_curso`.`notas` SET `id_nota` = '5' WHERE (`id_nota` = '10');
UPDATE `escola_curso`.`notas` SET `id_nota` = '2' WHERE (`id_nota` = '11');
UPDATE `escola_curso`.`notas` SET `id_nota` = '6' WHERE (`id_nota` = '12');
UPDATE `escola_curso`.`notas` SET `id_nota` = '1' WHERE (`id_nota` = '13');
UPDATE `escola_curso`.`notas` SET `id_nota` = '2' WHERE (`id_nota` = '14');

Operation failed: There was an error while applying the SQL script to the database.
ERROR 1062: 1062: Duplicate entry '1' for key 'PRIMARY'
SQL Statement:
UPDATE `escola_curso`.`notas` SET `id_nota` = '1' WHERE (`id_nota` = '13')

ERROR 1062: 1062: Duplicate entry '2' for key 'PRIMARY'
SQL Statement:
UPDATE `escola_curso`.`notas` SET `id_nota` = '2' WHERE (`id_nota` = '14')
[14 Apr 2019 17:19] MySQL Verification Team
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.