Error on CREATE VIEW statement in stored proc

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
SchmittDotNet
Posts: 7
Joined: Mon 15 Jun 2020 15:41

Error on CREATE VIEW statement in stored proc

Post by SchmittDotNet » Tue 16 Jun 2020 16:35

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.

alexa

Re: Error on CREATE VIEW statement in stored proc

Post by alexa » Wed 17 Jun 2020 07:32

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

alexa

Re: Error on CREATE VIEW statement in stored proc

Post by alexa » Wed 24 Jun 2020 13:48

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.

SchmittDotNet
Posts: 7
Joined: Mon 15 Jun 2020 15:41

Re: Error on CREATE VIEW statement in stored proc

Post by SchmittDotNet » Thu 25 Jun 2020 08:12

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

Post Reply