Bonjour Bernard,
2010/10/29 ribotb <ribotb@gmail.com>:
Bonsoir Sophie,
J'ai préparé les éléments pour ouvrir un problème dans bugzilla. J'ai un
petit souci avec deux termes d'algèbre relationnelle que je ne sais pas
traduire : il s'agit de equi-jointure et théta-jointure. Tu crois que je
peux laisser ça comme ça ?
avec join à la place de jointure, ça passera :)
Voici comment pourrait se présenter la fiche :
Summary : SQL queries involving a join make incorrect results.
Description :
Queries are created by clicking the icon in the left pane application
window's databases.
The following cases were tested:
- "equi jointure" : a simple join that displays the sex label for each
student
- inner join : same result as equi-jointure
- self join : displays the number of students who have a note in the subject
number 1 less than
the note obtained in the subject number 2.
- left outer join : displays all students having whether or not, a note. If
a student does not
have a note, the field Numetu of the corresponding table (NOTES) will be
NULL.
- right outer join : displays all students who have at least one note
- "théta-jointure" : displays for each student, how many are before him on
the alphabetical list names.
Queries with union (UNION, UNION ALL) and intersection (INTERSECT) of tables
gave correct results.
Attachment :
Ma mini-base de test, les résultats obtenus avec OOo 3.2.1, les résultats
obtenus avec LibO 3.3.0 beta 2
Merci de me donner ton avis.
Ah, bien c'est super ! merci beaucoup :) Je ne sais pas qui va
corriger les bugs Base dans notre équipe de développeurs, mais je vais
veiller à ce que le bug soit attribué rapidement.
À bientôt
Sophie
--
Founding member of The Document Foundation
--
E-mail to discuss+help@fr.libreoffice.org for instructions on how to unsubscribe
List archives are available at http://fr.libreoffice.org/lists/discuss/
All messages you send to this list will be publicly archived and cannot be deleted
Context
- Re: [fr-discuss] [Base] jointures (continued)
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.