https://bugs.documentfoundation.org/show_bug.cgi?id=170706
Bug ID: 170706
Summary: MariaDB direct connection: View with Sub-Sub-Select
gives wrong result when refreshing view
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205451
--> https://bugs.documentfoundation.org/attachment.cgi?id=205451&action=edit
SQL-code for getting 3 tables and a view.
Attached is a SQL-Code for 3 Tables and a view in MariaDB.
Open a connection to MariaDB with direct driver from LO.
Execute the code to get the test situation.
If all works well you get 3 tables and a view.
Execute the view.
3 columns appear.
Have a look at column "Offen" - remember some values.
Press the icon "Refresh" (or "Data" → "Refresh")
Nearly all values in this column will give wrong values.
Mark a column like "Brutto", which isn't sorted.
Press the icon "Sort Ascending" (or "Data" → "Sort Ascending")
Right values will reappear for column "Offen".
Code of the view could be also used for a query. In a query the result will
always be right. Only in a view the refreshing gives wrong result.
You could work around this code by other SQL in a view, but refreshing should
never give other results than executing a view directly.
Tested with
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
… but might be a very old bug.
--
You are receiving this mail because:
You are the assignee for the bug.
