looks like the same as the child nodes of a server node

I am trying to use this driver to connect to ClickHouse using MySql protocol.

To do that I need to add client option

allowPublicKeyRetrieval=true

How can I add client optiosn for the MySql driver?

remove the database view under General section

Issue Type: Bug

Restart it's needed to connect to a rebooted server even the connection was already restored and I've forced to restart the entire Azure Data Studio to solve it.

Azure Data Studio version: azuredatastudio 1.42.0 (22f384e569bc90d8b3231cc8c8cff99ea16c5052, 2023-03-17T18:15:48.982Z)
OS version: Windows_NT x64 10.0.19044
Restricted Mode: No
Preview Features: Enabled

I have one Server using Azure Database for MySQL. Inside that server, I have 4 user db's. Inside ADS, I am able to expand two of them, but two of them I get: Error: Failed to expand node when trying to expand them. The data is fine inside these two databases and I can query them, I just can't use the server explorer to expand them. I originally thought it was because I created the db using another application, but then dropped it and created it within ADS. It stills gives the error when expanding.

Host OS: Ventura 13.1 with arm
ADS 1.40.1

Hello,

When setting up the connections, if you try to configure multiple MariaDB/MySQL instances, the 1rst connection is overwriten.

Senario: 2 instances of both MariaDB and MySQL on localhost

• 1 connection to MariaDB on port 3306
• 1 connection to MySQL on port 3307

If you force the .json setting manualy, both connections settings are handled (no sure it stay like this for long), but both connections are opened at the same time when you click on 1 of those (and the 2nd server tree is not displayed).

I tested here with 2 diffrents RDMS instances (MariaDB and MySQL) thru Docker, but I meet the the same issue with multiple instances of MariaDB, thru network, with diffrent ports.

Regards

Hello

I created a new mysql database on https://www.freemysqlhosting.net. And while connection this database on azure datastudio when I receive an error that (1043, 'Bad handshake')i

Steps to Reproduce:

1. Create a mysql database on https://www.freemysqlhosting.net
2. Try to connect this database on AzureDataStudio Insiders.

If I select MySQL server -> Manage, server dashboard opens up. From the list of databases, if I select 'New Query' from Actions tab on any of the databases, the query page opens in disconnected mode. Ideally it should open connected to the mysql server with the selected database as default in database dropdown.

Hello, i have an issue using a typical MySQL/MariaDB 'START TRANSACTION' statement.

I'm using 'SET autocommit = 0' to disable autocommit (works well)
and then a 'ROLLBACK', wich looks to have no effect in Azure Data Studio :-/

I also tryed my script with some other IDEs, and it works fine on both MySQL and MariaDB (see attached).
MariaDB__AUTOCOMIT-COMMIT-ROLLBACK.sql.txt

Did i missed something with Azure Data Studio connection settings or is that a bug on the connector ?

Regards

There are a lot of "resolutions" packages in the package.json for this extension

https://github.com/microsoft/azuredatastudio-mysql/blob/main/package.json#L429

This is not something I recommend doing except as a last resort. It can easily cause unexpected behavior and subtle bugs since you have no idea whether the new versions actually fully work with the things that are using them - and it means later on if the parent packages are updated it's very easy to have these be missed and result in older versions being used even when a newer version is requested by the parent package.

For security alerts the general flow I use for determining how to fix them is :

1. Update the package directly if it's a top-level dependency
2. If it's a descendent package then try to update the root package bringing in the dependency with a newer version
3. If there isn't a newer version that updates the vulnerable package check the parent package repo to see if there's an issue opened and what workarounds may exist
4. If none of the above are possible then verify that the alert actually impacts you - many of them don't (especially given the context we run in as an Electron process). This doubly goes for devDependencies like mocha - those can almost always be dismissed as "acceptable risk"
5. And finally if you have a package which could impact your extension but it's not possible to update directly then you can use resolutions.

When writing a line comment using '--' the line turns green and is processed. In MySQL, a single line comment is prefixed with '#'. When I use '#' the line is not processed, but doesn't turn green, where lines prefixed with '--' are processed part of the statement.

Version: 1.40.0-insider
Commit: 16721cac0012ccbf2e45725c648947fc09b6b2fc
Date: 2022-10-04T05:59:55.218Z (13 hrs ago)
VS Code: 1.62.0
Electron: 13.6.6
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Darwin x64 21.2.0

Hardware: 14" Macbook Pro, M1 Max

Couldn't wait to test this (MySQL extension for insider preview) out, but getting this error when I open Azure Data Studio:

[Error - 12:38:28 PM] Starting client failed
Launching server using command /Users/xxxxxxx/.azuredatastudio-insiders/extensions/microsoft.azuredatastudio-mysql-0.2.1/out/ossdbtoolsservice/OSX/v1.6.0-mysql/mysqltoolsservice/ossdbtoolsservice_main failed.

