[Libreoffice-bugs] [Bug 133366] New: FILEOPEN: Base views not showing on remote mySQL database, direct connection

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133366
           Summary: FILEOPEN: Base views not showing on remote mySQL
                    database, direct connection
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: IA64 (Itanium)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: registrazioni at claudioromeo.it

I created a simple and empty mySQL database on a remote web server
(10.1.35-MariaDB).
Then I created a LibreOffice Base document linked to it by a direct connection
(neither ODBC nor JBDC). The connection (password protected) works fine.
By means of Base, I created a simple table (an automatic ID field and two
VARCHAR fields) and populated it. Everything works fine.
Then I created a view to sort the data according to the criteria I need.
Everything works fine.
But when I try to view the view (sorry: my English is basic), an error message
appears saying that it was impossible to show the data: “Prepared statement
needs to be re-prepared”.
I am not an expert, so I can’t figure out what’s happening. Is it an issue? Or
am I doing something wrong?
I’m using Ubuntu Linux 20.04. LibreOffice version: 6.4.3.2 Build ID:
1:6.4.3-0ubuntu0.20.04.1

-- 
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/20200525/ef9df0ce/attachment.htm>