[Koha-bugs] [Bug 1368] Use of FOREIGN_KEY_CHECKS = 0

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1368

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jonathan.druart at biblibre.co
                   |                            |m,
                   |                            |kyle at bywatersolutions.com,
                   |                            |tomascohen at gmail.com

--- Comment #5 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
This is currently the oldest open bug report, filed in May 2010. 

A quick git grep for "SET FOREIGN_KEY_CHECKS" reveals a lot of occurrences (see
below)

- Do we intend on fixing those? Or should this be a WONTFIX?
- What is the goal here? Should we move some of the ideas from here to new more
specific bug reports?


installer/data/mysql/de-DE/optional/sample_creator_data.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/en/optional/sample_creator_data.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/es-ES/optional/sample_creator_data.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/it-IT/marcflavour/unimarc/necessari/authority_framework.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/marcflavour/unimarc/necessari/authority_framework.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql:SET
FOREIGN_KEY_CHECKS=0; 
installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/auth_val.sql:SET FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/auth_val.sql:SET FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/class_sources.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/class_sources.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/message_transport_types.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/message_transport_types.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/sample_creator_data.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/it-IT/necessari/sample_holidays.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/sample_holidays.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/sample_itemtypes.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/sample_itemtypes.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/sample_notices_message_attributes.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql:SET
FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql:SET
FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/stopwords.sql:SET FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/stopwords.sql:SET FOREIGN_KEY_CHECKS=1;
installer/data/mysql/it-IT/necessari/userflags.sql:SET FOREIGN_KEY_CHECKS=0;
installer/data/mysql/it-IT/necessari/userflags.sql:SET FOREIGN_KEY_CHECKS=1;
installer/data/mysql/kohastructure.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/labels_upgrade.pl:    SET FOREIGN_KEY_CHECKS = 0;
installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
installer/data/mysql/patroncards_upgrade.pl:    SET FOREIGN_KEY_CHECKS = 0;
installer/data/mysql/updatedatabase.pl:    $dbh->do('SET FOREIGN_KEY_CHECKS=0
');
installer/data/mysql/updatedatabase.pl:    $dbh->do('SET FOREIGN_KEY_CHECKS=1
');
installer/data/mysql/updatedatabase.pl:    $dbh->do('SET FOREIGN_KEY_CHECKS=0
');
installer/data/mysql/updatedatabase.pl:    $dbh->do('SET FOREIGN_KEY_CHECKS=1
');
installer/data/mysql/updatedatabase.pl:    $dbh->do("SET FOREIGN_KEY_CHECKS=0
");
installer/data/mysql/updatedatabase.pl:    $dbh->do("SET FOREIGN_KEY_CHECKS=1
");
misc/maintenance/fix_mysql_constraints.pl:    $dbh->do("SET
FOREIGN_KEY_CHECKS=0");
misc/migration_tools/22_to_30/phrase_log.sql:/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
misc/migration_tools/bulkmarcimport.pl: $dbh->do("SET FOREIGN_KEY_CHECKS = 0");
misc/migration_tools/bulkmarcimport.pl: $dbh->do("SET FOREIGN_KEY_CHECKS = 1");

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are the assignee for the bug.
You are watching all bug changes.