Hi,
Script as Create does not work on Stored Procedures and Functions. it returns Scripting Failed. Works with Views and Tables.

When returning a bit(1) column in a query, the following exception is thrown:

Request query/subset failed.
Message: Unhandled exception while handling request method query/subset: "unpack requires a buffer of 4 bytes"
Code: -32603

Link to point to is https://aka.ms/azure-mysql-docs if the connection is Azure connection and if the connection is local 127.0.0.1 or localhost learn more link will point to https://dev.mysql.com/doc/

Log details are below.

[Error - 16:33:47] Request query/subset failed.
Message: Unhandled exception while handling request method query/subset: "unpack requires a buffer of 4 bytes"
Code: -32603
[Error - 16:33:47] Request query/subset failed.
Message: Unhandled exception while handling request method query/subset: "unpack requires a buffer of 4 bytes"
Code: -32603

Title : Azure database for MySQL Flexible Server
Text : Best for workloads that require more control, zone resiliency, and predictable performance. Feature set includes Latest major and minor versions, IOPs scaling, Custom 1 hour maintenance window and better cost optimization.

Terms of use and privacy links

Terms of use
Privacy policy
azdata license terms will be same for all extensions in ADS

Check if we can hide required tools table , if not we can leave it but investigate this

yarn run compile on extension has below compilation errors:

C:/Users//Source/Repos/azuredatastudio-mysql/node_modules/azdata/azdata.d.ts(743,3): error TS2300: Duplicate identifier "<identifier_name>"

          I am seeing this same issue with server connection on build 1.41.1. Can we get this item re opened? The problem is occurring for me with MySQL server connections using a database name value of 'default'. If I select a specific database within the server sometimes the directory tree will load however too much of the info is specific to the specifically selected db.

Originally posted by @LtFarns in microsoft/azuredatastudio#12992 (comment)

Building repo failing with below error:

Connection to MySQL using "SSL Disable" option is failing with error.

Add a snippets.json file similar to the one in the PostgreSQL extension

Obviously this extension is still in it's infancy, but are there plans to add an explain button that is available with SQL Server?

How to View the Query Execution Plan in Azure Data Studio (SQL Server)

If you want to see MariaDB support in Azure Data Studio, click the thumbs up sign.

Note: Please keep comments to this issue focused on discussions of what you would like to see instead of +1 comments.

"[Check out Accessibility Insights!] - Identify accessibility bugs before check-in and make bug fixing faster and easier."

#GitHub Tags:

#A11yMAS; #A11ySev3; #A11yTCS; #DesktopApp; #GH_MySQLextensionforAzureDataStudio_Linux_Mar23; #MySQL extension for Azure Data Studio; #WCAG2.1.1; #Linux; #Keyboard; #External; #External:AzureDataStudio; #FirstParty:22677;

Environment Details:​

Application Name: MySQL extension for Azure Data Studio
Application Version: 1.42.0-insider
Operating System: Ubuntu 20.04.2 LTS
GNOME Version: 3.36.8
ORCA: 42.2-1ubuntu1
Distributor ID: Ubuntu
Description: Ubuntu 22.10
Release: 22.10
Codename: kinetic

Repro Steps:

1. Launch Azure Data Studio application.
2. Select the Connections icon (if not already selected) from left bar.
3. TAB to "New connection" present besides to 'Servers' and hit ENTER key.
4. Fill all the required details and TAB to "Connect" and hit ENTER key.
5. Server gets connected. TAB to "Views and More Action", "New Connection", "New Server Group" and "Show Active Connections".
6. Observe that Tooltips provided "Views and More Action", "New Connection", "New Server Group" and "Show Active Connections" are not accessible using keyboard keys.

Actual Result:​

Tooltips provided for "Views and More Action", "New Connection", "New Server Group" and "Show Active Connections" are not accessible using keyboard keys.

Similar issue is also observed in below scenario:
Issue 1: Notebooks - Create

1. Launch Azure Data Studio application.
2. TAB to "File" and hit ENTER key. TAB to "New Notebook" and hit ENTER key.
3. TAB to "Collapse cells", "Clear Results", "Trusted" and "Run with parameter".
4. Navigate using TAB key and observe Tooltips provided for "Collapse cells", "Clear Results", "Trusted" and "Run with parameter" are not accessible using keyboard keys.

Expected Result:​

Tooltips provided "Views and More Action", "New Connection", "New Server Group" and "Show Active Connections" should be accessible using keyboard keys.

User Impact:

Keyboard users will not be able to get the information about these controls.

