Bug 127665 - Address Datasource Wizard shows incorrect list of possible datasource types when compared to File> New >Database> connect to exising database
Summary: Address Datasource Wizard shows incorrect list of possible datasource types w...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.3.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Wizard
  Show dependency treegraph
 
Reported: 2019-09-20 13:49 UTC by Alex Thurgood
Modified: 2022-12-26 07:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
What I see in master (37.86 KB, image/png)
2019-09-25 15:37 UTC, Xisco Faulí
Details
Base Wizard (48.00 KB, image/png)
2019-09-25 15:38 UTC, Xisco Faulí
Details
Datasource list of possible connections with Base wizard (82.27 KB, image/png)
2019-09-26 13:58 UTC, Alex Thurgood
Details
Datasource list of possible connections with Addressbook definition wizard (62.32 KB, image/png)
2019-09-26 13:58 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2019-09-20 13:49:51 UTC
Description:
For comparison :
1) Start LO
2) Start the DB creation wizard
3) Choose connect to existing DB 
4) Click on the dropdown menu
5) Observe the list of possible connections
6) Cancel


7) Now, try File > Wizard > Address Datasource
8) Choose Other External Datasource
9) Click on Next, then Parameters/Settings
10) Click on the dropdown menu of available datasource connections
11) Note how the list differs to that above - it shouldn't they should be identical
12) Also note that there is no native mysql driver connection in this list, whereas the mysql native driver connector extension has been included by default since 6.2

Steps to Reproduce:
See above

Actual Results:
The dropdown lists are different. This is both wrong (from a coding point), and wrong from a UI perspective.

Expected Results:
The dropdown lists should be identical. The address datasource wizard should use the same datasource connection possibilities as the New Database wizard and include the various msyql options.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Xisco Faulí 2019-09-25 15:37:49 UTC
Created attachment 154498 [details]
What I see in master

What I see in

Version: 6.4.0.0.alpha0+
Build ID: cc65651a0490383f1a833bb6215d8ec4272d8b5d
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded
Comment 2 Xisco Faulí 2019-09-25 15:38:41 UTC
Created attachment 154499 [details]
Base Wizard
Comment 3 Xisco Faulí 2019-09-25 15:41:07 UTC
So the only difference I see is one has MySQL (JDBC ) and the other MySQL.
What other difference do you see ?
Comment 4 Xisco Faulí 2019-09-25 15:43:25 UTC
BTW, why is it a regression ?
Comment 5 Julien Nabet 2019-09-26 08:33:50 UTC
Sorry, I can't help here -> uncc myself.
Comment 6 Alex Thurgood 2019-09-26 13:57:23 UTC
Added comparison with LO4162, see screenshots
Comment 7 Alex Thurgood 2019-09-26 13:58:02 UTC
Created attachment 154551 [details]
Datasource list of possible connections with Base wizard
Comment 8 Alex Thurgood 2019-09-26 13:58:53 UTC
Created attachment 154552 [details]
Datasource list of possible connections with Addressbook definition wizard
Comment 9 Alex Thurgood 2019-09-27 08:54:12 UTC
The reason why it is a regression is that in the earlier version, all possibilities of connecting to mysql were displayed in the addressbook datasource definition wizard, i.e. JDBC, ODBC, native (if connector extension was installed), and yet now only MySQL(JDBC) is available.
Comment 10 QA Administrators 2021-12-02 04:43:33 UTC Comment hidden (obsolete)
Comment 11 Alex Thurgood 2021-12-07 11:22:02 UTC
Bug still present in 

Version: 7.2.1.2 / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

The addressbook datasource list still only shows the MySQL(JDBC) entry and not the more general MySQL entry which should allow the user to choose the type of driver connection over which the connection to the MySQL/MariaDB instance is to be made.
Comment 12 Alex Thurgood 2022-10-06 08:40:11 UTC
Bug still present in 

Version: 7.4.1.2 / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded