https://bugs.freedesktop.org/show_bug.cgi?id=61871
Priority: medium
Bug ID: 61871
Assignee: [email protected]
Summary: EDITING: Query of a multiplication with fields of two
tables don't refresh.
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.3.4 release
Component: Database
Product: LibreOffice
Created attachment 75979
--> https://bugs.freedesktop.org/attachment.cgi?id=75979&action=edit
Two queries - one doesn't refresh the multiplication, the other does.
Following query in the attached database don't refresh the field "sum", when a
new input in "count" and "goods_ID" is made:
SELECT "sale".*, "goods".*, "goods"."price" * "sale"."count" AS "sum" FROM
"sale", "goods" WHERE "sale"."goods_ID" = "goods"."ID"
All fields of "sale" and "goods" are shown, not the content of the
multiplication-field "sum".
This query works:
SELECT "a".*, ( SELECT "price" * "a"."count" FROM "goods" WHERE "a"."goods_ID"
= "ID" ) AS "sum" FROM "sale" AS "a"
All fields of "sale" are shown, new values could be added and the "sum" is
refreshed automatically in the correlated subquery. But this query doesn't work
in LO 4.* - there isn't shown any content of a subquery, see bug
https://bugs.freedesktop.org/show_bug.cgi?id=61166
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
