MySQL Bugs: #112818: Script editor never reports end of execution for use db then any sql

Bug #112818	Script editor never reports end of execution for use db then any sql
Submitted:	24 Oct 2023 18:17	Modified:	16 Sep 21:34
Reporter:	Kaiwang CHen (OCA)	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	Shell VSCode Extension	Severity:	S3 (Non-critical)
Version:	1.13.5	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
Script editor never reports end of execution for "use db; select 1". If the executed commands are reversed, "select 1; use db;" it is fine.

How to repeat:
1. Connect to a MySQL instance (8.0.34),
2. In the OPEN EDITORS view, click the "New MySQL Script" icon next to the connection node, cursor moves into the script editor, Untitled-1
3. In the script editor, type

use test;
select 1;

4. Click "Execute the script and print the the result as text"

"Execute ..." icons become disabled and "Stop execution ..." icon become high-lighted, however, it never returns to the state to execute the script unless switching to some other editor and back again.

Suggested fix:
Looks like some message is needed to update the UI.

Hello Kaiwang,

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:
 
This issue applies to the legacy MySQL Shell for VS Code extension that is no longer supported or maintained.
Please upgrade to MySQL Workbench 26.7 or newer, which supersedes it.