Hi Harvey, > > OpenSUSE provides only the ODBC connector for mariadb, no JDBC > connector.
I'm using only JDBC with OpenSUSE. You have to dowload it directly from MariaDB > > What I saw was: > > SELECT * <tablename>.*, <tablename>.<Field1>, <tablename>.<Field2> FROM > <schema>.<tablename> <tablename> ORDER BY <Field1> ASC, <Field2> ASC > > After deleting the text ', <tablename>.<Field1>, <tablename>.<Field2>' > from the SQL query, the extra fields were not displayed on running the > query. But on saving the query again, the deleted text was added again, > and it's back to square one. > > Is this a bug? Yes, it is a buggy behaviour of the editor. Have tested this: Created a query for MariaDB, tried to set a field to "unvisible", which should only be used to sort the query, but it doesen't work. The behaviour is the same in the internal Firebird database, but it will work right with internal HSQLDB. Would your report the bug? I will confirm it. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy