With a direct MySQL (Native) connection, all of my databases are shown and all are expandable to show their tables EXCEPT for the one database which is named
a.b, ie. it has a period in its name. Database
a.b does contain tables, but there is no way to display them with LO Base.
If I connect with MySQL (JDBC) instead, then that
a.b database is not even shown.
MySQL v8 permits a period in the database name provided that the name is quoted (MySQL uses the backtick for quoting schema object names).
So, is there some LO restriction regarding the use of special characters in MySQL schema object names? Or is there a way to use MySQL quoting when specifying the database name in LO Base?