[Libreoffice-bugs] [Bug 118492] (Correct) SQL-Query (wrongly) returns 0 (null) Values in specific Column. DBMS: PostgreSQL

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118492

--- Comment #1 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 143261
  --> https://bugs.documentfoundation.org/attachment.cgi?id=143261&action=edit
query after change

I'm using a fresh postgresql 10 install on Ubuntu 18.04 and Libo with
postgres:SDBC. 

Created the three tables and a few records.

SELECT "SP"."id", "SP"."hämo", "S"."situation" 
FROM "situation_p" "SP", "situation" "S" 
WHERE "SP"."situation" = "S"."id"

got just the output you did in Base

changed it to: 

SELECT "SP"."id", "SP"."hämo", "S"."situation" 
FROM "situation_p" "SP", "situation" "S" 
WHERE "S"."id" = "SP"."situation"

and get what seems to be what you are looking for. (screen shot attached)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180701/b1a98eb0/attachment.html>