[de-discuss] [Bug 32506] Find & Replace for Base

Hallo Robert,

verfolgst Du den Bug 32506 mit?
Wenn ja: was meinst Du dazu bzw. magst Du Dich an der Diskussion beteiligen?

Gruß

Jochen


-------- Weitergeleitete Nachricht --------
Betreff:        [Bug 32506] Find & Replace for Base
Datum:  Wed, 06 Apr 2016 16:12:45 +0000
Von:    bugzilla-daemon@bugs.documentfoundation.org
An:     dr@jochenschiffers.de



*Comment # 26 
<https://bugs.documentfoundation.org/show_bug.cgi?id=32506#c26> on bug 
32506 <https://bugs.documentfoundation.org/show_bug.cgi?id=32506> from 
Lionel Elie Mamane <mailto:lionel@mamane.lu> *

(In reply to ribotb fromcomment #25 <show_bug.cgi?id=32506#c25>)

> A foreign key in a relationship/table (T1) is a primary key in another  > relationship/table (T2). Which rule will be used in the case where 
the new > value of the foreign key in T1 is not a primary key in T2?

LibreOffice will not do anything different in that case. The database engine
will raise an error.

> Knowing that the value of the new foreign key in T1 must exist as  a valid  > value (one of the primary key values) in T2, or must be equal to a 
null > value, will a new record be created in T2 to respect the rules of 
> referential integrity?

No.

> 'Find &replace' of a primary key will be allowed?

Yes.

> If allowed, the update of  > the value of the primary key must be done according with the update 
rules > defined for the database (Tools > Relations).

Again, LibreOffice will not do anything different in that case. The database
engine will either cascaded the update (if that relation is configured like
that), or raise an error.

> In my view, 'Find & Replace' operation is not a correct Relational DataBase  > Management :-))

Not always, but also not never.

> If implemented, this 'Find & Replace' operation should only  > be allowed on the tables without 
> constraints of referential integrity.

LibreOffice should not try to guess when it will work or make sense. The user
asks for it, do it. If it fails, show the error message. If it corrupts the
data, the user asked for it. After all she/she could have done the same
manually.

------------------------------------------------------------------------
You are receiving this mail because:

 * You are on the CC list for the bug.




--
Liste abmelden mit E-Mail an: discuss+unsubscribe@de.libreoffice.org
Probleme? http://de.libreoffice.org/hilfe-kontakt/mailing-listen/abmeldung-liste/
Tipps zu Listenmails: http://wiki.documentfoundation.org/Netiquette/de
Listenarchiv: http://listarchives.libreoffice.org/de/discuss/
Alle E-Mails an diese Liste werden unlöschbar öffentlich archiviert