dbForge compilation issue with enum?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
stouif
Posts: 3
Joined: Mon 07 Oct 2013 00:24

dbForge compilation issue with enum?

Post by stouif » Mon 07 Oct 2013 00:43

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

alexa

Re: dbForge compilation issue with enum?

Post by alexa » Tue 08 Oct 2013 08:09

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.

stouif
Posts: 3
Joined: Mon 07 Oct 2013 00:24

Re: dbForge compilation issue with enum?

Post by stouif » Fri 08 Nov 2013 15:08

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?

alexa

Re: dbForge compilation issue with enum?

Post by alexa » Mon 11 Nov 2013 10:28

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.

stouif
Posts: 3
Joined: Mon 07 Oct 2013 00:24

Re: dbForge compilation issue with enum?

Post by stouif » Fri 15 Nov 2013 13:58

waiting patiently.

alexa

Re: dbForge compilation issue with enum?

Post by alexa » Fri 29 Nov 2013 09:45

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.

Post Reply