Devart Forums

Hi,
I am using dbForge Studio for MySQL 9.0.304 to connect to Azure Database for MySQL 5.7.29.

When creating a stored proc in SQL editor I immediately get an error when trying to type in a CREATE VIEW statement inside the stored proc. It crashes after typing SELECT in the code fragment below. We have the same issue in several stored procs in a large code base.

CREATE DEFINER = 'me'@'%'
PROCEDURE playground.db_make_views1()
BEGIN
CREATE VIEW test_view AS SELECT
END

Error description starts like this:
ExceptionId: 7ecb6479-6356-4ce8-82bb-f9f5d1dcf5e3
Message: Value does not fall within the expected range.
Source: Devart.DbForge.ScriptSupport.MySql
TargetSite: Void SetProcedureProperty(System.String, System.Object[])
HelpLink:
Type: System.ArgumentException
Stack:
at RV.wx.SetProcedureProperty(String , Object[] parameters)

Also sent an error report two times.
Thanks for your support.

We are aware of this issue and will fix it in the next product.

We would like to let you know that we released dbForge Studio for MySQL, v9.0.338 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/studio/download.html

Thank you for your help in improving dbForge Studio for MySQL.

Thank you. After updating to 9.0.338 it is working now.