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.
Error on CREATE VIEW statement in stored proc
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Error on CREATE VIEW statement in stored proc
We are aware of this issue and will fix it in the next product.
Re: Error on CREATE VIEW statement in stored proc
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 for your help in improving dbForge Studio for MySQL.
-
- Posts: 7
- Joined: Mon 15 Jun 2020 15:41
Re: Error on CREATE VIEW statement in stored proc
Thank you. After updating to 9.0.338 it is working now.