I just started using the product, love it.
dbForge Professional Version: 6.0.493 running against mySql
I ran in to a curious issue with enum and compilation for debug (Ctrl-Alt-F7)
which generates a error, however the stored proc compiles (Ctrl-F7) fine.
it also runs fine. the error generated seems to be related to enum fields.
below is a minimum sniplet which you can run to reproduce
USE database1;
CREATE TABLE database1.table1 (
name varchar(50) DEFAULT NULL,
flag enum ('T', 'F') NOT NULL
)
ENGINE = INNODB
-----
CREATE PROCEDURE database1.testCompile()
BEGIN
DECLARE __name varchar(255);
DECLARE __flag enum('T','F') DEFAULT 'F';
DECLARE __x int;
DECLARE CONTINUE HANDLER FOR SQLSTATE '22007' SET __x = 0;
SELECT
table1.name,
table1.flag
INTO
__name, __flag
FROM
table1 ;
END
-
------ Compilation Procedure 'testCompile' started ------
Procedure:database1.testCompile(localhost): Error (1,1): You have an error ... for the right syntax to use near 'T','F')', cr_stack_depth)/*[cr_debug.2]*/;
CALL cr_debug.UPDATE_WATCH3('__x', _' at line 13
------ Compilation done ------
I must be doing something painfully obviously wrong so feel free to point out my inadequacies ?
thanks
dbForge compilation issue with enum?
Re: dbForge compilation issue with enum?
We were able to reproduce this issue and will fix it in one of the next versions of the product. We will notify you once it's available for downloading.
Re: dbForge compilation issue with enum?
Any thoughts on when this might be addressed. I checked as of Version: 6.0.568
and this still seems to be an issue. This particular bug prevents me from using the debugger
is there a work around? a date?
and this still seems to be an issue. This particular bug prevents me from using the debugger
is there a work around? a date?
Re: dbForge compilation issue with enum?
Unfortunately, we have no workaround for this.
In fact, we have already fixed this issue. However, the fix will be included in the next product build. Normally, we release a new product build once per month, so the next product build should be released this month. However, we can't provide you the exact date for this.
In fact, we have already fixed this issue. However, the fix will be included in the next product build. Normally, we release a new product build once per month, so the next product build should be released this month. However, we can't provide you the exact date for this.
Re: dbForge compilation issue with enum?
waiting patiently.
Re: dbForge compilation issue with enum?
We would like to let you know that the new build 6.0.622 of dbForge Studio for MySQL, where the issue you reported is fixed, has been released and is available for downloading http://www.devart.com/dbforge/mysql/stu ... nload.html
Thank you for your help in improving dbForge Studio for MySQL.
Thank you for your help in improving dbForge Studio for MySQL.