[Koha-bugs] [Bug 1546] New: REPLACE statements

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1546

           Summary: REPLACE statements
           Product: Koha
           Version: HEAD
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: blocker
          Priority: P1
         Component: Database
        AssignedTo: chris.cormack at liblime.com
        ReportedBy: paul.poulain at free.fr
         QAContact: koha-bugs at nongnu.org


There are REPLACE statements that MUST be removed, for 2 reasons (the 2nd one
being a BLOcking, undoubtfully)
- it's not SQL92
- it act as a delete/insert. thus, if you have foreign keys, it delete all the
children !!! IPT just tried to modify authority description, and ... the
authority framework is gone ! that's just because of the REPLACE.

I've already fixed authority & catalogue framework definition, that have the
problem, patch on the way.

There are some other places using REPLACE, we must at least check that FK are
not concerned by them




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.