Date: prev next · Thread: first prev next last
2019 Archives by date, by thread · List index


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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.