Date: prev next · Thread: first prev next last
2010 Archives by date, by thread · List index


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


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.