[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-bugs] [Bug 1546] New: REPLACE statements
From: |
bugzilla-daemon |
Subject: |
[Koha-bugs] [Bug 1546] New: REPLACE statements |
Date: |
Fri, 2 Nov 2007 04:10:36 -0700 (PDT) |
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: address@hidden
ReportedBy: address@hidden
QAContact: address@hidden
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.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-bugs] [Bug 1546] New: REPLACE statements,
bugzilla-daemon <=