"Please do not close this bug. This bug should only be closed by TCS, C+AI Accessibility or the Divisional Driver."

Attachments

Video 3-30 at 12.37 (1).webm
Video 3-30 at 12.37.webm

"[Check out Accessibility Insights!] - Identify accessibility bugs before check-in and make bug fixing faster and easier."

#GitHub Tags:

#A11yMAS; #A11yWCAG2.1; #A11ySev2; #A11yTCS; #DesktopApp; #GH_MySQLextensionforAzureDataStudio_Linux_Mar23; #MySQL extension for Azure Data Studio; #WCAG1.4.11; #Linux; #NonTextContrast; #External; #External:AzureDataStudio; #FirstParty:22678;

Environment Details:​

Application Name: MySQL extension for Azure Data Studio
Application Version: 1.42.0-insider
Operating System: Ubuntu 20.04.2 LTS
GNOME Version: 3.36.8
ORCA: 42.2-1ubuntu1
Distributor ID: Ubuntu
Description: Ubuntu 22.10
Release: 22.10
Codename: kinetic

Repro Steps:

1. Launch Azure Data Studio application.
2. TAB to "File" and hit ENTER key. TAB to "New Notebook" and hit ENTER key.
3. TAB to "Cell" dropdown and hit ENTER.
4. Navigate using TAB key and observe that color contrast ratio of focus border over selected control is 1.3:1 which is less than 3:1.

Actual Result:​

Color contrast ratio of focus border over selected control is 1.3:1 which is less than 3:1.

Similar issue is also observed in below scenario:
Issue 1: Notebooks - Code cell

1. Launch Azure Data Studio application.
2. TAB to "File" and hit ENTER key. TAB to "New Notebook" and hit ENTER key.
3. TAB to "Cell" dropdown and hit ENTER. TAB to "Cell Code" and hit ENTER.
4. Navigate using TAB key and observe that color contrast ratio of focus border over selected control is 1.3:1 which is less than 3:1.

Expected Result:​

Color contrast ratio of focus border over selected control should be greater than or equal to 3:1.

User Impact:

Low vision users will not be able to see on which control the focus is, and will not be able to select the required list option.

"Please do not close this bug. This bug should only be closed by TCS, C+AI Accessibility or the Divisional Driver."

Attachment:

Hello ADS Team,
well... that's more a question than a real issue.

I use Azure Data Studio with the MySQL connector, to work on sevral MariaDB databases.

It looks like BEGIN NOT ATOMIC statement is not suported by the connector (and maybe aloso DELIMITER ??), witch are handled by MariaDB.

code example:

DELIMITER $$
BEGIN NOT ATOMIC

    IF 1 = 1 THEN
    	SELECT 'Hello';
    END IF;
   
END
$$
DELIMITER ;

I imagine that's "normal" because this is a MySQL connector (not a MariaDB connector), and some specific syntaxes are not compatible between both RDMS.

Question :
Have you planed to develop a specific MariaDB connector, that handle specific MariaDB syntax, not supported in MySQL ?
(ex: BEGIN NOT ATOMIC, for anonymous blocks)

I can see there is also an opened issue about this #90

Thanks in advance for your reply :-)
Regards

When using a connection over an unreliable and/or slow network in general the extension does not handle this well.

Examples:
If you switch wifi networks, you can no longer expand the database, even with a refresh, without completely disconnecting and re-connecting. - You get "Error: Failed to expand node"

If a network momentarily goes away, you can not run a query again without disconnecting and re-connecting completely, you get "Unhandled exception while executing query: local variable 'cursor' referenced before assignment"

This is different behavior than the SQL Server extension.

Issue Type: Bug

Executing this query, sometimes reports an error:

Query:
SELECT * FROM table_name WHERE id = An id; --a comment

Error:
Unhandled exception while executing query: local variable 'cursor' referenced before assignment

Azure Data Studio version: azuredatastudio 1.41.2 (0f0960d0e774e1ce903b79378addff96117c27a6, 2023-02-08T20:16:49.071Z)
OS version: Windows_NT x64 10.0.22621
Restricted Mode: No
Preview Features: Enabled

Azure Data Studio Version: 1.41.0-insider, 1.41.0
Extension: MySQL v0.2.4, v0.2.3
OS: MacOS Ventura (13.0.1) or MacOS Monterey

Extension successfully installed
MySQL Tools Service started

Trying to create a new connection of type MySql, to Server: localhost, user name: root, password password for root user here

Error Message : Bad handshake
ErrorCode : 1043

Connecting to the exact same MySQL server, with the same user & password, from a different client works fine.

When I want to explore the tables on my MariaDB server
the list of tables is not sorted alphabeticaly. This is very confusing.
I'm using the addin version 0.2.6
Server version is: 10.3.36-MariaDB-1:10.3.36+maria~ubu2004

