Download it now!
Bug 128950 - With LO Base 6.2, it is no longer possible to change the Database connection type in "MySQL (Native)"
Summary: With LO Base 6.2, it is no longer possible to change the Database connection ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2019-11-22 10:00 UTC by jnplg
Modified: 2019-12-02 12:53 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
dropdown options in LO 6163 vs 6201 (154.86 KB, image/jpeg)
2019-11-22 10:07 UTC, jnplg
Details
on Ubuntu 18.04 with LO 6.3.3.2 (45.94 KB, image/png)
2019-11-22 21:56 UTC, Stang
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jnplg 2019-11-22 10:00:26 UTC
In LibreOffice Base, starting with 6.2.0.1, it is no longer possible to change the Database connection type in "MySQL (Native)".
I used to work with the MySQL jdbc driver, and want to change to the new MySQL Native driver. That option is no longer available in an existing Base file with Edit / Database> / Connection Type...
I can create new Base files with the Databse connection type "MySQL (Native)", but I can not change existing Base files.
Comment 1 jnplg 2019-11-22 10:07:15 UTC
Created attachment 156034 [details]
dropdown options in LO 6163 vs 6201
Comment 2 Julien Nabet 2019-11-22 10:32:42 UTC
Could you give a try to last LO version 6.3.3?
Indeed, I can see Mysql direct (= native) on Win10 with LO 6.3.3
Comment 3 Alex Thurgood 2019-11-22 11:18:10 UTC
No repro with

Version: 6.3.3.2
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
Threads CPU : 8; OS : Mac OS X 10.14.6; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

I see a general entry called MySQL, choosing this and then clicking Next takes you to the choice of connections (ODBC, JDBC, native).
Comment 4 Alex Thurgood 2019-11-22 11:20:00 UTC
Also tested with

Version: 6.2.8.2
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
Threads CPU : 8; OS : Mac OS X 10.14.6; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

No repro, WFM.
Comment 5 Stang 2019-11-22 21:55:02 UTC
Have seen the same with recent versions and currently on Ubuntu 18.04 with:

Version: 6.3.3.2
Build ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

There is no other selection from Edit / Database> / Connection Type...

Will attach screenshot.
Comment 6 Stang 2019-11-22 21:56:38 UTC
Created attachment 156051 [details]
on Ubuntu 18.04 with LO 6.3.3.2
Comment 7 Julien Nabet 2019-11-22 22:09:02 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.

If I create MYSQL/JDBC file then try to change it to Mysql Native, it doesn't appear.
Sorry I had misread the initial comment.
Comment 8 Julien Nabet 2019-11-22 22:22:35 UTC
Pb is due to this part
118 // skip mysql connection variations. It is handled in another window.
119 if(sURLPrefix.startsWith("sdbc:mysql:") && !sURLPrefix.startsWith("sdbc:mysql:jdbc:"))
120   continue;

Commenting this block makes Mysql Native Mysql ODBC appear

(see https://cgit.freedesktop.org/libreoffice/core/commit/?id=b2cefc2e36925b4384eb0aea54aa2c6bcfb018a8)

Tamás: any thoughts here?
Comment 9 Julien Nabet 2019-11-23 09:28:34 UTC
I submitted a patch on gerrit to facilitate discussion:
https://gerrit.libreoffice.org/#/c/83547/
Comment 10 Alex Thurgood 2019-11-25 07:38:17 UTC
There is also a similar bug report pending for the display choice of available MySQL database connections in the mailmerge module. Ideally, everything should be consistent. Currently, we have 3 different displays depending on how the user accesses the list choice of db connections.
Comment 11 Alex Thurgood 2019-12-02 12:53:37 UTC
For the bug requiring consistency in the listing of available DB connections, see also bug 127665