We should hide this as it does not apply for mysql

If user clicks on it it fails

Azuredatastudio MySQL not compatible with Azure Data Studio 1.34.0
Is it somewhere mentioned what the minimal requirement version for Azure Data Studio is?

Save as options are not working from Notebook. Following message is shown:

Failed to save results. Could not find a serialization provider with the specified ID 'MySQL'

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

There are open compliance tasks that need to be reviewed for your azuredatastudio-mysql repo.

Action required: 4 compliance tasks

To bring this repository to the standard required for 2021, we require administrators of this and all Microsoft GitHub repositories to complete a small set of tasks within the next 60 days. This is critical work to ensure the compliance and security of your microsoft GitHub organization.

Please take a few minutes to complete the tasks at: https://repos.opensource.microsoft.com/orgs/microsoft/repos/azuredatastudio-mysql/compliance

• The GitHub AE (GitHub inside Microsoft) migration survey has not been completed for this private repository
• No Service Tree mapping has been set for this repo. If this team does not use Service Tree, they can also opt-out of providing Service Tree data in the Compliance tab.
• No repository maintainers are set. The Open Source Maintainers are the decision-makers and actionable owners of the repository, irrespective of administrator permission grants on GitHub.
• Classification of the repository as production/non-production is missing in the Compliance tab.

You can close this work item once you have completed the compliance tasks, or it will automatically close within a day of taking action.

If you no longer need this repository, it might be quickest to delete the repo, too.

GitHub inside Microsoft program information

More information about GitHub inside Microsoft and the new GitHub AE product can be found at https://aka.ms/gim or by contacting [email protected]

FYI: current admins at Microsoft include @alanrenmsft, @kenvanhyning, @rgreenMSFT, @vickyharp, @kburtram, @Charles-Gagnon, @qifahs, @akamath46297

If there is an active object explorer session and we use edit connection to create a duplicate session or directly from server tab, object explorer tab does not expand for the session.

Other features seem unaffected.

Issue Summary:
Databases list is not getting loaded on clicking select database in new query.

Steps to Reproduce:

1. Create a new connection to Azure MySQL flexible server.
2. Create new query.
3. Click on select database.

Azure Data Studio Details:
Version: 1.37.0 (user setup)
Commit: d904740d93d7df76a0ba361f20e4351813b57645
Date: 2022-06-14T01:05:12.352Z
VS Code: 1.59.0
Electron: 13.6.6
Chrome: 91.0.4472.164
Node.js: 14.16.0
V8: 9.1.269.39-electron.0
OS: Windows_NT x64 10.0.19044

If I connect to a server in servers view or azure view, then I won't be able to open it in the other view.

mssql doesn't have such problem.

Issue Type: Bug

1. Run several instances of mysql on localhost, all on different ports
2. set up the same username on each database
3. set different passwords for that username in each different database
4. set up respective server connections in Azure Data Studio for each database with respective usernames passwords (and Remember Password)
5. connect to each database
6. close Azure studio
7. open Azure studio and attemp to connect to each DB again
8. notice that the password send to each DB is identical, not the unique one saved with the connection

Extension version: 0.2.5
Azure Data Studio version: azuredatastudio 1.41.0 (Universal) (cf5e0fe1a33709e2a82dc94f42dbe88487803d62, 2023-01-24T17:29:04.297Z)
OS version: Darwin arm64 22.3.0
Restricted Mode: No
Preview Features: Enabled

Using MySql connections, sometimes, I can't uncollapse the connection and I'm unable to see the folders, datases, system databases, users, events, etc.

If I restart Azure data studio it works fine.

Desired behavior is to show message that "There are not tables within this database. Click on New Query to start creating a table or start with [sample schema] (https://go.microsoft.com/fwlink/?linkid=2175085)"

If user clicks on refresh and the database has no tables we show the same message as above

Today behavior -

With MySQL, if a connection fails, for example if VPN is disconnected and then re-connected, currently the query tab will not "Recover" and requires you to disconnect or change the connection. This is different behavior than SQL Server and not an optimal user experience. If a connection has failed, resources should be dropped and when you click execute, it should attempt to reconnect if necessary.

Update the README, Wiki, and Documentation files for this repo to match those of the PG extension.

Hi team,

I can not connect to PlanetScale MySQL instance. DBeaver is working well.
Can you help to double check it?

Host: gcp-us-central1.connect.psdb.cloud
DB: planetscale-free-db
User: hv84ram6usxf9kab97nd
Password: pscale_pw_BchvgmMshdOJSBvLeJRRZ7PMAVlaLDH7wUKEGN5MYt6